Duplicate Command Failed: RMAN-05001: auxiliary filename %s conflicts with a file used by the target database


Error Description:
RMAN Duplicate database command failed with RMAN-05001 error message
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 21/10/2012 23:09:54
RMAN-05501: aborting duplication of target database

RMAN-05001: auxiliary filename +DATA/prod/datafile/system.277.76879881 conflicts with a file used by the target database

Solution Description
RMAN is trying to restore the datafile to the same location as in the target database. But the datafile is already present in the location. 2 options you can choose to resolve this error.

  1. Set DB_FILE_NAME_CONVERT AND LOG_FILE_NAME_CONVERT parameter to the auxiliary database parameter file and reinitiate the duplicate command. These parameters internally redirect the datafiles to the new location.

DB_FILE_NAME_CONVERT=('+DATA/source/datafile/','+DATA/target/datafile/','+DATA/source/tempfile/','+DATA/target/tempfile/')
LOG_FILE_NAME_CONVERT=('+DATA/source/onlinelog/','+DATA/target/onlinelog/')
  1. Reinitiate the RMAN duplicate with nofilenamecheck option. There is a risk involved in nofilenamecheck as it will overwrite the files already present in the directory or filesystem. The syntax for the command is as below.

duplicate target database to testdb1 until scn 1674927122 nofilenamecheck;
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google