$ rman target sys/syspasswd@orcl auxiliary sys/syspasswd@stby Recovery Manager: Release 11.1.0.6.0 - Production on Sat Jan 10 10:19:50 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: ORCL (DBID=1203520702) connected to auxiliary database: ORCL (not mounted) RMAN> RMAN> run { duplicate target database for standby dorecover from active database; } 2> 3> 4> 5> Starting Duplicate Db at 10-JAN-09 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=154 device type=DISK contents of Memory Script: { backup as copy reuse file '/oracle/app/oracle/product/11.1.0/dbs/orapworcl' auxiliary format '/oracle/app/oracle/product/11.1.0/dbs/orapwstby' ; } executing Memory Script Starting backup at 10-JAN-09 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=124 device type=DISK Finished backup at 10-JAN-09 contents of Memory Script: { backup as copy current controlfile for standby auxiliary format '/oradata/stby/control01.ctl'; restore clone controlfile to '/oradata/stby/control02.ctl' from '/oradata/stby/control01.ctl'; restore clone controlfile to '/oradata/stby/control03.ctl' from '/oradata/stby/control01.ctl'; sql clone 'alter database mount standby database'; } executing Memory Script Starting backup at 10-JAN-09 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file output file name=/oracle/app/oracle/product/11.1.0/dbs/snapcf_orcl.f tag=TAG20090110T102045 RECID=6 STAMP=675771676 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:08 Finished backup at 10-JAN-09 Starting restore at 10-JAN-09 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: skipped, AUTOBACKUP already found channel ORA_DISK_1: skipped, AUTOBACKUP already found channel clone_default: copied control file copy Finished restore at 10-JAN-09 Starting restore at 10-JAN-09 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: skipped, AUTOBACKUP already found channel ORA_DISK_1: skipped, AUTOBACKUP already found channel clone_default: copied control file copy Finished restore at 10-JAN-09 sql statement: alter database mount standby database contents of Memory Script: { set newname for tempfile 1 to "/oradata/stby/temp01.dbf"; switch clone tempfile all; set newname for datafile 1 to "/oradata/stby/system01.dbf"; set newname for datafile 2 to "/oradata/stby/sysaux01.dbf"; set newname for datafile 3 to "/oradata/stby/undotbs01.dbf"; set newname for datafile 4 to "/oradata/stby/users01.dbf"; set newname for datafile 5 to "/oradata/stby/example01.dbf"; backup as copy reuse datafile 1 auxiliary format "/oradata/stby/system01.dbf" datafile 2 auxiliary format "/oradata/stby/sysaux01.dbf" datafile 3 auxiliary format "/oradata/stby/undotbs01.dbf" datafile 4 auxiliary format "/oradata/stby/users01.dbf" datafile 5 auxiliary format "/oradata/stby/example01.dbf" ; sql 'alter system archive log current'; } executing Memory Script executing command: SET NEWNAME renamed tempfile 1 to /oradata/stby/temp01.dbf in control file executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting backup at 10-JAN-09 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=/oradata/orcl/system01.dbf output file name=/oradata/stby/system01.dbf tag=TAG20090110T102156 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=/oradata/orcl/sysaux01.dbf output file name=/oradata/stby/sysaux01.dbf tag=TAG20090110T102156 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:46 channel ORA_DISK_1: starting datafile copy input datafile file number=00005 name=/oradata/orcl/example01.dbf output file name=/oradata/stby/example01.dbf tag=TAG20090110T102156 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=/oradata/orcl/undotbs01.dbf output file name=/oradata/stby/undotbs01.dbf tag=TAG20090110T102156 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=/oradata/orcl/users01.dbf output file name=/oradata/stby/users01.dbf tag=TAG20090110T102156 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 10-JAN-09 sql statement: alter system archive log current contents of Memory Script: { backup as copy reuse archivelog like "/oradata/arch/orcl/1_41_675739971.dbf" auxiliary format "/oradata/arch/stby/1_41_675739971.dbf" ; catalog clone archivelog "/oradata/arch/stby/1_41_675739971.dbf"; switch clone datafile all; } executing Memory Script Starting backup at 10-JAN-09 using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log copy input archived log thread=1 sequence=41 RECID=72 STAMP=675771966 output file name=/oradata/arch/stby/1_41_675739971.dbf RECID=0 STAMP=0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 Finished backup at 10-JAN-09 cataloged archived log archived log file name=/oradata/arch/stby/1_41_675739971.dbf RECID=1 STAMP=675771987 datafile 1 switched to datafile copy input datafile copy RECID=6 STAMP=675771988 file name=/oradata/stby/system01.dbf datafile 2 switched to datafile copy input datafile copy RECID=7 STAMP=675771988 file name=/oradata/stby/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=8 STAMP=675771988 file name=/oradata/stby/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=9 STAMP=675771988 file name=/oradata/stby/users01.dbf datafile 5 switched to datafile copy input datafile copy RECID=10 STAMP=675771988 file name=/oradata/stby/example01.dbf contents of Memory Script: { set until scn 628450; recover standby clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 10-JAN-09 using channel ORA_AUX_DISK_1 starting media recovery archived log for thread 1 with sequence 41 is already on disk as file /oradata/arch/stby/1_41_675739971.dbf archived log file name=/oradata/arch/stby/1_41_675739971.dbf thread=1 sequence=41 media recovery complete, elapsed time: 00:00:02 Finished recover at 10-JAN-09 Finished Duplicate Db at 10-JAN-09 RMAN>