DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Cleaning RMAN

  1. #1
    Join Date
    Dec 1999
    Location
    San Ramon, CA, USA
    Posts
    21

    Cleaning RMAN

    Hi to all,
    I have a quick question, I was using RMAN to perform my backups and those backuped files were generated on an NFS mounted drive.
    Now someone remove the NFS mounted drive so my catalog is out of Sync.
    I'd like to start all over on my RMAN configuration, so my question is:
    Can I just :
    1- connect to RMAN and perform a drop catalog;
    2- then delete all the rman backuped files?
    3- After that create the catalog again

    I will have anything wrong doing this?

    Thanks,
    Diego

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    hi diego....i suggest u create a test db to be sure then play over

    You can try also:

    rman> crosscheck backup;
    rman> reports obsolete;
    rman> delete obsolete;
    rman> report schema;
    rman> report need backup;
    rman> list backup;
    rman> list expired backup;
    rman> delete expired backup;

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Hi Davey n Friends,

    I got problem with this rman> delete obsolete COMMAND.
    I do manual deletion of old archive logs after i backup our
    database for the current date. But rman keep on tracking it too
    so i want to delete it from its database or from the controlfile.
    So when i do the following

    rman target / nocatalog
    rman> crosscheck backup;
    rman> report obsolete; ### this will report obsolete archivelogs
    rman> delete obsolete; ### this will delete obsolete archivelogs
    **** but the problem is the list still persist or showing.
    How do I clear it up?

    Thanks

  4. #4
    Join Date
    Feb 2003
    Posts
    63
    crosscheck the archive logs as well crosscheck everything

    Not sure on the exact syntax

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