Difference between revisions of "RecoverHANA"
(→Step 1) |
(→Step 6) |
||
(4 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | Follow the steps on this page to recover HANA databases. | + | Follow the steps on this page to recover HANA databases without the backup catalog. |
{|style="padding: 5px; width: 85%;" | {|style="padding: 5px; width: 85%;" | ||
| style="width: 1%;"|[[File:Note.png|25px]]|| style="padding: 10px; width: 85%;"|'''Note:''' The SAP HANA instance needs to be offline for the restore to work. | | style="width: 1%;"|[[File:Note.png|25px]]|| style="padding: 10px; width: 85%;"|'''Note:''' The SAP HANA instance needs to be offline for the restore to work. | ||
Line 24: | Line 24: | ||
===Step 5=== | ===Step 5=== | ||
− | + | Extract the backup prefix using "bplist" on the HANA server or from the Master Server. | |
+ | Refer NBU documentation for more details on "bplist" | ||
{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; | {| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; | ||
Line 39: | Line 40: | ||
===Step 6=== | ===Step 6=== | ||
− | Specify the destination type as " | + | Specify the destination type as "backint" and add the backup prefix. |
[[File:Hana_Restore_04.jpg]] | [[File:Hana_Restore_04.jpg]] |
Latest revision as of 13:20, 15 November 2018
Follow the steps on this page to recover HANA databases without the backup catalog.
Note: The SAP HANA instance needs to be offline for the restore to work. |
Step 1
NBU Import the converted images to NetBackup.
Step 2
Log in to SAP HANA Studio and navigate to Backup and Recovery>Recover System.
Step 3
Select the option to recover the database to a specific data backup or storage group.
Step 4
Choose to recover the database without the backup catalog.
Step 5
Extract the backup prefix using "bplist" on the HANA server or from the Master Server. Refer NBU documentation for more details on "bplist"
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 6
Specify the destination type as "backint" and add the backup prefix.
Step 7
Proceed to the review recovery setting and click on Finish. The recovery of HANA should begin.
Use this link to go back to the main recoverydocs Page.