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

╰+哭是因爲堅強的太久メ 2022-09-29 00:24 86阅读 0赞

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

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;