Use the duplicate target database ... from active databases to replicate

Rman> duplicate target database to dupdb from active database2> spfile 3> parameter_value_convert= '/u11/app/ Oracle/oradata/ora11 ', '/u11/app/oracle/oradata/dupdb ' 4> set 5> log_file_name_convert= '/u11/app/ora Cle/oradata/ora11 ', '/u11/app/oracle/oradata/dupdb ' 6> db_file_name_convert= '/u11/app/oracle/oradata/ora11 ', '/u11/app/oracle/oradata/dupdb '; Starting Duplicate Db at 26-jun-2015 14:16:31using target database control file instead of recovery catalogallocated Chann El:ora_aux_disk_1channel ora_aux_disk_1:sid=19 device type=diskcontents of Memory script:{Backup as copy Reuse Targ Etfile '/u11/app/oracle/product/11.2.0/dbhome_1/dbs/spfileora11.ora ' auxiliary format '/u11/app/oracle/product/   11.2.0/dbhome_1/dbs/spfiledupdb.ora '; SQL Clone "alter system set spfile= '/u11/app/oracle/product/11.2.0/dbhome_1/dbs/spfiledupdb.ora";} Executing Memory scriptstarting backup at 26-jun-2015 14:16:32allocated Channel:ora_disk_1channel Ora_disk_1:sid=37 device type=diskfinished Backup at 26-jun-2015 14:16:33sql statement:alter system set spfile= '/u11/ap   P/oracle/product/11.2.0/dbhome_1/dbs/spfiledupdb.ora ' contents of Memory script:{SQL clone "alter system set Db_name =   ' dupdb ' comment= ' duplicate ' scope=spfile '; SQL Clone "alter system set Control_files = '/u11/app/oracle/oradata/dupdb/control01.ctl", "/u11/app/oracle/oradata   /dupdb/control02.ctl ' comment= ' scope=spfile '; SQL Clone "alter system set Log_file_name_convert = '/u11/app/oracle/oradata/ora11", "/u11/app/oracle/oradata/dupdb   ' comment= ' ' scope=spfile ';   Shutdown clone Immediate; Startup clone Nomount;} Executing Memory scriptsql statement:alter system Set db_name = "dupdb" comment= "duplicate" Scope=spfilesql Statem Ent:alter system Set Control_files = '/u11/app/oracle/oradata/dupdb/control01.ctl ', '/u11/app/oracle/oradata/ Dupdb/control02.ctl "comment=" "Scope=spfilesql statement:alter system set Log_filE_name_convert = '/u11/app/oracle/oradata/ora11 ', '/u11/app/oracle/oradata/dupdb ' comment= ' ' scope= Spfileoracle instance shut downconnected to auxiliary database (not started) Oracle instance startedtotal System Global is A 630501376 bytesfixed size 2215984 bytesvariable size 184553424 bytesdatabase Buff ERs 440401920 Bytesredo buffers 3330048 bytescontents of Memory script:{SQL clone "alter   System set db_name = ' ORA11 ' comment= ' Modified by RMAN duplicate ' scope=spfile ';   SQL Clone "alter system set Db_unique_name = ' dupdb ' comment=" Modified by RMAN duplicate ' scope=spfile ';   Shutdown clone Immediate; Startup clone Force Nomount Backup as copy current controlfile auxiliary format '/u11/app/oracle/oradata/dupdb/control0   1.ctl '; Restore clone controlfile to '/u11/app/oracle/oradata/dupdb/control02.ctl ' from '/u11/app/oracle/oradata/dupdb/   Control01.ctl '; Alter clone database Mount;} ExecUting Memory scriptsql statement:alter system Set db_name = ' ORA11 ' comment= ' Modified by RMAN duplicate ' SCOPE=SPF  Ilesql statement:alter System Set Db_unique_name = ' dupdb ' comment= ' Modified by RMAN duplicate ' scope=spfileoracle Instance shut downoracle instance startedtotal System Global area 630501376 bytesfixed Size 22159                   Bytesvariable Size 184553424 bytesdatabase buffers 440401920 Bytesredo buffers 3330048 bytesstarting backup at 26-jun-2015 14:16:45using Channel Ora_disk_1channel ora_disk_1:starting datafile Cop Ycopying Current control fileoutput file Name=/u11/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_ora11.f tag= tag20150626t141645 recid=21 stamp=883405007channel ora_disk_1:datafile copy complete, elapsed time:00:00:03finished Backup at 26-jun-2015 14:16:49starting restore at 26-jun-2015 14:16:49allocated Channel:ora_aux_disk_1channel ORA_AUX_ disk_1:sid=19 Device Type=diskchannel Ora_aUx_disk_1:copied control file copyfinished restore at 26-jun-2015 14:16:50database mountedcontents of Memory script:{s   ET newname for datafile 1 to "/u11/app/oracle/oradata/dupdb/system01.dbf";   Set newname for datafile 2 to "/u11/app/oracle/oradata/dupdb/sysaux01.dbf";   Set newname for DataFile 3 to "/u11/app/oracle/oradata/dupdb/yb01.dbf";   Set newname for datafile 4 to "/u11/app/oracle/oradata/dupdb/users01.dbf";   Set newname for datafile 5 to "/u11/app/oracle/oradata/dupdb/example01.dbf";   Set newname for datafile 6 to "/u11/app/oracle/oradata/dupdb/undotbs02.dbf"; Backup as Copy reuse datafile 1 auxiliary format "/U11/APP/ORACLE/ORADATA/DUPDB/SYSTEM01.DBF" DataFile 2 Auxiliary Format "/U11/APP/ORACLE/ORADATA/DUPDB/SYSAUX01.DBF" datafile 3 auxiliary format "/U11/APP/ORACLE/ORADATA/DUPDB/YB01. DBF "datafile 4 auxiliary format"/U11/APP/ORACLE/ORADATA/DUPDB/USERS01.DBF "datafile 5 auxiliary format"/u11/app /ORACLE/ORADATA/DUPDB/EXAMPLE01.DBF "  DataFile 6 Auxiliary format "/U11/APP/ORACLE/ORADATA/DUPDB/UNDOTBS02.DBF"; SQL ' alter system archive log current ';} Executing Memory scriptexecuting command:set newnameexecuting command:set newnameexecuting command:set NEWNAMEexecutin G Command:set newnameexecuting command:set newnameexecuting command:set newnamestarting backup at 26-JUN-2015 14:16:55u Sing channel Ora_disk_1channel ora_disk_1:starting datafile copyinput datafile file number=00001 name=/u11/app/oracle/ Oradata/ora11/system01.dbfoutput file name=/u11/app/oracle/oradata/dupdb/system01.dbf tag= Tag20150626t141655channel ora_disk_1:datafile copy complete, elapsed Time:00:00:35channel ora_disk_1:starting DataFile copyinput datafile file number=00002 name=/u11/app/oracle/oradata/ora11/sysaux01.dbfoutput file name=/u11/ APP/ORACLE/ORADATA/DUPDB/SYSAUX01.DBF tag=tag20150626t141655channel ora_disk_1:datafile Copy complete, elapsed time: 00:00:35channel ora_disk_1:starting datafile copyinput datafile file number=00005 name=/u11/app/oracle/oradata/ora11/example01.dbfoutput File name=/u11/app/oracle/oradata/dupdb/example01.dbf Tag=tag20150626t141655channel ora_disk_1:datafile copy complete, elapsed Time:00:00:07channel ora_disk_1:starting DataFile copyinput datafile file number=00006 name=/u11/app/oracle/oradata/ora11/undotbs02.dbfoutput file name=/u11/ APP/ORACLE/ORADATA/DUPDB/UNDOTBS02.DBF tag=tag20150626t141655channel ora_disk_1:datafile Copy complete, elapsed time : 00:00:07channel ora_disk_1:starting datafile copyinput datafile file number=00003 name=/u11/app/oracle/oradata/ora11 /yb01.dbfoutput file name=/u11/app/oracle/oradata/dupdb/yb01.dbf tag=tag20150626t141655channel ora_disk_1:datafile Copy complete, elapsed Time:00:00:03channel ora_disk_1:starting datafile copyinput datafile file number=00004 name=/u11/ App/oracle/oradata/ora11/users01.dbfoutput file name=/u11/app/oracle/oradata/dupdb/users01.dbf tag= Tag20150626t141655channel ora_disk_1:datafile copy complete, elapsed time:00:00:01finished backup at 26-jun-2015 14:18:24sql statement:alter System archive Log currentcontents of Memory script:{Ba Ckup as copy reuse archivelog like "/u11/app/oracle/fra/ora11/archivelog/2015_06_26/o1_mf_1_98_brsvojfz_.arc"   Auxiliary format "/U11/APP/ORACLE/FRA/DUPDB/ARCHIVELOG/2015_06_26/O1_MF_1_98_%U_.ARC";   Catalog Clone recovery area; Switch clone datafile all;} Executing Memory scriptstarting backup at 26-jun-2015 14:18:25using channel Ora_disk_1channel ora_disk_1:starting Archiv Ed log copyinput archived log thread=1 sequence=98 recid=91 stamp=883405104output file name=/u11/app/oracle/fra/dupdb/ Archivelog/2015_06_26/o1_mf_1_98_4mqafc9h_.arc recid=0 stamp=0channel ora_disk_1:archived Log copy complete, elapsed time:00:00:01finished Backup at 26-jun-2015 14:18:26searching for all files in the recovery arealist of files Unknown to The Database=====================================file Name:/U11/APP/ORACLE/FRA/DUPDB/ARCHIVELOG/2015_06_26/O1_MF _1_98_4mqafc9h_.arccatAloging files...cataloging donelist of cataloged files=======================file Name:/u11/app/oracle/fra/dupdb/ Archivelog/2015_06_26/o1_mf_1_98_4mqafc9h_.arcdatafile 1 switched to datafile copyinput datafile copy RECID=21 STAMP= 883405107 file Name=/u11/app/oracle/oradata/dupdb/system01.dbfdatafile 2 switched to datafile copyinput datafile copy recid=22 stamp=883405107 file Name=/u11/app/oracle/oradata/dupdb/sysaux01.dbfdatafile 3 switched to datafile Copyinput DataFile copy recid=23 stamp=883405107 file Name=/u11/app/oracle/oradata/dupdb/yb01.dbfdatafile 4 switched to DataFile Copyinput datafile Copy recid=24 stamp=883405107 file Name=/u11/app/oracle/oradata/dupdb/users01.dbfdatafile 5 Switched to datafile copyinput datafile copy recid=25 stamp=883405107 file name=/u11/app/oracle/oradata/dupdb/ Example01.dbfdatafile 6 switched to datafile copyinput datafile copy recid=26 stamp=883405107 file name=/u11/app/oracle/o  Radata/dupdb/undotbs02.dbfcontents of Memory script:{set until SCN1432824; Recover clone database Delete Archivelog;} Executing Memory scriptexecuting command:set until clausestarting recover at 26-jun-2015 14:18:27using channel Ora_aux_di Sk_1starting Media recoveryarchived Log for thread 1 with sequence 98 are already on disk as file/u11/app/oracle/fra/dupdb /archivelog/2015_06_26/o1_mf_1_98_4mqafc9h_.arcarchived log File name=/u11/app/oracle/fra/dupdb/archivelog/2015_ 06_26/o1_mf_1_98_4mqafc9h_.arc thread=1 sequence=98media Recovery complete, elapsed time:00:00:00finished recover at 26   -jun-2015 14:18:28contents of Memory script:{shutdown clone immediate;   Startup clone Nomount;   SQL Clone "alter system set db_name = ' dupdb '" comment= "Reset to original value by RMAN ' Scope=spfile";   SQL Clone "alter system reset Db_unique_name Scope=spfile";   Shutdown clone Immediate; Startup clone Nomount;} Executing Memory scriptdatabase dismountedoracle instance shut downconnected to auxiliary database (not started) Oracle ins Tance StartedtOtal System Global Area 630501376 bytesfixed size 2215984 bytesvariable size 184553 424 Bytesdatabase buffers 440401920 Bytesredo buffers 3330048 bytessql statement:alter Syst EM set db_name = ' dupdb ' comment= ' reset to original value by RMAN ' Scope=spfilesql statement:alter system Reset D B_unique_name scope=spfileoracle Instance shut downconnected to auxiliary database (not started) Oracle instance Startedto Tal System Global area 630501376 bytesfixed size 2215984 bytesvariable size 1845534 Bytesdatabase buffers 440401920 Bytesredo buffers 3330048 bytessql statement:create CONT  Rolfile reuse SET DATABASE "dupdb" Resetlogs ARCHIVELOG maxlogfiles 3 maxlogmembers 100 Maxinstances 8 maxloghistory 292 LOGFILE GROUP 1 ('/u11/app/oracle/oradata/dupdb/redo01.log ', '/u11/app/orac le/oradata/dupdb/redo01b.Log ') SIZE M Reuse, GROUP 2 ('/u11/app/oracle/oradata/dupdb/redo02b.log ', '/u11/app/oracle/oradata/dupdb/redo02.lo  G ') SIZE M Reuse, GROUP 3 ('/u11/app/oracle/oradata/dupdb/redo03b.log ', '/u11/app/oracle/oradata/dupdb/redo03.log ' ) SIZE M Reuse datafile '/u11/app/oracle/oradata/dupdb/system01.dbf ' CHARACTER SET al32utf8contents of Memory Script   : {Set newname for Tempfile 1 to "/u11/app/oracle/oradata/dupdb/temp01.dbf";   Switch clone tempfile all;  Catalog Clone datafilecopy "/U11/APP/ORACLE/ORADATA/DUPDB/SYSAUX01.DBF", "/u11/app/oracle/oradata/dupdb/yb01.dbf", "/u11/app/oracle/oradata/dupdb/users01.dbf", "/u11/app/oracle/oradata/dupdb/example01.dbf", "/u11/app/oracle/   ORADATA/DUPDB/UNDOTBS02.DBF "; Switch clone datafile all;} Executing Memory scriptexecuting command:set newnamerenamed tempfile 1 to/u11/app/oracle/oradata/dupdb/temp01.dbf in Co Ntrol filecataloged datafile copydatafile Copy file name=/u11/app/oracle/oradata/dupdb/sysaux01.dbf RECID=1 STAMP=883405119cataloged datafile copydatafile Copy file name=/u11/app/oracle/oradata/dupdb/yb01.dbf RECID=2 STAMP= 883405119cataloged datafile copydatafile Copy file name=/u11/app/oracle/oradata/dupdb/users01.dbf recid=3 stamp= 883405119cataloged datafile copydatafile Copy file name=/u11/app/oracle/oradata/dupdb/example01.dbf recid=4 STAMP= 883405119cataloged datafile copydatafile Copy file name=/u11/app/oracle/oradata/dupdb/undotbs02.dbf recid=5 STAMP= 883405119datafile 2 switched to datafile copyinput datafile copy recid=1 stamp=883405119 file Name=/u11/app/oracle/oradat A/dupdb/sysaux01.dbfdatafile 3 switched to datafile copyinput datafile copy recid=2 stamp=883405119 file name=/u11/app/or Acle/oradata/dupdb/yb01.dbfdatafile 4 switched to datafile copyinput datafile copy recid=3 STAMP=883405119 file Name=/u11 /app/oracle/oradata/dupdb/users01.dbfdatafile 5 switched to datafile copyinput datafile copy RECID=4 STAMP=883405119 File name=/u11/app/oracle/oradata/dupdb/example01.dbfdatafile 6 switchEd to datafile copyinput datafile copy recid=5 stamp=883405119 file name=/u11/app/oracle/oradata/dupdb/ Undotbs02.dbfcontents of Memory script:{Alter clone database open resetlogs;}  Executing Memory scriptdatabase openedfinished Duplicate Db at 26-jun-2015 14:19:00rman>

Use the duplicate target database ... from active databases to replicate from