Home » RDBMS Server » Backup & Recovery » How to remove a recovery catalog?
How to remove a recovery catalog? [message #190052] Tue, 29 August 2006 02:48 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 07:28:40 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.