HANA Log volume Full

Log Volume is full & HANA DB, SAP system is not responding the follow the below steps to resolve the issue.

If we manually remove some file from the directory, data loss will happen & Hana system won't cam up after that. Recovery is the only option if we remove the file manually.

Issue - /hana/log - 100%

Solution -

      1. Stop HANA Database, 

   

       Login as SIDADM user and stop Hana DB Process, 

 HDB Stop 

      2. Change user to root,

          Go to /hana/log/SID/mnt00001

    

  default location - /usr/sap/SID/global/hdb/log/mnt0001

      3. Check the space usage of log files,

           du -ksh *

To start Hana DB at least 2 GB space is required, 

         

      4. Move one volume temporarily that having more than 2 GB to another location.

   

   example from above image :- hdb00005.00004 (Moving to /hana/data location)

   mv hdb00005.00004 /hana/data

      5. Create symbolic link to the new folder in the old location

    ln -s /hana/data/hdb00005.00004  /hana/log/SID/mnt00001/hdb00005.00004

6. Start the HANA Database

    Change user to SIDADM and start Hana DB,

    HDB start

7. Wait until log backup are performed in Hana System,

       8. Use the following SQL command to clean up the log volume.

            Once Log backup generated reclaim the space using below command, (on hdbsql)

     ALTER SYSTEM RECLAIM LOG;

      9. Stop the HANA database,

    HDB stop

10. Remove symbolic link,

     Change user to root,

     rm -f /hana/log/SID/mnt00001/hdb00005.00004 

 

     10. Move  the log volume back to the original location

          Go to log volume stored temporary location, 

   mv hdb00005.00004 /hana/log/SID/mnt00001

   

     11. Start the HANA Database again,

   Change user to SIDADM,

   HDB Start

Now the log Volume size will be fine.

Reference - SAP note 1679938

Also Read,

Hana Topics

Basis Topics,

Share this

Basis Genie