Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Removing Entry from Catalog

647210Mar 30 2009 — edited Mar 30 2009

Hello,

We had 7 database instances running on a server and now that server is down and database are tear down. Before this, we forgot to unregister/delete backup for these databases from recovery catalog.

Using DBID for it, I could remove it from catalog.

RMAN> SET DBID 487194766

executing command: SET DBID
database name is "GWMPI05" and DBID is 487194766

RMAN> UNREGISTER DATABASE;

database name is "GWMPI05" and DBID is 487194766

Do you really want to unregister the database (enter YES or NO)? YES

database unregistered from the recovery catalog

RMAN>

But these doesn't seem to be removing entry from catalog. I don't have target database any more so can not issue "delete backup".

So is there any way to remove entry/backup of this database from catalog ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2009

Added on Mar 30 2009

#performance-availability, #recovery-manager-rman

4 comments

1,252 views