/hana/log is 100% full in Sap Hana

If you encounter the issue where the /hana/log directory is 100% full and your system is unable to start, you may have more flexibility if this happens on a non-production system. However, if this occurs in a production environment, it’s crucial to resolve it immediately, as it carries risks.

Step-by-Step Process

1. Check the current log directory size Navigate to /hana/log/SID/mnt00001 and capture a screenshot of the directory sizes. You can use either du -sk or du -sh (I recommend du -sk).
2. Identify an alternative location for file movement Find a suitable location to temporarily move files from /hana/log/SID/mnt00001. For example, /hana/data/logs_temporary can be used for this purpose to free up space on /hana/log.
3. Stop the HANA database If the database isn’t already stopped, use the following command to stop it:
4. Move files to the temporary location Move files from /hana/log/SID/mnt00001 to /hana/data/logs_temporary. Make sure you transfer files of at least 2 GB in total. Ensure that this operation is performed without interruption and that no files are damaged during the move.
5. Verify file size match After moving the files, compare the sizes in /hana/data/logs_temporary with the sizes you recorded in Step 1. They should match exactly.
6. Create a symbolic link Create a symbolic soft link for the moved directory with the following command:
7. Start the database Restart the database with the command:
8. Ensure log backups are running properly After the database restarts, confirm that log backups are being executed successfully.
9. Reclaim log segments Use SQL console or HDBSQL to run the following command to free up log segments from /hana/log:
10. Revert the changes once log utilization is normal Once backups are complete and the utilization of /hana/log returns to normal, revert the changes made earlier. Follow these steps:
11. Start the database again Restart the database (refer to Step 7 for the command).

By following these steps, you can temporarily resolve the issue of a full /hana/log directory, ensuring minimal disruption and risk.

Please connect and follow me for the next upcoming informative articles.

Cheers :)