Determine and Display External Backup ID (DBMCLI) 

 

Use

When you restore with external backup tools, the Database Manager CLI identifies the backup to be restored using the external Backup IDs.

You can determine and display the information about the backups known to the backup tool, and in particular about the external backup IDs, using the following commands in an interactive DBMCLI session:

1. Querying the External Backup IDs
   DBMCLI Command: backup_ext_ids_get <medium> [<database_name> [<node>]]
   <medium>: Name of the backup medium
   <database_name>: Name of the database instance from which the backup is to be created
   <node>: Name of the server on which the backups were created
2. Reading External Backup IDs
   DBMCLI Command: backup_ext_ids_get
   The external backup IDs, the type of backup and the date and time of the backup are displayed for every backup still known to the backup tool.
   If a backup is still known to the backup tool but can no longer be used for a restore, the word UNAVAILABLE appears instead of AVAILABLE in the appropriate line.
   If the first response packet from the DBM Server does not contain all of the relevant information, the keyword CONTINUE appears in the response. If this is the case, continue with step 3.
   If the first response packet from the DBM Server does contain all of the relevant information, the keyword END appears in the response instead of CONTINUE. If this is the case, continue with step 4.
3. Scrolling in the External Backup IDs
   Display all further parts of the response until all of the information from the DBM server has been transferred or you have been able to determine the external backup IDs of the desired backups.
   DBMCLI Command: backup_ext_ids_listnext
   If the first response packet from the DBM Server contains all of the available information, the keyword END appears in the response. Continue with step 4.
4. Release of the Working Memory, that was used by the external backup IDs
   DBMCLI commando: backup_ext_ids_forget
   If you run this command, the Database Manager will no longer have any information about the external backup IDs. If you want to determine the external backup IDs after you have released the working memory, you must query the external backup IDs again and then read them.
   Or End the DBMCLI:
   DBMCLI command: exit

Database Manager CLI: SAP DB 7.3, Section Calling the Database Manager CLI ® DBM Server Command ® Backing Up and Restoring Databases ® Commands for External Backup IDs