Saturday 20 September 2014

RMAN-20004: target database name does not match name in recovery catalog

After production database(PCARD) clone with same DBID but different name(PCARDQC7).

PCARD --> dbname of production database
PCARDQC7 -> dbname of cloned database
dbid --> 1781864831 for both PCARD and PCARDQC7 .

In production database:-
SQL> select dbid,name,CREATED  from v$database;

      DBID NAME      CREATED
---------- --------- ---------
1781864831 PCARD   21-SEP-13


SQL> select dbid,name,CREATED  from v$database;

      DBID NAME      CREATED
---------- --------- ---------
3057056505 PCADQC7 26-SEP-14

In Cloned server connect to PCARDQC7 and unregister it from catalog:
export ORACLE_SID=pcardqc7
rman target / catalog rman/rman@rmancat
rman > unregister database; -- This command available in 10.1 onwards.

In production server connect to PCARD and re-register in catalog:
export ORACLE_SID=pcard
rman target / catalog rman/rman@rmancat
rman > register database;










No comments:

Post a Comment

Number of Visitors