Zero Downtime Backup of MaxDB database with HP Data Protector
Appendix F
The following is a complete Data Protector session report in which Latest Point In Time Recovery was
selected. After restoring the appropriate archive log backup sessions, with the final archive log
session yet to be restored, the Recovery option was selected with latest point in time.
Data Protector restores the last archive log session and then instructs MaxDB to recover the instance to
the latest point in time:
[Normal] From: RSM@hpu069.deu.hp.com "" Time: 3/19/2009 2:28:11 PM
Restore session 2009/03/19-6 started.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:29:00 PM
Executing the dbmcli command: `user_logon'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:29:00 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/19/2009 2:29:01 PM
Executing the dbmcli command: `db_admin'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:29:10 PM
Executing the dbmcli command: `dbm_configset -raw set_variable_10
OB2BACKUPAPPNAME=MAXDB'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:29:10 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/19/2009 2:29:10 PM
Executing the dbmcli command: `util_connect'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:29:10 PM
Restoring backup 2009/03/19 0002.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:29:10 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/19/2009 2:29:10 PM
Executing the dbmcli command: `db_state'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:29:10 PM
Executing the dbmcli command: `recover_start BACKDP-Archive LOG ExternalBackupID
"MAXDB 0903192:1 Stream"'.
[Normal] From: RMA@tpc007.dp2.com "MAXDB_FL_Writer0" Time: 3/19/2009 2:31:02 PM
STARTING Media Agent "MAXDB_FL_Writer0"
[Normal] From: RMA@tpc007.dp2.com "MAXDB_FL_Writer0" Time: 3/19/2009 2:31:03 PM
Loading medium from slot D:\Backup\10394b45549c22fb0504cd5013e.fd to device
MAXDB_FL_Writer0
[Normal] From: OB2BAR_DMA@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:31:10 PM
Starting OB2BAR Restore: tpc003.dp2.com:/MAXDB/Data/1 "SAPDB"
[Normal] From: OB2BAR_DMA@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:31:13 PM
Completed OB2BAR Restore: tpc003.dp2.com:/MAXDB/Data/1 "SAPDB"
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:31:14 PM
Executing the dbmcli command: `db_state'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:31:14 PM
Executing the dbmcli command: `recover_start BACKDP-Archive LOG ExternalBackupID
"MAXDB 0903192:2 Stream"'.
[Normal] From: OB2BAR_DMA@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:31:56 PM
Starting OB2BAR Restore: tpc003.dp2.com:/MAXDB/Data/2 "SAPDB"
[Normal] From: OB2BAR_DMA@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:31:58 PM
Completed OB2BAR Restore: tpc003.dp2.com:/MAXDB/Data/2 "SAPDB"
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:31:59 PM
Executing the dbmcli command: `db_state'.
[Normal] From: OB2BAR_SAPDBBAR@tpc003.dp2.com "MAXDB" Time: 3/19/2009 2:31:59 PM
Executing the dbmcli command: `recover_start BACKDP-Archive LOG ExternalBackupID
"MAXDB 0903192:3 Stream"'.
51