-
UNregister database through RMAN
OS: Solaris 2.8
RMAN Catalog: 9.2.0.2
RMAN Target: 8.1.7.4 and 8.1.6.1
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?
Jeff Hunter
-
-
Hi,
Logon to your rman respository (sqlplus rman/rman@ract)
query the rc_database view:
select db_key, dbid from rc_database;
DB_KEY DBID
---------- ----------
1 3369942583
with the selected values issue:
exec dbms_rcvcat.unregisterdatabase(1,3369942583);
Cheers,
R.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|