RMAN duplicate failing
RMAN-05001: auxiliary file name '<dbfile>' conflicts with a file used by the target database
Error Message:
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_uid57.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_uid56.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data01/maximo_interfaz_03.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data74.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data73.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data72.dbf conflicts with a file used by the target database
...
CAUSE:
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:
Solution :
User CLAUSE "NOFILENAMECHECK" in Rman Duplicate command before parameter 'DB_FILE_NAME_CONVERT' and 'LOG_FILE_NAME_CONVERT'
Example:
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
NOFILENAMECHECK
PARAMETER_VALUE_CONVERT '/prod/data','/prod/data','/prod/data','/prod/data'
SET "db_unique_name"="prod1stby" COMMENT "Is a duplicate"
set db_file_name_convert='/prod/oracle/','/prod/oracle/','/prod/oracle/','/prod/oracle/'
NOTE: Do not use NOFILENAMECHECK when target and destination database are on the same box because datafiles from target database will be overwritten !!
RMAN-05001: auxiliary file name '<dbfile>' conflicts with a file used by the target database
Error Message:
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_uid57.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_uid56.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data01/maximo_interfaz_03.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data74.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data73.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /prod/data/data02/a_uie_data72.dbf conflicts with a file used by the target database
...
CAUSE:
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:
Solution :
User CLAUSE "NOFILENAMECHECK" in Rman Duplicate command before parameter 'DB_FILE_NAME_CONVERT' and 'LOG_FILE_NAME_CONVERT'
Example:
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
NOFILENAMECHECK
PARAMETER_VALUE_CONVERT '/prod/data','/prod/data','/prod/data','/prod/data'
SET "db_unique_name"="prod1stby" COMMENT "Is a duplicate"
set db_file_name_convert='/prod/oracle/','/prod/oracle/','/prod/oracle/','/prod/oracle/'
NOTE: Do not use NOFILENAMECHECK when target and destination database are on the same box because datafiles from target database will be overwritten !!
No comments:
Post a Comment