You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist. Which command should you now use to check if any of the files were missing?
-
LIST EXPIRED
-
DELETE EXPIRED
-
DELETE OBSOLETE
-
CHANGE UNCATALOG
A
Correct answer
Explanation
LIST EXPIRED shows files marked EXPIRED after CROSSCHECK - meaning the backup record exists but the file is missing. DELETE EXPIRED would remove these records. DELETE OBSOLETE removes backups older than retention policy. CHANGE UNCATALOG removes records from the repository entirely.