HANA Log Status Check Point in Time Recovery Possible or Not

Production database has to be in RECOVERY mode all the time.If a SAP HANA database log mode in set to OVERWRITE, backup can still be done but recovery will only be done at the date of the backup.

In this case there is no chance to recover any changes made on the database after the backup.

Below SQL script will show the database log mode easily ;

select log_mode,
case
when log_mode = ‘overwrite’
then ‘Not possible’
else ‘Possible’
end
as “point in time recovery”
from ( SELECT DISTINCT log_mode FROM SYS.M_LOG_BUFFERS)

Output should be like below for all production SAP systems ;

HANA Log Status Check Point int Time Recovery Possible or Not

 

Leave a Reply


six − 2 =

Blogroll