SAP system is not responding - Log Volume is full & HANA DB.

 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 -

Ø  Stop HANA DB

       HDB Stop 

Ø  Go to /hana/log/SID/mnt0001

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

 Ø  Move one volume temporarily that having more than 2 GB to another location  where  enough space is available.

  

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

   Check the folder size using - du -ksh *

 Ø  Move a volume which consumes 2 GB of space 

       eg - hdb0002

      mv hdb0002 /usr/sap/SID/global/hdb/data

      or

      mv hdb0002 /hana/backup/SID (if you are using separate volume for log)

 Ø Create symbolic link to the new folder in the old location

    In -s hdb0002 /usr/sap/SID/global/hdb/data/hdb0002      /usr/sap/SID/global/hdb/log/mnt0001 /hdb0002 

 Ø  Start the HANA Database

        HDB start

 Ø   Wait until log backup are performed 

 Ø   Use the following SQL command to clean up the log volume 

    ALTER SYSTEM RECLAIM LOG;

 Ø   Stop the HANA database & Remove the symbolic link

    rm -f /usr/sap/SID/global/hdb/log/mnt0001 /hdb0002 

 Ø   Move  the log volume back to the original location

    mv hdb0002 /usr/sap/SID/global/hdb/log/mnt0001 

 Ø   Start the HANA Database again

    Now the Volume size will be fine.

Reference - SAP note 1679938