Re: How remove database from catalog if server dies

From: David Barbour <david.barbour1_at_gmail.com>
Date: Wed, 1 Jul 2009 13:41:23 -0400
Message-ID: <69eafc3f0907011041j25fb65e2t5f30817844e689e_at_mail.gmail.com>

Get the DBID of the non-existent database from the catalog. Log into the catalog instance as the rman user and 'select db_id from db where db_key in (select db_key from dbinc where db_name= '<SID>');

On any other database server start an RMAN session and connect to the catalog, NOT the target!

RMAN>set dbid nnnnnnnnnnnnn; <-- dbid returned from query above RMAN>unregister database;

On Wed, Jul 1, 2009 at 1:26 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 01 2009 - 12:41:23 CDT