Restore with External Backup Tools (DBMCLI) (SAP Library - External Backup Tools: SAP DB 7.2 and 7.3)

Restore with External Backup Tools (DBMCLI)

Use

When you restore with external backup tools, you must specify the external backup IDs of the required backups.

Prerequisites

The database instance must be in operational mode COLD. You must have configured the desired backup tool.

Backup Tool
ADSM/TSM	Configuration of the ADSM/TSM Connection
Backint for Oracle	Configuration of Backint for Oracle Connections
Backint for SAP DB	Configuration of Backint for SAP DB Connections
NetWorker	Configuration of the NetWorker Connection

You have determined the required external backup IDs (Determine and Display External Backup ID (DBMCLI) or Determine and Display External Backup ID (DBMGUI)).

You have inserted the required backup medium.

Procedure

You can perform restores with an interactive or a non-interactive DBMCLI session.

Restore Commands for an Interactive DBMCLI Session

You can restore a data backup (complete or incremental) and the first log backup with the corresponding DBMCLI command, as shown below:

recover_start <medium> <type> ExternalBackupID <external_backup_ID>

<medium>: Backup medium (Media name) from which the backup is to be imported (if necessary, specify a media group here)

<type>: Type of backup to be imported
data: Complete data backup
pages: Incremental data backup
log: Log backup

<external_backup_ID>: External backup ID with which the backup is known to the external backup tool.
If the external backup ID contains any blank characters, the external backup ID must be placed in double quotation marks:
"<external_backup_ID>"
In the case of parallel backups, you must enter all of the external backup IDs for the individual parts of the backup separated by commas in a list contained within double quotation marks:
"<external_backup_ID1>, <external_backup_ID2>, ..., <external_backup_IDn>"

If you want to import more than one log backup, you can import the second and all subsequent log backups interactively using the following DBMCLI command:

recover_replace <medium> ExternalBackupID <external_backup_ID>

If the external backup ID contains any blank characters, you must place the external backup ID in double quotation marks:
"<external_backup_ID>"

Note

You will need to import more than one log backup in most cases. You should therefore always perform log backups using interactive DBMCLI sessions so that you can react to the requirements of the database kernel (additional log backups required). To import all log backups, you use the recover_start command followed by the recover_replace command.

Example of a Restore Command for a Non-Interactive DBMCLI Session

Restore with NetWorker (non-interactive):

Example

dbmcli -u dbm,dbm -uUTL -d mydb recover_start NSRPages pages ExternalBackupID "NST 994245367 P47579"

The information relevant to the restore appear after the keyword recover_start:

Name of the backup medium: NSRPages
Type of backup to be imported: pages (incremental backup)
External Backup ID: NST 994245367 P47579

Caution

In the case of non-interactive DBMCLI sessions, follow the rules for the corresponding shell concerning the use of quotation marks. It is important that the quotation marks are sent to the DBM server.

For more information about restores, see the DBMCLI documentation:
Database Manager CLI: SAP DB 7.3, section Calling the Database Manager ® DBM Server Commands ® Backing Up and Recovering Database Instances ® Commands for Restoring

Result

The external backup ID of the desired backup is sent to the DBM server and the restore begins.