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;
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;