[oracle@oracle235 admin]$ rman target sys/li0924@tns_primary auxiliary sys/li0924@tns_standby Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 9 23:56:46 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ORA235 (DBID=2047494122) connected to auxiliary database: ORA235 (not mounted) RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK; Starting Duplicate Db at 09-AUG-18 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=20 device type=DISK contents of Memory Script: { backup as copy reuse targetfile '/u01/app/oracle/dbs/orapwora235' auxiliary format '/u01/app/oracle/dbs/orapwora235' ; } executing Memory Script Starting backup at 09-AUG-18 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=26 device type=DISK Finished backup at 09-AUG-18 contents of Memory Script: { backup as copy current controlfile for standby auxiliary format '/u01/app/oradata/ora235/control01.ctl'; restore clone controlfile to '/u01/app/oradata/ora235/control02.ctl' from '/u01/app/oradata/ora235/control01.ctl'; } executing Memory Script Starting backup at 09-AUG-18 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file output file name=/u01/app/oracle/dbs/snapcf_ora235.f tag=TAG20180809T235658 RECID=4 STAMP=983750219 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 09-AUG-18 Starting restore at 09-AUG-18 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: copied control file copy Finished restore at 09-AUG-18 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/oradata/ora235/temp01.dbf"; switch clone tempfile all; set newname for datafile 1 to "/u01/app/oradata/ora235/system01.dbf"; set newname for datafile 2 to "/u01/app/oradata/ora235/sysaux01.dbf"; set newname for datafile 3 to "/u01/app/oradata/ora235/undotbs01.dbf"; set newname for datafile 4 to "/u01/app/oradata/ora235/users01.dbf"; set newname for datafile 5 to "/data/oracle/data/lottu01.dbf"; backup as copy reuse datafile 1 auxiliary format "/u01/app/oradata/ora235/system01.dbf" datafile 2 auxiliary format "/u01/app/oradata/ora235/sysaux01.dbf" datafile 3 auxiliary format "/u01/app/oradata/ora235/undotbs01.dbf" datafile 4 auxiliary format "/u01/app/oradata/ora235/users01.dbf" datafile 5 auxiliary format "/data/oracle/data/lottu01.dbf" ; sql 'alter system archive log current'; } executing Memory Script executing command: SET NEWNAME renamed tempfile 1 to /u01/app/oradata/ora235/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 09-AUG-18 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile file number=00005 name=/data/oracle/data/lottu01.dbf output file name=/data/oracle/data/lottu01.dbf tag=TAG20180809T235706 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45 channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=/u01/app/oradata/ora235/system01.dbf output file name=/u01/app/oradata/ora235/system01.dbf tag=TAG20180809T235706 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=/u01/app/oradata/ora235/sysaux01.dbf output file name=/u01/app/oradata/ora235/sysaux01.dbf tag=TAG20180809T235706 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=/u01/app/oradata/ora235/undotbs01.dbf output file name=/u01/app/oradata/ora235/undotbs01.dbf tag=TAG20180809T235706 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=/u01/app/oradata/ora235/users01.dbf output file name=/u01/app/oradata/ora235/users01.dbf tag=TAG20180809T235706 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 10-AUG-18 sql statement: alter system archive log current contents of Memory Script: { backup as copy reuse archivelog like "/data/arch/1_3_983660602.dbf" auxiliary format "/data/arch/1_3_983660602.dbf" ; catalog clone archivelog "/data/arch/1_3_983660602.dbf"; switch clone datafile all; } executing Memory Script Starting backup at 10-AUG-18 using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log copy input archived log thread=1 sequence=3 RECID=19 STAMP=983750428 output file name=/data/arch/1_3_983660602.dbf RECID=0 STAMP=0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 Finished backup at 10-AUG-18 cataloged archived log archived log file name=/data/arch/1_3_983660602.dbf RECID=1 STAMP=983750429 datafile 1 switched to datafile copy input datafile copy RECID=4 STAMP=983750429 file name=/u01/app/oradata/ora235/system01.dbf datafile 2 switched to datafile copy input datafile copy RECID=5 STAMP=983750429 file name=/u01/app/oradata/ora235/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=6 STAMP=983750429 file name=/u01/app/oradata/ora235/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=7 STAMP=983750429 file name=/u01/app/oradata/ora235/users01.dbf datafile 5 switched to datafile copy input datafile copy RECID=8 STAMP=983750429 file name=/data/oracle/data/lottu01.dbf contents of Memory Script: { set until scn 955597; recover standby clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 10-AUG-18 using channel ORA_AUX_DISK_1 starting media recovery archived log for thread 1 with sequence 3 is already on disk as file /data/arch/1_3_983660602.dbf archived log file name=/data/arch/1_3_983660602.dbf thread=1 sequence=3 media recovery complete, elapsed time: 00:00:00 Finished recover at 10-AUG-18 Finished Duplicate Db at 10-AUG-18