Question:
I am trying to clone a database using RMAN and I get the
following RMAN-05001 error:
RMAN-05001: auxiliary filename /xxx/xxx/xx.dbf conflicts with a file
used by the target database tips
How do I fix the RMAN-05001 error?
Answer: See here, how to
clone a database with RMAN.
First, ALWAYS start by looking-up the RMAN-05001error message.
Start by using the
oerr
utility to look-up the RMAN-05001 error:
RMAN-05001 auxiliary
filename string conflicts with a file used by the target database
Cause: 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.
Action: Use the SET AUXNAME
command to specify a name for the datafile that does not conflict
with a file name in use by the target database
The RMAN-00501
error is common if you are duplicating to a server with the same
file directory structure. As we see in the RMAN-00501 action, the
recommended solution for the RMAN-05001 error is to use the
configure auxname command:
configure auxname for datafile '/xxx/xxx.dbf' to '/yyy/xxx.dbf';
This RMAN-05001 error may also be a bug, and the workaround is to
add the NOFILENAMECHECK option to the duplicate command.
duplicate target database for standby dorecover NOFILENAMECHECK;
or
duplicate target database to
nofilenamecheck;
It is also important that you have set your init.ora parameter
db_file_name_convert. There should be an appropriate mapping
between the primary's and standby's disk mount points using the
parameter db_file_name_convert.
The db_file_name_convert parameter is used to convert the
filename on the primary database to a filename on the standby
database.
The value of this parameter should be set in a pair of strings. The
first string should correspond to the filename pattern on the
primary database and the next string to the filename pattern on the
standby database.
More than one pair can be specified if there is a need to
accommodate more than one pattern in filename changes between the
primary and the standby database.
|
|
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
Burleson
Oracle ®
is the registered trademark of Oracle Corporation.
|
|
