Oracle Database Administration II — Question 158

Some archived log backups have been accidentally deleted from storage.

Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups? (Choose two.)

Answer options

• A. RESYNC CATALOG
• B. REPORT OBSOLETE
• C. LIST ARCHIVELOG ALL
• D. CROSSCHECK BACKUP OF ARCHIVELOG ALL
• E. LIST ARCHIVELOG
• F. LIST EXPIRED

Correct answer: D, F

Explanation

The correct commands, D (CROSSCHECK BACKUP OF ARCHIVELOG ALL) and F (LIST EXPIRED), are used to verify the existence of backups and to list those that have been marked as expired. Options A, B, C, and E do not specifically address updating the status of missing backups in the recovery catalog.