Skip to Content
0

hana database log volume stat free

Jul 26, 2017 at 11:33 AM

266

avatar image
Former Member

Hi Friends, Recently our secondary system was not available for some time due to network and power issue once the network is restored the system was resynchronize and all the services are active and in sync. When I go to Option volumes in HANA studio and open service indexserver and xsengine and select LOG then I see lot of log and its stat is FREE. I understood that when resynchronization has completed RetainedFree log segments on the primary will be marked as Free. How can I delete these logs on primary server where stat is free to retain the disk space please let me know the steps also do I have to stop database or need any downtime for this? Kindly give your expert advice..

Thanks and Regards

Ali.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Michael Healy
Jul 26, 2017 at 01:12 PM
0

Just execute the SQL : ALTER SYSTEM RECLAIM LOG......just for your information, please NEVER delete the logs, especially from OS, this will cuase your DB to be inconsistent.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Michael ,

Thanks for the update, Do we need any down time for this or we can execute this while system is up and running?

Thanks and Regards

Ali.

0

no downtime needed.....this is very easily find out btw. Please search in future

0