RE: How remove database from catalog if server dies
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <JBECKSTROM@xxxxxxxxx>, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Jul 2009 13:36:29 -0400
Jeff,
Follow the method for unregistering 9i databases? Connect as the
repository owner and run as sqlplus:
Declare
L_dbkey number;
L_dbid number;
begin
select db_key,dbid
into l_dbkey,l_dbid;
from rc_database
where name = 'dbname';
dbms_rcvcat.unregisterdatabase(l_dbkey,l_dbid);
End;
Hope this helps.
Tom
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffrey Beckstrom
Sent: Wednesday, July 01, 2009 1:26 PM
To: oracle-l-freelists; oracle-db-l
Subject: How remove database from catalog if server dies
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:
