Re: How remove database from catalog if server dies
From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Wed, 1 Jul 2009 12:34:58 -0500
Message-ID: <e9569ef30907011034i32635500u43c6f6c0f8ee1b7f_at_mail.gmail.com>
Jeffrey,
This can be done for sure with 10g or later databases.
Date: Wed, 1 Jul 2009 12:34:58 -0500
Message-ID: <e9569ef30907011034i32635500u43c6f6c0f8ee1b7f_at_mail.gmail.com>
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_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-lReceived on Wed Jul 01 2009 - 12:34:58 CDT