Backing up an Oracle Data Guard environment
Appendix
Appendix A:
Data Protector session report of a Standby database backup
[Normal] From: BSM@oracle3 "OraSTBY_DG1_WholeOnline" Time: 17.05.2005 17:30:05
OB2BAR application on "oracle1" successfully started.
ob2rman.exe started with arguments:
-backup -full
Recovery Manager: Release 10.1.0.3.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
RMAN>
connected to target database: DG1 (DBID=1531960840)
RMAN>
connected to recovery catalog database
RMAN>
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DG1,OB2BARLIST=OraSTBY_DG1_WholeOnline,OB2BARHOSTNAME=oracle1)';
4> backup incremental level 0
5> filesperset 1
6> format 'OraSTBY_DG1_WholeOnline<DG1_%s:%t:%p>.dbf'
7> database
8> include current controlfile archivelog all;
9> }
allocated channel: dev_0
channel dev_0: sid=91 devtype=SBT_TAPE
channel dev_0: Data Protector A.05.50/330
Starting backup at 05/17/2005 [17:29:25]
channel dev_0: starting incremental level 0 datafile backupset
channel dev_0: specifying datafile(s) in backupset
input datafile fno=00001 name=/oradata/DG1/system01.dbf
channel dev_0: starting piece 1 at 05/17/2005 [14:29:30]
[Normal] From: BMA@oracle1 "file_device_Writer0" Time: 17.05.2005 17:29:36
STARTING Media Agent "file_device_Writer0"
[Normal] From: BMA@oracle1 "file_device_Writer0" Time: 17.05.2005 17:29:36
Loading medium from slot /oradata/DP/cb19880f5428a0e1c5020450074.fd to device file_device_Writer0
[Normal] From: BMA@oracle1 "file_device_Writer0" Time: 17.05.2005 17:29:36
/oradata/DP/cb19880f5428a0e1c5020450074.fd
Initializing new medium: "file_device_MediaPool_37"
[Normal] From: OB2BAR_Oracle8@oracle1 "DG1" Time: 17.05.2005 17:29:36
Starting OB2BAR Backup: oracle1:OraSTBY_DG1_WholeOnline<DG1_471:558541770:1>.dbf "Oracle8"
[Normal] From: OB2BAR_Oracle8@oracle1 "DG1" Time: 17.05.2005 17:30:02
Completed OB2BAR Backup: oracle1:OraSTBY_DG1_WholeOnline<DG1_471:558541770:1>.dbf "Oracle8"
channel dev_0: finished piece 1 at 05/17/2005 [14:30:05]
piece handle=OraSTBY_DG1_WholeOnline<DG1_471:558541770:1>.dbf comment=API Version 2.0,MMS Version 65.5.50.74
channel dev_0: backup set complete, elapsed time: 00:00:35
channel dev_0: starting incremental level 0 datafile backupset
channel dev_0: specifying datafile(s) in backupset
input datafile fno=00003 name=/oradata/DG1/sysaux01.dbf
channel dev_0: starting piece 1 at 05/17/2005 [14:30:06]
[Normal] From: OB2BAR_Oracle8@oracle1 "DG1" Time: 17.05.2005 17:30:06
Starting OB2BAR Backup: oracle1:OraSTBY_DG1_WholeOnline<DG1_472:558541806:1>.dbf "Oracle8"
[Normal] From: OB2BAR_Oracle8@oracle1 "DG1" Time: 17.05.2005 17:30:24
Completed OB2BAR Backup: oracle1:OraSTBY_DG1_WholeOnline<DG1_472:558541806:1>.dbf "Oracle8"
channel dev_0: finished piece 1 at 05/17/2005 [14:30:31]
piece handle=OraSTBY_DG1_WholeOnline<DG1_472:558541806:1>.dbf comment=API Version 2.0,MMS Version 65.5.50.74
channel dev_0: backup set complete, elapsed time: 00:00:25
channel dev_0: starting incremental level 0 datafile backupset
channel dev_0: specifying datafile(s) in backupset
input datafile fno=00005 name=/oradata/DG1/example01.dbf
channel dev_0: starting piece 1 at 05/17/2005 [14:30:31]
[Normal] From: OB2BAR_Oracle8@oracle1 "DG1" Time: 17.05.2005 17:30:31
Starting OB2BAR Backup: oracle1:OraSTBY_DG1_WholeOnline<DG1_473:558541831:1>.dbf "Oracle8"
[Normal] From: OB2BAR_Oracle8@oracle1 "DG1" Time: 17.05.2005 17:30:39
Completed OB2BAR Backup: oracle1:OraSTBY_DG1_WholeOnline<DG1_473:558541831:1>.dbf "Oracle8"
channel dev_0: finished piece 1 at 05/17/2005 [14:30:46]
piece handle=OraSTBY_DG1_WholeOnline<DG1_473:558541831:1>.dbf comment=API Version 2.0,MMS Version 65.5.50.74
channel dev_0: backup set complete, elapsed time: 00:00:15
channel dev_0: starting incremental level 0 datafile backupset
channel dev_0: specifying datafile(s) in backupset
input datafile fno=00002 name=/oradata/DG1/undotbs01.dbf
channel dev_0: starting piece 1 at 05/17/2005 [14:30:46]
[Normal] From: OB2BAR_Oracle8@oracle1 "DG1" Time: 17.05.2005 17:30:46
Starting OB2BAR Backup: oracle1:OraSTBY_DG1_WholeOnline<DG1_474:558541846:1>.dbf "Oracle8"
[Normal] From: OB2BAR_Oracle8@oracle1 "DG1" Time: 17.05.2005 17:30:56
Completed OB2BAR Backup: oracle1:OraSTBY_DG1_WholeOnline<DG1_474:558541846:1>.dbf "Oracle8"
28