Last updated on December 21st, 2015 at 04:14 am
Problem:When Recovery catalog has been configured.and Production Database has been cloned and a connection has been made from the clone to Catalog database using rman with out changing the DBID of the clone,then we are in some trouble
Then when you try to backup the production instance with the catalog,The backup fails with following error
RMAN-06004: ORACLE error from recovery catalog database
RMAN-20004: target database name does not match name in recovery catalog
This errors happens,as clone instance replaces the prod instance in the catalog.
Following queries could be used to confirm this
Select dbid,name from v$database ; —> This will provide PROD DBID
Select dbid,name ,DBINC_KEY,RESETLOGS_CHANGE# from rc_database ; –> This query in catalog will provide the dbid information.It will shows clone registered instead of production with same DBID
Solution:If clone backup are not required in catalog,Do this
connect to catalog from clone and fire the command
Then connect to catalog from Production
Hopefully the problem should resolve
Please take appropiate backup of catalog before attempting any thing.
If the clone backup is required, Please change the DBID of the clone database using NID