Unregister Oracle database from recovery catalog when db is unavailable

The normal RMAN method with database target connection

To unregister an Oracle database from a recovery catalog you normally connect to the target database and the recovery catalog using RMAN (recovery manager) and issue the UNREGISTER DATABASE command. Like this.

 $ rman 
RMAN> connect target / 
RMAN> connect catalog rcat@rcatdb
RMAN> unregister database;

But what if you want to unregister a database that has been deleted, or is unavailable for other reasons?

Unregistering a database that is not available

It is possible to unregister a database without connecting to the target database. Do this by connecting to the recovery catalog database using SQL*Plus and logging in as the recovery catalog owner.

Query the rc_database view, to find the db_key and dbid of the database that you want to unregister. Then, execute the DBMS_RCVCAT.unregisterdatabase procedure using the information you just gathered as in-parameters and the database will be unregistered.

$ sqlplus rcat@rcatdb
SQL> SELECT db_key, dbid FROM rc_database WHERE name='DB_TO_REMOVE';

 DB_KEY     DBID
--------   -----------
4567       1948934923
SQL> execute DBMS_RCVCAT.unregisterdatabase (4567,1948934923);
PL/SQL procedure successfully completed.


Comments

Post a Comment

Popular posts from this blog

Set up CrashPlan on QNAP NAS using QPKG, the easy way

Image
Introduction to CrashPlan Description Here's how Wikipedia describes CrashPlan backup software: CrashPlan is backup software that allows Windows, Mac, Linux and Solaris users to back up their data to an offsite data center, computers belonging to friends and family, as well as to attached drives / shared folders. There is a free version (for non-datacenter backups) and CrashPlan+ which is for backing up to CrashPlan's servers. Both versions allow users to back up data automatically. How it can be used on your NAS If you are the owner of a NAS from QNAP, you can install CrashPlan and use it to backup the contents of your NAS to the CrashPlan data center, to other computers and/or external harddisks. You can also allow incoming backups, so that you and your friends and family can back up valuable documents and files to your NAS. Installation instructions I will not go into any more detail about what CrashPlan is. It's time to get it installed and set up on a
Read more

Samsung Account "processing failed" after firmware upgrade

How to resolve the "Processing failed" error logging in to Samsung Account after upgrade A Samsung Account can be used to remotely control your phone. From your web browser you can locate your phone on a map, trigger an alarm so that you can find it in your home, wipe the contents of the phone if it's been stolen, and more. Simply put; it may prove to be very useful when something bad has happened. After upgrading my Samsung Galaxy S2 phone to Ice Cream Sandwich (ICS), I got the error message "Processing failed" when trying to log in to my Samsung Account. Searching the web I found that I'm definitely not the only one. The solution is very easy, once you know about it.
Read more

How to remove Vlingo/Voice Command from your Android phone without rooting

Here's an easy way to remove/uninstall "Voice Command" from Vlingo, the annoying app that starts every time the home button is double-tapped on Samsung Galaxy S2. And sometimes when it's just pressed once... Since "Voice Command" is a system application, it's not easily uninstalled and used to require the phone to be rooted and thus warranty voided. Unlike the other ways of removing the app, this method works on Android phones that have been upgraded to "Ice-Cream Sandwich" (ICS) and does not require the phone to be "rooted" . Please note that there may not be a way to install it again, should you change your mind later. Maybe a factory reset brings it back, maybe it doesn't. I don't know, and have not tried to get it back. Follow these steps to remove "Voice Command" from your Galaxy S2 with ICS without root
Read more