RECLAIM SPACE IN SAP HANA DATABASE /HANA/LOG IS 100% FULL.(SAP HANA DATABASE)
RECLAIM SPACE IN /HANA/LOG IS 100%
FULL.
Hi team,
Initially we face an issue for filling /hana/log mount in
sap hana database.
But firstly let me know you guys that how to reclaim the
space in server when your /hana/log mount point is getting full.
Step1) Initially take full complete backup from hana studio
and while backup is complete take system backup also.
Step2) Open hana studio with system user database and also
with your tenant database and run
“ALTER SYSTEM RECLAIM LOG”.
Step3) while running the same, you find space is get
reclaimed on prod server.
In case when /hana/log is get 100% in this case, shutdown the database
immediately and then move small archive log of alteast 2 GB to run the
database.
1)
Move the archive logs to another location where
space is available and make linking to start the database part.
Use command ln -s to create
linking and use unlink command to unlink the linking.
2)
Once space is reclaimed by step1 and step2 ,
again shutdown the whole database part and then move the archive log to their
original location and then again start the Database.
NOTE—NEVER REMOVE ARCHIVE LOG IN HANA DATABASE BY USING
LINUX COMMAND.
Comments
Post a Comment