MENU

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Complete Data Recovery in Hana




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:

satheesh kumar said...

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.