Backing up an Oracle Data Guard environment

Appendix B:
Target database restore using RMAN
RMAN> @recreate_standby.rcv
RMAN> run {
2> allocate auxiliary channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DG1,OB2BARLIST=Ora1_DG1_Online)';
4> allocate auxiliary channel 'dev_1' type 'sbt_tape'
5> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DG1,OB2BARLIST=Ora1_DG1_Online)';
6> duplicate target database for standby nofilenamecheck ;
7> }
starting full resync of recovery catalog
full resync complete
allocated channel: dev_0
channel dev_0: sid=105 devtype=SBT_TAPE
channel dev_0: Data Protector A.05.50/330
allocated channel: dev_1
channel dev_1: sid=104 devtype=SBT_TAPE
channel dev_1: Data Protector A.05.50/330
Starting Duplicate Db at 2005-05-04
contents of Memory Script:
{
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script
Starting restore at 2005-05-04
channel dev_0: starting datafile backupset restore
channel dev_0: restoring controlfile
[Normal] From: OB2BAR_Oracle8@oracle2 "DG1" Time: 05/04/05 07:49:35
Starting OB2BAR Restore: oracle1:Ora1_DG1_Online<DG1_413:557389582:1>.dbf "Oracle8"
[Normal] From: OB2BAR_Oracle8@oracle2 "DG1" Time: 05/04/05 07:49:36
Completed OB2BAR Restore: oracle1:Ora1_DG1_Online<DG1_413:557389582:1>.dbf "Oracle8"
channel dev_0: restored backup piece 1
piece handle=Ora1_DG1_Online<DG1_413:557389582:1>.dbf tag=TAG20050504T062622
channel dev_0: restore complete
output filename=/oradata/DG1/control01.ctl
output filename=/oradata/DG1/control02.ctl
output filename=/oradata/DG1/control03.ctl
Finished restore at 2005-05-04
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for datafile 1 to
"/oradata/DG1/system01.dbf";
set newname for datafile 2 to
"/oradata/DG1/undotbs01.dbf";
set newname for datafile 3 to
"/oradata/DG1/sysaux01.dbf";
set newname for datafile 4 to
"/oradata/DG1/users01.dbf";
set newname for datafile 5 to
"/oradata/DG1/example01.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 2005-05-04
channel dev_0: starting datafile backupset restore
channel dev_0: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /oradata/DG1/sysaux01.dbf
restoring datafile 00005 to /oradata/DG1/example01.dbf
channel dev_1: starting datafile backupset restore
channel dev_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata/DG1/system01.dbf
restoring datafile 00002 to /oradata/DG1/undotbs01.dbf
restoring datafile 00004 to /oradata/DG1/users01.dbf
[Normal] From: OB2BAR_Oracle8@oracle2 "DG1" Time: 05/04/05 07:50:31
Starting OB2BAR Restore: oracle1:Ora1_DG1_Online<DG1_406:557389454:1>.dbf "Oracle8"
31