This content has been marked as final. Show 4 replies
To quote the propaganda:
The term obsolete does not mean the same as expired. A backup is obsolete when REPORT OBSOLETE or DELETE OBSOLETE determines, based on the user-defined retention policy, that it is not needed for recovery. A backup is considered expired only when RMAN performs a crosscheck and cannot find the file. In short, obsolete means "not needed," whereas expired means "not found."
So based what you said DELETE EXPIRED would remove catalog records only. Since most likely physical backupsets not available. Could you confirm this please.
THANK YOU for helping to understand this. I am all set