UNregister database through RMAN
OS: Solaris 2.8
RMAN Catalog: 184.108.40.206
RMAN Target: 220.127.116.11 and 18.104.22.168
I have two seperate recovery catalogs; one owned by rman816 and one owned by rman817 in the same instance. I have a database that I cloned via copying files from the OS to result in PROD and TEST. I registered the PROD database in the rman816 catalog and the TEST database in the rman817 catalog after I upgraded it to 8.1.7. Now, I have upgraded my PROD database to 8.1.7 and I want to register it with the rman817 catalog, but the DBID already exists because of the TEST database.
I can't drop my catalog because other databases exist in the rman817 catalog.
How do I "unregister" my TEST database so I can register my PROD database?
Logon to your rman respository (sqlplus rman/rman@ract)
query the rc_database view:
select db_key, dbid from rc_database;
with the selected values issue:
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
Click Here to Expand Forum to Full Width