Wednesday, June 22, 2011

RMAN-05001 :Auxiliary Filename Conflicts with a File Used by the Target Database

If we lookup the cause of error   RMAN :05001 we find that this error has occur because  RMAN is attempting to use the specified file name as a restore destination in the auxiliary database, but this name is already in use by the target database. 

If we are experiencing RMAN-05001: auxiliary filename conflicts with a file used by the target database, then we may be confused as I was about how to proceed. If we are converting ALL files from various locations to new locations, then use db_file_name_convert. If we want to retain the exact same locations with no conversion, we use NOFILENAMECHECK. But what if we want to convert some, and not convert others? I was not sure whether NOFILENAMECHECK would then override db_file_name_convert, but it turns out that we can use both in concert. For those files that are in the same location, it will not complain, but the others that we want to convert will be converted properly from the db_file_name_convert entries in our pfile.

Enjoy   :-) 

No comments: