This content has been marked as final. Show 3 replies
how to find expired RMAN backup?Expired backup is backup that is registered in rman repository but not exists on device due to removing by OS commands etc.
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?)
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.
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.