OraFAQ Forum: Backup & Recovery » How to remove a recovery catalog?

Home » RDBMS Server » Backup & Recovery » How to remove a recovery catalog?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to remove a recovery catalog? [message #190052]

Tue, 29 August 2006 02:48

kinde
Messages: 5
Registered: August 2006
Location: xiamen

Junior Member

I have create a recovery catalog and register to target database,

Rman catalog rman/rman
Create catalog tablespace rman_repository;
Connect target system/manager
Register database;

How can i remove this catalog and unregister database;

Report message to a moderator

Re: How to remove a recovery catalog? [message #190130 is a reply to message #190052]

Tue, 29 August 2006 06:00

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You don't mention what version of the database you are on, but this will work for 9i and below (10g offers a new method. This may also work for 10g, I haven't tested):

SQL> select db_key, dbid from rc_database;

SQL> execute dbms_rcvcat.unregisterdatabase(<db_key>, <db_id>);

It would be nice to have a required field for posts to enter version # of database.

Report message to a moderator

Re: How to remove a recovery catalog? [message #190173 is a reply to message #190130]

Tue, 29 August 2006 09:47

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

agreed with ebrian. We need version # to provide better details.

Starting with 10g we can do it in easy way,

RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;

Sandeep

Report message to a moderator

Re: How to remove a recovery catalog? [message #190458 is a reply to message #190052]

Wed, 30 August 2006 19:49

kinde
Messages: 5
Registered: August 2006
Location: xiamen

Junior Member

I had remove the catalog success!
thanks very much!
and my db's version# is 8i.

Report message to a moderator

Previous Topic:	how to restore the backuped files
Next Topic:	i can get hot backup but how can logging asm pls send immediately

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 15 19:04:50 CST 2025