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;
}