RMAN Catalog Cleanup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RMAN Catalog Cleanup

  1. #1
    Join Date
    Sep 2001
    Location
    Bathurst NSW Austrlai
    Posts
    2
    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.

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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 rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width