Point in Time Recovery in Hana

Point in Time Recovery used in the HANA database for recovering database to the specific point in time. For this recovery, the data backup and log backup have to be available since last data backup and log area are required to perform the above type recovery

Case Study on Point in Time Recovery:

Find out the time for which DB Restore need to perform & check whether backup exist for given time or not.

For Example:  We will restore the full backup at 2015/02/16  08:57:38.847 and apply the logs till 2015/02/17 -05:54:02   ( the requested PIT is before  2015/02/17 05:54:02)

HANA system restore (on existing/new hardware of broken system) based on following parameters;

Hana DB Restore Template:

DATABASE SID                 :   SID
MACHINE NAME              :   vadbsid.lab.od.sap.biz
BACKUP LABEL NAME   :   SID-20140217-055402
RESTORE TYPE                 :   Special Data Backup
RESTORE TIMESTAMP     :   2015-02-17 05:54:02 AM
RESTORE PATH                  :  xyz/hdb/backup/data
LOGFILES NEEDED           :   no


Steps for Point in time recovery :

Step 1: Make sure we available files in xyz/hdb/backup/data and log files in xyz/hdb/backup/log.
Step 2: stop the DB.(i.e ./HDB stop)
Step 3: switch to root: sudo -i
Step 4: go to directory xyz/sapsid/HDB02/work.
Step 5: create directory recover_instance_bkp.sql and the insert this commands below.

RECOVERY command:

RECOVER DATABASE UNTIL TIMESTAMP ' 2014-02-06 06:00 ' CHANGE ALL DATA USING PATH ('xyz/hdb/backup/data')  CHANGE ALL LOG USING PATH ('xyz/hdb/backup/log')

Step 6: switch to admin and start the system ./HDB start.



Recovery Successfully Completed!!!!!!!!!!!!!!!!!!!!!!!! Enjoy...........