Sunday, November 15, 2015

RMAN-05001 auxiliary filename string conflicts with a file used by the target database

If this error message is being returned during RMANDUPLICATE DATABASE command, it is because RMAN would try to created destination files at the same location where source database files exist; and since it cannot overwrite existing files, so it and returns error message. To avoid this error, NOFILENAME check option should be used with DUPLICATE command. Otherwise use one of the following to specify different file names
  • Use DB_FILE_NAME_CONVERT init parameter
  • Use DB_FILE_NAME_CONVERT option in DUPLICATE command
  • SET NEWNAME  for each datafile in the RMAN run block with DUPLICATE command

No comments: