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

I got ” RMAN-05001 auxiliary filename string conflicts with a file used by the target database ”  error in Oracle database.

 

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

 

Details of error are as follows.

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

 

 

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

This RMAN-05001 error is related with the 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.

To solve this error, 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.

 

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 /<directory1/<name>.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /<directory1/<name>.dbf

 

 

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

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

 

RMAN> run {
        set until time "to_date('2021/05/06 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

 

You should run the following command if you want to use duplicate target database command.

duplicate target database for standby nofilenamecheck;

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

 213 views last month,  4 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply