Difference between revisions of "Recovery as Normal Files(SAP HANA)"

From Tranzman Documentation
Jump to: navigation, search
 
(32 intermediate revisions by the same user not shown)
Line 37: Line 37:
 
[[File:SAPHANAStep2.JPG | border|1100x800px]]
 
[[File:SAPHANAStep2.JPG | border|1100x800px]]
  
−
 
+
{|style="padding: 5px; width: 85%;"
 +
| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''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===
 
===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|Devices ]].Then enter the
 
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|Devices ]].Then enter the
−
path (name of folder) where you want the data to be restored and click on  [[File:Restore.JPG | border|110x110px]]. This should trigger the restore
+
path (name of folder) where you want the data to be restored and click on  [[File:Restore.JPG | border|110x110px]]. This should trigger the restore and the Restore button should be greyed out.
 +
 
 +
 
 +
 
 +
[[File:SAPHANAStep3.JPG | border|1100x800px]]
 +
 
  
  
 
===Step 4===
 
===Step 4===
  
−
Once the Restore job is triggered successfully , you can see a new job in Tasks under <b>Views->Tasks</b> on the sidebar.
+
Once the Restore job is triggered successfully , you would see new jobs in Tasks under <b>Views->Tasks</b> on the sidebar.
 
Additionaly there is another section  under <b>Views->Tasks</b> 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.
 
Additionaly there is another section  under <b>Views->Tasks</b> 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.
  
  
−
[[File:RestoreLogs.JPG | border|1100x800px]]
 
  
 +
[[File:SAPHANAStep4.JPG | border|1100x800px]]
 +
 +
 +
 +
===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.
 +
 +
 +
{|style="padding: 5px; width: 85%;"
 +
| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''Note:''' For this restore we have the below files restored by the Tranzman Appliance.Same has been copied to our SAP HANA
 +
server under
 +
|
 +
|}
 +
 +
 +
 +
[[File:SAPHANAStep5.JPG | border|1100x800px]]
 +
 +
 +
{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;
 +
|
 +
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.
 +
 +
{|style="padding: 5px; width: 85%;"
 +
| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''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.
 +
|
 +
|}
 +
 +
 +
 +
[[File:SAPHANAStep6.JPG | border|1100x800px]]
 +
 +
 +
===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.
 +
 +
 +
 +
[[File:SAPHANAStep7.JPG | border|1100x800px]]
 +
 +
 +
 +
[[File:SAPHANAStep8.JPG | border|1100x800px]]
 +
 +
 +
 +
===Step 8===
 +
 +
Once the system is offline, it should open a new window as shown in the below screenshot.
 +
 +
 +
[[File:SAPHANAStep9.JPG | border|1100x800px]]
 +
 +
 +
Select the option of "Recover the database to a specific data backup or storage snapshot". And then "Recover without the backup catalog".
 +
 +
 +
[[File:SAPHANAStep10.JPG | border|1100x800px]]
 +
 +
 +
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
 +
 +
 +
[[File:SAPHANAStep11.JPG | border|1100x800px]]
 +
 +
 +
 +
===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.
 +
 +
[[File:SAPHANAStep12.JPG | border|1100x800px]]
 +
 +
 +
Once you click Finish you will get a warning of Manipulate data on the system. Click yes and proceed.
 +
 +
[[File:SAPHANAStep13.JPG | border|1100x800px]]
 +
 +
 +
 +
Your data should start getting restored.
 +
 +
[[File:SAPHANAStep14.JPG | border|1100x800px]]
 +
 +
 +
 +
===Step 10===
 +
 +
A successful restore should display the below message and also bring the whole system online.
 +
 +
 +
[[File:SAPHANAStep15.JPG | border|1100x800px]]
  
  
  
 
[[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]]
 
[[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]]

Latest revision as of 13:45, 5 October 2020

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

Retrieved from "https://docs.stoneram.com/index.php?title=Recovery_as_Normal_Files(SAP_HANA)&oldid=2287"