Complete Data Recovery Used for recovering the HANA database to a specified data backup. Specific data backup is required for the above type of recovery option.
Case Study on Complete Data 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-17 05:54:02 AM.
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/SID/backup/data
LOGFILES NEEDED : no
Steps for Complete recovery :
Step 1: Make sure we available files in xyz/hdb/SID/backup/data and log files in xyz/hdb/SID/backup/log.
Step 2: stop the DB.(i.e ./HDB stop)
Step 3: switch to root: sudo -i
Step 4: go to directory /sapsid/SID/HDB02/work.
Step 5: create directory recoverInstance_bkp.sql, vi recoverInstance_bkp.sql, and the insert this commandas below
RECOVERY command:
RECOVER DATA USING FILE ('xyz/hdb/SID/backup/data/SID-20150217-055402') CLEAR LOG
Step 6: switch to admin and start the system ./HDB start
Recovery Successfully Completed!!!!!!!!!!!!!!!!!!!!!!!! Enjoy...
1 comment:
I followed the steps mentioned HDB got started. But When i try to add my SID in Hana studio I am getting invalid user or password.
Post a Comment