I want to clean up my recovery catalog database.
I was forced to delete old backup sets by hand due to space considerations and I would like to remove their records from the recovery catalog.
Anybody have any ideas?
Thanks in advance.
Printable View
I want to clean up my recovery catalog database.
I was forced to delete old backup sets by hand due to space considerations and I would like to remove their records from the recovery catalog.
Anybody have any ideas?
Thanks in advance.
First, you issue
RMAN>allocate channel for maintenance type disk;(if you are using disk)
RMAN>list backup;
RMAN>change backupset backupset#,...., delete;
then and run the script
$ORACLE_HOME/rdbms/admin/prgrmanc.sql
and it will remove all the backupsets marked as delete in your recovery catalog.