Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 11.2.0.2 - Release: 9.2 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2010***

Symptoms

RMAN Duplicate fails with following errors, even though allocated channel for duplication is auxiliary.

sql statement: alter database mount standby database
released channel: aux1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/18/2005 02:07:52
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename /qmaxnt/u04/qmaxntorafiles/table/QMAXAD08_03.dbf
conflicts with a file used by the target database
RMAN-05001: auxiliary filename /qmaxnt/u04/qmaxntorafiles/table/QMAXAD08_02.dbf

Cause

Production and Auxiliary have same directory structure and are running on two different machines.  RMAN must be told not check that the target datafiles are sharing the same names as the duplicated files being created.   Otherwise, the following errors will be returned:

RMAN-05001: auxiliary filename /qmaxnt/u04/qmaxntorafiles/table/QMAXAD08_03.dbf
conflicts with a file used by the target database
RMAN-05001: auxiliary filename /qmaxnt/u04/qmaxntorafiles/table/QMAXAD08_02.dbf

Solution

To implement the solution, please use nofilenamecheck in syntax as follows:

1. Connect to Target, auxiliary, and rman catalog and
2. use script. as

run{
set until time "to_date('2005/09/17 14:00:00','yyyy/mm/dd HH24:MI:SS')";
allocate auxiliary channel aux1 type 'sbt_tape';
allocate auxiliary channel aux2 type 'sbt_tape';
duplicate target database for standby dorecover nofilenamecheck;
}

Make sure to use auxiliary type of channel so RMAN restore take place at auxiliary database.

Connecting to recovery catalog is optional here.

nofilenamecheck clause instructs rman not to check whether target database file names share the same name as auxiliary database