Recovery Manager: Release 11.2.0.4.0 - Production on Sat Feb 10 20:29:02 2024
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: COCO (DBID=3082357723) connected to auxiliary database: COCO (not mounted)
RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 10-FEB-24 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=133 instance=coco1 device type=DISK
contents of Memory Script: { backup as copy reuse targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwcoco1' auxiliary format '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwcoco1' ; } executing Memory Script
Starting backup at 10-FEB-24 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=76 instance=coco1 device type=DISK Finished backup at 10-FEB-24
contents of Memory Script: { backup as copy current controlfile for standby auxiliary format '+DATA/coco/control01.ctl'; restore clone controlfile to '+DATA/coco/control02.ctl' from '+DATA/coco/control01.ctl'; } executing Memory Script
Starting backup at 10-FEB-24 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_coco1.f tag=TAG20240210T202920 RECID=1 STAMP=1160598564 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 10-FEB-24
Starting restore at 10-FEB-24 using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy Finished restore at 10-FEB-24
contents of Memory Script: { sql clone 'alter database mount standby database'; } executing Memory Script
sql statement: alter database mount standby database RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 02/10/2024 20:29:37 RMAN-05501: aborting duplication of target database RMAN-05001: auxiliary file name +DATA/coco/undotbs02.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name +DATA/coco/users01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name +DATA/coco/undotbs01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name +DATA/coco/sysaux01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name +DATA/coco/system01.dbf conflicts with a file used by the target database
CAUSE
The RMAN-00501 error is common if you are duplicating to a server with the same file directory structure.
SOLUTION
RMAN> duplicate target database for standby from active database nofilenamecheck;
