Re: How remove database from catalog if server dies

  • From: Bradd Piontek <piontekdd@xxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx
  • Date: Wed, 1 Jul 2009 12:34:58 -0500

Jeffrey,
  This can be done for sure with 10g or later databases.

  First, get the DBID from the catalog (sqlplus)

SELECT db_key, dbid, name from rc_database;

  You can connect to the catalog only
rman catalog=<yourconnectstring>

SET DBID=<dbid>;
unregister database;

That should do it.

Bradd Piontek
  "Next to doing a good job yourself,
        the greatest joy is in having someone
        else do a first-class job under your
        direction."
 -- William Feather


On Wed, Jul 1, 2009 at 12:26 PM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>wrote:

>  Assume database A is on server A and server A dies.  How can I unregister
> database A from the recovery catalog if the database no longer exists?
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>

Other related posts: