Recovery as Normal Files(FileSystem) - Revision history

Sachin at 10:16, 15 December 2020

2020-12-15T10:16:36Z

Sachin at 10:15, 15 December 2020

2020-12-15T10:15:34Z

Sachin at 10:10, 15 December 2020

2020-12-15T10:10:03Z

Sachin at 10:09, 15 December 2020

2020-12-15T10:09:52Z

Sachin at 10:06, 15 December 2020

2020-12-15T10:06:44Z

Sachin at 10:06, 15 December 2020

2020-12-15T10:06:31Z

Sachin at 10:02, 15 December 2020

2020-12-15T10:02:11Z

Sachin: Created page with "== 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 pa..."

2020-12-15T09:37:57Z

Created page with "== 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 pa..."

New page

== 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|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.
*Destination Usage section for monitoring NFS/CIFS share.

[[File:NewRestorePage.JPG | border|1100x800px]]

So follow the below steps to perform the restore of data as files.

===Step 1===

Select the Policy, Client, Backup Time From, Backup Time To and hit on [[File:FindImage.JPG | border|110x110px]] and you should see all the images in the time interval selected.

{|style="padding: 5px; width: 85%;"
| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''Note:''' In example shown below , redhat-client is FileSystem backup client. We are restoring a full backup from 2020-12-08.
|
|}

[[File:FileSystemSelections.JPG | border|1100x800px]]

===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.

[[File:RestoreDataSelection.JPG | border|1100x800px]]

===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
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:TriggerFileSystemDataRestore.JPG | border|1100x800px]]

===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.

[[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 ]]

@@ Line 15: / Line 15: @@
 {|style="padding: 5px; width: 85%;"
-| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''Note:''' Below methods should be followed to restore filesystem data and also to recover the DB/Application data as files. Once database/applications files are recovered then specific database/application steps should be followed.
+| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''Note:''' Below restore steps should be followed to restore filesystem data and also to recover the DB/Application data as files. Once database/applications files are recovered then specific database/application steps should be followed to restore that data to a database/application.
+|
 |}

← Older revision		Revision as of 10:15, 15 December 2020
Line 13:		Line 13:

	So follow the below steps to perform the restore of data as files.		So follow the below steps to perform the restore of data as files.
		+
		+	{\|style="padding: 5px; width: 85%;"
		+	\| style="width: 1%;"\|[[File:Note.png\|30px]]\|\| style="padding: 10px; width: 85%;"\|'''Note:''' Below methods should be followed to restore filesystem data and also to recover the DB/Application data as files. Once database/applications files are recovered then specific database/application steps should be followed.
		+	\|
		+	\|}

@@ Line 51: / Line 51: @@
 ===Step 4===
-Once the restore is successful, verify the restored data from the mounted NFS/CIFS share.
+Once the restore is successfull, verify the restored data from the mounted NFS/CIFS share.
 [[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]]

← Older revision		Revision as of 10:09, 15 December 2020
Line 50:		Line 50:

	===Step 4===		===Step 4===
		+
		+	Once the restore is successful, verify the restored data from the mounted NFS/CIFS share.
		+
		+
		+	[[ DP/DataProtector Recovery \| Return to DP/DataProtector Recovery ]]

← Older revision		Revision as of 10:06, 15 December 2020
Line 44:		Line 44:


		+	[[File:TriggerFileSystemDataRestore.JPG \| border\|1100x800px]]

−	~~[[File:TriggerFileSystemDataRestore.JPG \| border\|1100x800px]]~~	+
		+	===Step 4===

@@ Line 42: / Line 42: @@
 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 and the Restore button should be greyed out.
 [[File:TriggerFileSystemDataRestore.JPG | border|1100x800px]]
 ===Step 4===

← Older revision		Revision as of 10:02, 15 December 2020
Line 46:		Line 46:

	[[File:TriggerFileSystemDataRestore.JPG \| border\|1100x800px]]		[[File:TriggerFileSystemDataRestore.JPG \| border\|1100x800px]]
−
−
−
−	~~===Step 4===~~
−
−	~~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.
−
−
−
−	~~[[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 ]]~~