RMAN> duplicate target database for standby from active database nofilenamecheck; Starting Duplicate Db at 06-APR-19 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=248 device type=DISK contents of Memory Script: { backup as copy reuse targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwadgdb' auxiliary format '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwadgdbstandby' ; } executing Memory Script Starting backup at 06-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=23 device type=DISK Finished backup at 06-APR-19 contents of Memory Script: { ctl'; restore clone controlfile to '/u01/app/oracle/oradata/adgdbstandby/control02.ctl' from '/u01/app/oracle/oradata/adgdbstandby/control01.ctl'; } executing Memory Script Starting backup at 06-APR-19 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file 183 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 06-APR-19 Starting restore at 06-APR-19 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: copied control file copy Finished restore at 06-APR-19 contents of Memory Script: { sql clone 'alter database mount standby database'; } executing Memory Script sql statement: alter database mount standby database contents of Memory Script: { set newname for tempfile 1 to "/u01/app/oracle/oradata/adgdbstandby/temp01.dbf"; switch clone tempfile all; set newname for datafile 1 to "/u01/app/oracle/oradata/adgdbstandby/system01.dbf"; set newname for datafile 2 to "/u01/app/oracle/oradata/adgdbstandby/sysaux01.dbf"; set newname for datafile 3 to "/u01/app/oracle/oradata/adgdbstandby/undotbs01.dbf"; set newname for datafile 4 to "/u01/app/oracle/oradata/adgdbstandby/users01.dbf"; set newname for datafile 5 to "/u01/app/oracle/oradata/adgdbstandby/example01.dbf"; backup as copy reuse datafile 1 auxiliary format "/u01/app/oracle/oradata/adgdbstandby/system01.dbf" datafile 2 auxiliary format "/u01/app/oracle/oradata/adgdbstandby/sysaux01.dbf" datafile 3 auxiliary format "/u01/app/oracle/oradata/adgdbstandby/undotbs01.dbf" datafile 4 auxiliary format "/u01/app/oracle/oradata/adgdbstandby/users01.dbf" datafile 5 auxiliary format "/u01/app/oracle/oradata/adgdbstandby/example01.dbf" ; sql 'alter system archive log current'; } executing Memory Script executing command: SET NEWNAME renamed tempfile 1 to /u01/app/oracle/oradata/adgdbstandby/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 06-APR-19 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=/u01/app/oracle/oradata/adgdb/system01.dbf output file name=/u01/app/oracle/oradata/adgdbstandby/system01.dbf tag=TAG20190406T160954 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=/u01/app/oracle/oradata/adgdb/sysaux01.dbf output file name=/u01/app/oracle/oradata/adgdbstandby/sysaux01.dbf tag=TAG20190406T160954 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:36 channel ORA_DISK_1: starting datafile copy input datafile file number=00005 name=/u01/app/oracle/oradata/adgdb/example01.dbf output file name=/u01/app/oracle/oradata/adgdbstandby/example01.dbf tag=TAG20190406T160954 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=/u01/app/oracle/oradata/adgdb/undotbs01.dbf output file name=/u01/app/oracle/oradata/adgdbstandby/undotbs01.dbf tag=TAG20190406T160954 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=/u01/app/oracle/oradata/adgdb/users01.dbf output file name=/u01/app/oracle/oradata/adgdbstandby/users01.dbf tag=TAG20190406T160954 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 06-APR-19 sql statement: alter system archive log current contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=9 STAMP=1004890308 file name=/u01/app/oracle/oradata/adgdbstandby/system01.dbf datafile 2 switched to datafile copy input datafile copy RECID=10 STAMP=1004890308 file name=/u01/app/oracle/oradata/adgdbstandby/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=11 STAMP=1004890308 file name=/u01/app/oracle/oradata/adgdbstandby/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=12 STAMP=1004890308 file name=/u01/app/oracle/oradata/adgdbstandby/users01.dbf datafile 5 switched to datafile copy input datafile copy RECID=13 STAMP=1004890308 file name=/u01/app/oracle/oradata/adgdbstandby/example01.dbf Finished Duplicate Db at 06-APR-19