Recovery as Normal Files(SAP HANA)

From Tranzman Documentation
Revision as of 13:45, 5 October 2020 by Sachin (talk | contribs)
Jump to: navigation, search

Headline

Tranzman UI provides a user friendly interface to browse the migrated images and restore data to the mounted NFS/CIFS share as per the Devices page. Click on Actions on sidebar and Select Restore. You should see the restore page with three sections.

  • Images section for selecting the images to restore data from.
  • Image Content section for browsing through the data in the selected images and select the contents you want to restore.
  • Selection section for reviewing selected content for restore and run the restore for the selected.


RestorePage.JPG


So follow the below steps to perform the restore of SAP HANA Backups.


Step 1

Select the Policy, Client, Backup Time From, Backup Time To and hit on FindImage.JPG and you should see all the images in the time interval selected.


Note.png Note: Our SAP HANA Server is saphana2.localdomain. We are restoring a full backup from 2020-09-29.


SAPHANAStep1.JPG


Step 2

Select the image you want to restore the data from Images section.Browse through the data in that Image in Image Content section and select it to restore.


SAPHANAStep2.JPG

Note.png Note: The way SAP HANA does backups by default is it splits its data files during backup and create different images/sessions. Similarly when you will select an image for restore, all the images which should be part of the group will be selected automatically.

Step 3

From the Selection section on the webpage , select the Destination for the restore. This refers to the NFS/CIFS share mounted for restoring data under Devices .Then enter the path (name of folder) where you want the data to be restored and click on Restore.JPG. This should trigger the restore and the Restore button should be greyed out.


SAPHANAStep3.JPG


Step 4

Once the Restore job is triggered successfully , you would see new jobs in Tasks under Views->Tasks on the sidebar. Additionaly there is another section under Views->Tasks named Restore logs (shown below) where user can check the restore status , and also re-run the restore with or without modifications for restore paths.


SAPHANAStep4.JPG


Step 5

When the restore is completed, copy the restored files from the share to the SAP HANA Server. Then login to the SAP HANA Studio.


Note.png Note: For this restore we have the below files restored by the Tranzman Appliance.Same has been copied to our SAP HANA

server under


SAPHANAStep5.JPG


sap-hana2:/tmp/restore_SAPHANA # pwd /tmp/restore_SAPHANA sap-hana2:/tmp/restore_SAPHANA # ls -ltr total 1869792 -rw-r--r-- 1 root root 155648 Oct 2 11:44 COMPLETE_DATA_BACKUP_databackup_0_1 -rw-r--r-- 1 root root 83894272 Oct 2 11:44 COMPLETE_DATA_BACKUP_databackup_2_1 -rw-r--r-- 1 root root 100671488 Oct 2 11:44 COMPLETE_DATA_BACKUP_databackup_1_1 -rw-r--r-- 1 root root 1728061440 Oct 2 11:45 COMPLETE_DATA_BACKUP_databackup_3_1


Step 6

Login to the SAP HANA Studio and connect to the SRL instance.

Note.png Note: SRL is the instance we are restoring the files to. It is quite evident from the restore Selected path too. Also if you prefer to restore the files using command line , you can always refer to the SAP Help Portal. However it is strongly recommended that you use SAP HANA studio.


SAPHANAStep6.JPG


Step 7

Right click on the instance name and Select Recover System under Backup and Recovery. Please be aware for SAP HANA restore System needs to be offline which is what you will see as warning as soon as you click on Recover System. Select OK and make the system offline.


SAPHANAStep7.JPG


SAPHANAStep8.JPG


Step 8

Once the system is offline, it should open a new window as shown in the below screenshot.


SAPHANAStep9.JPG


Select the option of "Recover the database to a specific data backup or storage snapshot". And then "Recover without the backup catalog".


SAPHANAStep10.JPG


Select the destination type as File and then enter the location where your restored files are on the SAP HANA server.

e.g. -> In our case it's under /tmp/restore_SAPHANA


SAPHANAStep11.JPG


Step 9

Click on Next a couple of times and then click Finish. Before clicking on Finish you can also have a look at the SQL Statement used by clicking on Show SQL Statement.

SAPHANAStep12.JPG


Once you click Finish you will get a warning of Manipulate data on the system. Click yes and proceed.

SAPHANAStep13.JPG


Your data should start getting restored.

SAPHANAStep14.JPG


Step 10

A successful restore should display the below message and also bring the whole system online.

SAPHANAStep15.JPG


Return to DP/DataProtector Recovery