Zero Downtime Backup of MaxDB database with HP Data Protector
Appendix G
The following is a complete Data Protector session report in which a particular Point In Time
Recovery was selected. After restoring appropriate archive log backup sessions, with the final
archive log session yet to be restored, the Recovery option was selected with a specific point in time
in the past. Data Protector restores the last archive log session and subsequently instructs MaxDB to
recover the instance to a specific point in time:
[Normal] From: RSM@hpu069.deu.hp.com "" Time: 3/20/2009 2:41:45 PM
Restore session 2009/03/20-6 started.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:34 PM
Executing the dbmcli command: `user_logon'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:34 PM
Executing the dbmcli command: `dbm_configset -raw BSI_ENV
C:\PROGRA~1\OmniBack\tmp\\MAXDB.bsi_env'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:35 PM
Executing the dbmcli command: `db_admin'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:35 PM
Executing the dbmcli command: `dbm_configset -raw set_variable_10
OB2BACKUPAPPNAME=MAXDB'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:35 PM
Executing the dbmcli command: `dbm_configset -raw set_variable_11
OB2BACKUPHOSTNAME=tpc003.dp2.com'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:35 PM
Executing the dbmcli command: `util_connect'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:35 PM
Restoring backup 2009/03/20 0003.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:35 PM
Executing the dbmcli command: `medium_put BACKDP-Archive/1 \\.\Pipe\MAXDB.BACKDP-
Archive.1 PIPE LOG 0 8 NO NO \"\" BACK'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:36 PM
Executing the dbmcli command: `db_state'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:42:36 PM
Executing the dbmcli command: `recover_start BACKDP-Archive LOG ExternalBackupID
"MAXDB 0903203:1 Stream"'.
[Normal] From: RMA@tpc007.dp2.com "MAXDB_FL_Writer0" Time: 3/20/2009 2:43:10 PM
STARTING Media Agent "MAXDB_FL_Writer0"
[Normal] From: RMA@tpc007.dp2.com "MAXDB_FL_Writer0" Time: 3/20/2009 2:43:11 PM
Loading medium from slot D:\Backup\10394b45549c3994d504cd5015c.fd to device
MAXDB_FL_Writer0
[Normal] From: OB2BAR_DMA@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:43:19 PM
Starting OB2BAR Restore: tpc003.dp2.com:/MAXDB/Data/1 "SAPDB"
[Normal] From: OB2BAR_DMA@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:43:21 PM
Completed OB2BAR Restore: tpc003.dp2.com:/MAXDB/Data/1 "SAPDB"
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:43:24 PM
Executing the dbmcli command: `db_warm -f -u 20090320 142205'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/20/2009 2:43:24 PM
Executing the dbmcli command: `exit'.
[Normal] From: RSM@hpu069.deu.hp.com "" Time: 3/20/2009 2:42:36 PM
OB2BAR application on "tpc003.dp2.com" disconnected.
[Normal] From: RMA@tpc007.dp2.com "MAXDB_FL_Writer0" Time: 3/20/2009 2:43:52 PM
Unloading medium to slot D:\Backup\10394b45549c3994d504cd5015c.fd from device
MAXDB_FL_Writer0
[Normal] From: RMA@tpc007.dp2.com "MAXDB_FL_Writer0" Time: 3/20/2009 2:43:52 PM
COMPLETED Media Agent "MAXDB_FL_Writer0"
============================================================================
Session completed successfully!
============================================================================
53