RMAN-05001: auxiliary file name conflicts with a file used by the target database

In 11g, duplicate a standby database from active database with “RMAN-05001” error:

RMAN> run {
      duplicate target database for standby from active database;
      }

RMAN-05001: auxiliary file name /u02/oradata/TESTDBSTY/sysaux01.dbf 
            conflicts with a file used by the target database

WORKAROUND

The issue is a bug, it seems the file system for both primary and standby database are the same, though “db_file_name_convert” and “log_file_name_convert” are configured already.

Add “NOFILENAMECHECK” option into duplicate RMAN command:

RMAN> run 
      {
         duplicate target database for standby 
         from active database nofilenamecheck;
      }

This issue does not happen on 12c, so it seems a bug for 11g.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.