Recovery as Normal Files(SAP MaxDB) - Revision history

Sachin at 14:27, 30 November 2020

2020-11-30T14:27:47Z

2020-11-03T09:48:49Z

2020-11-03T09:43:29Z

2020-11-03T09:42:21Z

2020-11-03T09:39:39Z

2020-11-03T09:37:25Z

2020-11-03T09:27:21Z

2020-11-03T09:25:22Z

2020-11-03T09:24:37Z

2020-11-03T09:21:28Z

← Older revision		Revision as of 14:27, 30 November 2020
Line 1:		Line 1:
−	Below documentation shows how to restore SAP MaxDB data after it has been recovered as normal files using steps as shown in [[ Recovery as Normal Files \| Recovery as Normal Files ]]. Please recover the SAP MaxDB data and log file. Once you have the files, please follow the steps to restore.	+	Below documentation shows how to restore SAP MaxDB data after it has been recovered as normal files using steps as shown in [[ Recovery as Normal Files(FileSystem) \| Recovery as Normal Files ]]. Please recover the SAP MaxDB data and log file. Once you have the files, please follow the steps to restore.

	We are demonstrating recovery of data file (shown in below picture) in examples but same procedure could be followed for log backup recovery.		We are demonstrating recovery of data file (shown in below picture) in examples but same procedure could be followed for log backup recovery.

@@ Line 159: / Line 159: @@
 ---
 |}
 [[ DP/DataProtector Recovery | Return to DP/DataProtector Recovery ]]

@@ Line 118: / Line 118: @@
 |}
-e.g.
+e.g. We ran our restore and it's return code is also 0 , so our restore is successful.
 {| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
+|
@@ Line 159: / Line 159: @@
 ---
 |}

@@ Line 103: / Line 103: @@
 ---
 dbmcli.exe on MAXDB>
 |}

← Older revision		Revision as of 09:39, 3 November 2020
Line 61:		Line 61:


−	e.g. In our case we have copied the mediumRestore data file to the DATA CONTENT location and renamed it to DAT0001	+	e.g. In our case we have copied the mediumRestore data file to the DATA CONTENT location and renamed it to DAT0001.
		+
		+	{\| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
		+	\|
		+	dbmcli.exe on MAXDB>db_admin
		+	OK
		+
		+	---
		+	dbmcli.exe on MAXDB>service_connect
		+	OK
		+
		+	---
		+	dbmcli.exe on MAXDB>recover_check d1 DATA
		+	OK
		+	Returncode 0
		+	Date 20201103
		+	Time 00093853
		+	Server NBU-SAPMaxDB
		+	Database MAXDB
		+	Kernel Version Kernel 7.9.09 Build 005-123-259-005
		+	Pages Transferred 616
		+	Pages Left 0
		+	Volumes 1
		+	Medianame d1
		+	Location C:\MaxDB\Backup\DAT0001
		+	Errortext
		+	Label DAT_000000013
		+	Is Consistent true
		+	First LOG Page 29792
		+	Last LOG Page
		+	DB Stamp 1 Date 20190121
		+	DB Stamp 1 Time 00112051
		+	DB Stamp 2 Date
		+	DB Stamp 2 Time
		+	Page Count 598
		+	Devices Used 1
		+	Database ID NBU-SAPMaxDB:MAXDB_20190121_112051
		+	Max Used Data Page 0
		+	Converter Page Count 10
		+
		+	---
		+	dbmcli.exe on MAXDB>
		+	\|}

@@ Line 52: / Line 52: @@
 Check if the backup can be accessed and that data reading will work. A service session is requires as follows;
 {| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
@@ Line 60: / Line 57: @@
 dbmcli on DB1> db_admin
 dbmcli on DB1> service_connect
-dbmcli on DB1> recover_check <backup_template> <backup_type>
+dbmcli on DB1> recover_check d1 DATA
 |}

← Older revision		Revision as of 09:27, 3 November 2020
Line 50:		Line 50:

	Copy the recovered files to the location of the templates.		Copy the recovered files to the location of the templates.
		+
		+	Check if the backup can be accessed and that data reading will work. A service session is requires as follows;

	e.g. In our case we have copied the mediumRestore data file to the DATA CONTENT location and renamed it to DAT0001		e.g. In our case we have copied the mediumRestore data file to the DATA CONTENT location and renamed it to DAT0001
−
−	~~Check if the backup can be accessed and that data reading will work. A service session is requires as follows;~~

← Older revision		Revision as of 09:25, 3 November 2020
Line 54:		Line 54:

	Check if the backup can be accessed and that data reading will work. A service session is requires as follows;		Check if the backup can be accessed and that data reading will work. A service session is requires as follows;
		+

	{\| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "		{\| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "

@@ Line 47: / Line 47: @@
-==='''Step 7'''===
+==='''Step 4'''===
 Copy the recovered files to the location of the templates.
 Check if the backup can be accessed and that data reading will work. A service session is requires as follows;

← Older revision		Revision as of 09:21, 3 November 2020
Line 29:		Line 29:
	The format to follow will be;		The format to follow will be;
	:'''''backup_template_create <backup_template> to <backup_destination> <backup_content>'''''		:'''''backup_template_create <backup_template> to <backup_destination> <backup_content>'''''
		+
		+
		+	{\| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
		+	\|
		+	dbmcli on DB1> backup_template_create d1 to FILE C:\MaxDB\Backup\DAT0001 CONTENT DATA
		+	\|}
		+
		+
		+	===Step 3===
		+
		+	If you are also restoring logs then create a template for the log too.
		+
		+	{\| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
		+	\|
		+	dbmcli on DB1> backup_template_create l1 to FILE C:\MaxDB\Backup\LOG CONTENT LOG'''''
		+	\|}
		+
		+
		+	==='''Step 7'''===
		+
		+	Copy the recovered files to the location of the templates.
		+
		+	Check if the backup can be accessed and that data reading will work. A service session is requires as follows;
		+
		+	{\| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
		+	\|
		+	dbmcli on DB1> db_admin
		+	dbmcli on DB1> service_connect
		+	dbmcli on DB1> recover_check <backup_template> <backup_type>
		+	\|}