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
After CROSSCHECK BACKUP, use LIST EXPIRED to see which backup files are missing. CROSSCHECK marks files as EXPIRED if they cannot be found on disk. LIST EXPIRED shows these expired backups without deleting them. DELETE EXPIRED would remove the records, DELETE OBSOLETE removes backups no longer needed per retention policy, and CHANGE UNCATALOG removes files from the repository entirely.