Home > Oracle > Unregister Database From RMAN catalog using rman

Unregister Database From RMAN catalog using rman


First select the DBID from rman catalog that needs to be unregistered

SQL>  select db_key,DBID,NAME from  rc_database where name='UKPROD';

    DB_KEY       DBID NAME
---------- ---------- --------
   4537165 3907766204 UKPROD

[oracle@udbmon10]$ rman catalog rcat/liverxxxx

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Nov 14 13:01:39 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> set  DBID 3907766204

executing command: SET DBID
database name is "UKPROD" and DBID is 3907766204

RMAN> unregister database ;

database name is "UKPROD" and DBID is 3907766204

Do you really want to unregister the database (enter YES or NO)? YES
database unregistered from the recovery catalog

RMAN> exit

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: