Difference between revisions of "Recover SAPMaxDB"
From Tranzman Documentation
(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...") |
|||
| Line 5: | Line 5: | ||
Create a database session. | Create a database session. | ||
| − | ''dbmcli -u DBM,DBM -d DEMODB'' | + | :'''''dbmcli -u DBM,DBM -d DEMODB''''' |
'''Step 2''' | '''Step 2''' | ||
| Line 13: | Line 13: | ||
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'' | + | :'''''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'' | + | :'''''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'' | + | :'''''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 3''' | '''Step 3''' | ||
| Line 33: | Line 33: | ||
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 '' | + | :'''''dbmcli on DB1> db_admin''''' |
| − | ''dbmcli on DB1> service_connect'' | + | :'''''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 4''' | ||
| Line 45: | Line 45: | ||
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'' | + | :'''''dbmcli on DB1> service_release''''' |
| − | ''dbmcli on DB1> db_connect'' | + | :'''''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. | This completes the recovery process. | ||
Revision as of 10:42, 30 August 2018
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 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 3
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 4
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>
This completes the recovery process.