【RMAN】RMAN-05001: auxiliary filename conflicts with the target database

RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 03/10/2017 18:22:21 RMAN-05501: aborting duplication of target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/t02.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/t01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/users01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/undotbs01.dbf conflicts with a file used by the target database RMAN-05001: auxiliary file name /u01/app/datafile/orcl/sysaux01.dbf conflicts with a file used by the target database

RMAN-05001: auxiliary file name /u01/app/datafile/orcl/system01.dbf conflicts with a file used by the target database

如果在RMAN恢复时不指定 nofilenamecheck 参数，则在数据文件相同文件名恢复时会出现RMAN-05501错误，当主库，备库的数据库文件目录是一样的时候，必须使用 nofilenamecheck参数告诉rman主库和被创建的备份库拥有一样的文件目录和文件名。

$ rman targetsys/oracle@orcl auxiliary sys/oracle@orcldg

 

Recovery Manager:Release 11.2.0.4.0 - Production on Mon Jun 27 03:19:00 2016

 

Copyright (c) 1982,2011, Oracle and/or its affiliates.  Allrights reserved.

 

connected to targetdatabase: ORCL (DBID=1443368985)

connected toauxiliary database: ORCL (not mounted)

 

RMAN> run {

allocate channelprmy1 type disk;

allocate channelprmy2 type disk;

allocate channelprmy3 type disk;

allocate channelprmy4 type disk;

allocateauxiliary channel stby1 type disk;

allocateauxiliary channel stby2 type disk;

allocateauxiliary channel stby3 type disk;

allocateauxiliary channel stby4 type disk; 

duplicate targetdatabase for standby from active database nofilenamecheck;

}