Getting Started - SAP for MaxDB Restore

performing a restore

It is recommended that you perform a restore operation immediately after your first full backup to understand the process.

You can perform a basic restore operation to restore and recover an entire database. The following section provides step-by-step instructions for running your first basic restore:

1. Open the DBM Command line Interface and verify the status of the database.
#> dbmcli -d CERT1 -u dbm,dbm -uUTL
dbmcli on CERT1>db_state
OK
State
ADMIN
2. MAXDB should be in admin (cold) state to perform a basic restore operation. If the database is in online (warm) mode, execute the command.

#> dbmcli -d CERT1 -u dbm,dbm db_cold

3. Type the command to check all backup IDs. The command should return OK.
# dbmcli -d CERT1 -u dbm,dbm -uUTL
dbmcli on CERT1>backup_ext_ids_get BackData2
OK
4. Type the command to list all the External Backup ID's. The command should return OK and display a list of all External Backup ID's.
dbmcli on CERT1>backup_ext_ids_list
OK
END
AVAILABLE|CERT1 SAP_0_46 
/space/sdb/data/cert1/files
/pipe_mem1|DATA MIGRATION|2005-11-05 16:11:49|
AVAILABLE|CERT1 SAP_0_46 
/space/sdb/data/cert1/files
/pipe_mem2|DATA MIGRATION|2005-11-05 16:11:49|
5. Type the command to execute the restore of entire database.
dbmcli on CERT1>
recover_start BackData2 
DATA ExternalBackupID "CERT1 SAP_0_46 
/space/sdb/data/cert1/files/pipe_mem1, 
CERT1 SAP_0_46 
/space/sdb/data/cert1/files/pipe_mem2"
  The restore should complete without any errors.
dbmcli on CERT1>exit
OK
6. You can monitor the progress of the restore job in the Job Controller or Event Viewer window of the CommCell Console.
7. Once the restore job has completed, right-click the entity (e.g. agent, instance) and click View | Restore History.

If the entity chosen is the client computer, click View | Job History.

 

8. Click OK.

Congratulations -  You have successfully completed your first backup and restore.

If you want to further explore this Agent's features read the Advanced sections of this documentation.