转载请注明转载自:忆雨林枫

RMAN-05001: auxiliary file name xxx conflicts with a file used by the target database

channel ORA_AUX_DISK_1: SID=767 device type=DISK

channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oradata/xyjdb/sysdata/control_01.ctl
output file name=/oradata/xyjdb/appdata/control_03.ctl
output file name=/u01/app/oracle/oradata/xyjdb/control_02.ctl
Finished restore at 2017/06/07 14:43:49

database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=767 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/07/2017 14:43:58
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /oradata/xyjdb/appdata/auto_task.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oradata/xyjdb/appdata/xyjloan.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oradata/xyjdb/sysdata/sysaux02.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oradata/xyjdb/sysdata/system02.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oradata/xyjdb/appdata/USERS.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oradata/xyjdb/sysdata/undo01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oradata/xyjdb/sysdata/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oradata/xyjdb/sysdata/system01.dbf conflicts with a file used by the target database

RMAN>

原因:因为新创建备库的数据库文件路径名称和主库一样,oracle为了避免错误的覆盖,所以才抛出这样的错误。
解决: duplicate target database for standby nofilenamecheck;
再次来过一遍,添加nofilenamecheck。