RMAN Catalog Cleanup

We have been using RMAN for 12 months now. It is time to clean up the catalog. The backup sets are writen to disk and backup up nightly then deleted next day. The catalog is growing and any reports or lists are very large. What is the best way to clean the catalog up? I cannot find a command in RMAN.

Hi,
there are methods of catalog cleanup currently available. You can also use the crosscheck backup of database.
If you are not sure if the backup is on tape or not and cannot query the indices then run but not in a run block:

RMAN> allocate channel for maintenance type 'sbt_tape';
RMAN> crosscheck backup of database;

If the backups are found in the they are marked as available. If the media manager software expired them prematurely but they still exist on tape they will be marked available. If they are available in the recovery catalog but are not in the media catalog or on tape RMAN will mark them expired in the catalog.

Then you can use:

RMAN> allocate channel for maintenance type 'sbt_tape';
RMAN> delete expired backups;

If they are expired they are marked deleted in the recovery catalog and prgrmanc.sql will complete it by remvoing the records.

Hope this helps.


In case of any help please be free to ask me at [email protected]

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]