how to delete old backups after reset;ogs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to delete old backups after reset;ogs

  1. #1
    Join Date
    Aug 2000
    Posts
    87

    how to delete old backups after reset;ogs

    Hi ,

    How do i delete old backups from RMAN after opening the database with resetlogs.Here is the scenario.Assume i got 1 weeks data from sunday to sunday.After a week On Monday database crash lost all the database files,redos,control files,restored and recovered the databases and opened the DB with reset logs ok.

    Now I want to delete the backups which are older than 6 days.When i try to generate the obsolete list.It gives me the following error.

    RMAN> report obsolete until time 'sysdate-1';

    RMAN-03022: compiling command: report
    RMAN-03026: error recovery releasing channel resources
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: report
    RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME is before RESETLOGS time

    So do i need to reset the incarnation to previous one to delete the old backups from tape???

    Thanks in advance
    Regards,
    Vinod

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Yes after you do an open reset logs, you need to resync the database with the catalog or reset the incarnation, though im not very sure.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    132
    There is no doubt just do a reset database only at the RMAN prompt :
    RMAN>reset database;
    The "reset database" command gives confirmation to RMAN that you issued a resetlogs.
    Giani

  4. #4
    Join Date
    Aug 2000
    Posts
    87
    I know that we have to use reset database to make the database to current incarnation.Please understand my Question.After i do so,my database is in different incarnation.Ok.Now i dont want all those backups whichever i have taken before,So i want to delete those backups.when i want to see all those before 1 day

    RMAN>report obsolete until time 'SYSDATE-1';

    The above mentioned error is generated.Then how can i delete the old backups from tape.

    regards,
    Vinod

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