RecoverHANA

From Tranzman Documentation
Revision as of 12:04, 15 November 2018 by Admin (talk | contribs)
Jump to: navigation, search

Follow the steps on this page to recover HANA databases.

Note.png Note: The SAP HANA instance needs to be offline for the restore to work.

Step 1

Import the converted images to NetBackup.

Step 2

Log in to SAP HANA Studio and navigate to Backup and Recovery>Recover System.

Hana Restore 01.jpg

Step 3

Select the option to recover the database to a specific data backup or storage group.

Hana Restore 02.jpg

Step 4

Choose to recover the database without the backup catalog.

Hana Restore 03.jpg

Step 5

To extract the backup prefix run the NetBackup command "bplist" as shown below. This can be run from the NetBackup client install location or from the Master Server.

C:>bplist -C sap-hana2 -t 17 -R / usr:\sap\HDD\SYS\global\hdb\backint\log_backup_0_0_0_0 usr:\sap\HDD\SYS\global\hdb\backint\COMPLETE_DATA_BACKUP_databackup_1_1 usr:\sap\HDD\SYS\global\hdb\backint\COMPLETE_DATA_BACKUP_databackup_2_1 usr:\sap\HDD\SYS\global\hdb\backint\COMPLETE_DATA_BACKUP_databackup_3_1 usr:\sap\HDD\SYS\global\hdb\backint\COMPLETE_DATA_BACKUP_databackup_0_1

In this example our prefix is COMPLETE_DATA_BACKUP

Step X

Specify the destination type as "Backint" and add the backup prefix.

Hana Restore 04.jpg