This discussion is archived
3 Replies Latest reply: Feb 9, 2013 2:31 AM by Shivananda Rao RSS

how to find expired backup?

DB Newbie
Currently Being Moderated
Dear All,

how to find expired RMAN backup?
how it got expired?(according to which concept)
expired RMAN backup not used to restore?
If catalog database is their we need to register and then take backup?(is must?)
sorry for easy questions..but i'm in situation to know?
please help me :-)


Note:oracle 9i
Os:HP-UX
regards,
DB :-)

Edited by: DB on Feb 9, 2013 2:42 PM
  • 1. Re: how to find expired backup?
    Mihael Pro
    Currently Being Moderated
    how to find expired RMAN backup?
    how it got expired?(according to which concept)
    expired RMAN backup not used to restore?
    If catalog database is their we need to register and then take backup?(is must?)
    Expired backup is backup that is registered in rman repository but not exists on device due to removing by OS commands etc.
    These backups can be found by "crosscheck" command.
    Backups that are not needed to restore are called obsolete backups. They are obsolete according to retention policy that you set and can be found by "report obsolete" command.
  • 2. Re: how to find expired backup?
    yoonas Expert
    Currently Being Moderated
    Hi,

    >
    how to find expired RMAN backup?
    how it got expired?(according to which concept)
    >

    http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmquick.htm#CIHCGGEI

    This guide can can give you even more ;)
    http://docs.oracle.com/cd/E11882_01/backup.112/e10642/toc.htm


    Regards
    Yoonas
  • 3. Re: how to find expired backup?
    Shivananda Rao Guru
    Currently Being Moderated
    Hello,

    Expired backups are those that are unavailable on the location that you had taken the backup (disk or tape). Running a "crosscheck backup" lists out the expired backups and also updates the repository saying that these backups have been expired. You can delete the expired backups using "delete expired backup".

    If you have the backups copied to a different location using OS commands and if the repository is not updated, then the crosscheck commands lists these backups to be expired. If these backups are required for a restoration purpose, then you can catalog them to the location where they are currently place using "catalog start with <path where the backup is stored>".

    Since you are on 9i, "catalog start with .." is not supported. May be you can use this DBMS_RCVMAN package but not sure about its usage.


    Regards,
    Shivananda

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points