配置oracle 9i physical standby database時，duplicate命令的執行記錄

RMAN> connect auxiliary sys/aaaaaa@STANDBY

connected to auxiliary database: orac (not mounted)

RMAN> duplicate target database for standby nofilenamecheck;

Starting Duplicate Db at 12-JUL-11
using target database controlfile instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=12 devtype=DISK

printing stored script: Memory Script
{
restore clone standby controlfile to clone_cf;
replicate clone controlfile from clone_cf;
sql clone 'alter database mount standby database';
}
executing script: Memory Script

Starting restore at 12-JUL-11

using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring controlfile
output filename=/u01/app/oradata/orac/control01.ctl
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup/0fmh8h60_1_1 tag=TAG20110712T121040 params=NULL
channel ORA_AUX_DISK_1: restore complete
Finished restore at 12-JUL-11

replicating controlfile
input filename=/u01/app/oradata/orac/control01.ctl
output filename=/u01/app/oradata/orac/control02.ctl
output filename=/u01/app/oradata/orac/control03.ctl

sql statement: alter database mount standby database

printing stored script: Memory Script
{
set until scn 500503;
set newname for datafile 1 to
"/u01/app/oradata/orac/system01.dbf";
set newname for datafile 2 to
"/u01/app/oradata/orac/undotbs01.dbf";
set newname for datafile 3 to
"/u01/app/oradata/orac/drsys01.dbf";
set newname for datafile 4 to
"/u01/app/oradata/orac/example01.dbf";
set newname for datafile 5 to
"/u01/app/oradata/orac/indx01.dbf";
set newname for datafile 6 to
"/u01/app/oradata/orac/odm01.dbf";
set newname for datafile 7 to
"/u01/app/oradata/orac/tools01.dbf";
set newname for datafile 8 to
"/u01/app/oradata/orac/users01.dbf";
set newname for datafile 9 to
"/u01/app/oradata/orac/xdb01.dbf";
restore
check readonly
clone database
;
}
executing script: Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 12-JUL-11

using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oradata/orac/system01.dbf
restoring datafile 00002 to /u01/app/oradata/orac/undotbs01.dbf
restoring datafile 00003 to /u01/app/oradata/orac/drsys01.dbf
restoring datafile 00004 to /u01/app/oradata/orac/example01.dbf
restoring datafile 00005 to /u01/app/oradata/orac/indx01.dbf
restoring datafile 00006 to /u01/app/oradata/orac/odm01.dbf
restoring datafile 00007 to /u01/app/oradata/orac/tools01.dbf
restoring datafile 00008 to /u01/app/oradata/orac/users01.dbf
restoring datafile 00009 to /u01/app/oradata/orac/xdb01.dbf
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup/0fmh8h60_1_1 tag=TAG20110712T121040 params=NULL
channel ORA_AUX_DISK_1: restore complete
Finished restore at 12-JUL-11

printing stored script: Memory Script
{
switch clone datafile all;
}
executing script: Memory Script

datafile 2 switched to datafile copy
input datafilecopy recid=10 stamp=756308592 filename=/u01/app/oradata/orac/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=11 stamp=756308592 filename=/u01/app/oradata/orac/drsys01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=12 stamp=756308593 filename=/u01/app/oradata/orac/example01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=13 stamp=756308593 filename=/u01/app/oradata/orac/indx01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=14 stamp=756308593 filename=/u01/app/oradata/orac/odm01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=15 stamp=756308593 filename=/u01/app/oradata/orac/tools01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=16 stamp=756308593 filename=/u01/app/oradata/orac/users01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=17 stamp=756308593 filename=/u01/app/oradata/orac/xdb01.dbf
Finished Duplicate Db at 12-JUL-11

RMAN> exit

[@more@]