Difference between revisions of "Recover SAPMaxDB"

From Tranzman Documentation
Jump to: navigation, search
(Created page with "To start the restore process, a database session needs to be created. '''Step 1''' Create a database session. ''dbmcli -u DBM,DBM -d DEMODB'' '''Step 2''' Create a backup...")
 
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
To start the restore process, a database session needs to be created.
 
To start the restore process, a database session needs to be created.
 +
__NOTOC__
 +
==='''Step 1'''===
 +
Login to the NetBackup GUI and navigate to '''Backup, Archive and Restore''' section.
  
'''Step 1'''
+
[[File:NBU-RestoreFiles.jpg]]
  
 +
==='''Step 2'''===
 +
Click on the '''Restore Files''' tab and select the Source, Destination Client and type of Policy to restore the MaxDB backup files.
 +
The '''Policy Type''' will be '''Standard'''.
 +
 +
[[File:MaxDB-RestoreSelection.jpg]]
 +
 +
==='''Step 3'''===
 +
Under '''Browse Directory''' select the MaxDB database backup files to restore.
 +
 +
[[File:MaxDB-BrowseDirectory.jpg]]
 +
 +
==='''Step 4'''===
 +
Choose to restore to a different location, and change the target destination to a temporary location on the SAP_MaxDB Server. '''''i.e. C:\MaxDB\Backup'''''
 +
 +
[[File:MaxDB-RestoreDirectory.jpg]]
 +
 +
==='''Step 5'''===
 
Create a database session.
 
Create a database session.
  
''dbmcli -u DBM,DBM -d DEMODB''
+
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
 
+
|
'''Step 2'''
+
dbmcli -u DBM,DBM -d DEMODB
 +
|}
  
 +
==='''Step 6'''===
 
Create a backup template.
 
Create a backup template.
  
 
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>'''''
  
 
Create a template d1 for data backup.
 
Create a template d1 for data backup.
  
''dbmcli on DB1> backup_template_create d1 to FILE C:\MaxDB\Backup\DAT0001 CONTENT DATA''
+
{| 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
 +
|}
  
 
Create a template l1 for log backup.
 
Create a template l1 for log backup.
  
''dbmcli on DB1> backup_template_create l1 to FILE C:\MaxDB\Backup\LOG CONTENT LOG''
+
{| 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'''''
 +
|}
  
 
Create a template md for a data backup using files in parallel.
 
Create a template md for a data backup using files in parallel.
  
''dbmcli on DB1> backup_template_create md to FILE C:\MaxDB\Backup\DAT0001 NAMED b1 FILE C:\MaxDB\Backup\DAT0002 NAMED b2 CONTENT DATA''
+
{| class="wikitable" style="padding-left: 20px; color:#FFFFFF; background-color: black; width: 800px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; "
 
+
|
'''Step 3'''
+
dbmcli on DB1> backup_template_create md to FILE C:\MaxDB\Backup\DAT0001 NAMED b1 FILE C:\MaxDB\Backup\DAT0002 NAMED b2 CONTENT DATA
 +
|}
  
 +
==='''Step 7'''===
 
Copy the recovered files to the location of the backup template.
 
Copy the recovered files to the location of the backup template.
  
 
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;
  
''dbmcli on DB1> db_admin ''
+
{| 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> service_connect''
+
dbmcli on DB1> db_admin
 
+
dbmcli on DB1> service_connect
''dbmcli on DB1> recover_check <backup_template> <backup_type>''
+
dbmcli on DB1> recover_check <backup_template> <backup_type>
 
+
|}
'''Step 4'''
 
  
 +
==='''Step 8'''===
 
If the outputs from these commands show a return code of 0, the information was checked successfully.  
 
If the outputs from these commands show a return code of 0, the information was checked successfully.  
  
 
To start the restore of this data, use the following commands;
 
To start the restore of this data, use the following commands;
  
''dbmcli on DB1> service_release''
+
{| 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_connect''
+
dbmcli on DB1> service_release  
 +
dbmcli on DB1> db_connect
 +
dbmcli on DB1> recover_start <backup_template> <backup_type>
 +
|}
  
''dbmcli on DB1> recover_start <backup_template> <backup_type>''
 
  
This completes the recovery process.
+
----
 +
Use this link to go back to the main [[recoverydocs]] Page.

Latest revision as of 13:43, 31 January 2019

To start the restore process, a database session needs to be created.

Step 1

Login to the NetBackup GUI and navigate to Backup, Archive and Restore section.

NBU-RestoreFiles.jpg

Step 2

Click on the Restore Files tab and select the Source, Destination Client and type of Policy to restore the MaxDB backup files. The Policy Type will be Standard.

MaxDB-RestoreSelection.jpg

Step 3

Under Browse Directory select the MaxDB database backup files to restore.

MaxDB-BrowseDirectory.jpg

Step 4

Choose to restore to a different location, and change the target destination to a temporary location on the SAP_MaxDB Server. i.e. C:\MaxDB\Backup

MaxDB-RestoreDirectory.jpg

Step 5

Create a database session.

dbmcli -u DBM,DBM -d DEMODB

Step 6

Create a backup template.

The format to follow will be;

backup_template_create <backup_template> to <backup_destination> <backup_content>

Create a template d1 for data backup.

dbmcli on DB1> backup_template_create d1 to FILE C:\MaxDB\Backup\DAT0001 CONTENT DATA

Create a template l1 for log backup.

dbmcli on DB1> backup_template_create l1 to FILE C:\MaxDB\Backup\LOG CONTENT LOG

Create a template md for a data backup using files in parallel.

dbmcli on DB1> backup_template_create md to FILE C:\MaxDB\Backup\DAT0001 NAMED b1 FILE C:\MaxDB\Backup\DAT0002 NAMED b2 CONTENT DATA

Step 7

Copy the recovered files to the location of the backup template.

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

dbmcli on DB1> db_admin dbmcli on DB1> service_connect dbmcli on DB1> recover_check <backup_template> <backup_type>

Step 8

If the outputs from these commands show a return code of 0, the information was checked successfully.

To start the restore of this data, use the following commands;

dbmcli on DB1> service_release dbmcli on DB1> db_connect dbmcli on DB1> recover_start <backup_template> <backup_type>



Use this link to go back to the main recoverydocs Page.