Skip to Content
avatar image
Former Member

hana database log volume stat free

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


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 26, 2017 at 01:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded