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?

Question

Options

• ARESYNC CATALOG
• BCROSSCHECK BACKUP OF ARCHIVELOG ALL
• CLIST ARCHIVELOG ALL
• DLIST EXPIRED
• ELIST ARCHIVELOG
• FREPORT OBSOLETE

• A
  5% (1)
• B
  79% (15)
• C
  5% (1)
• F
  11% (2)

Explanation

CROSSCHECK BACKUP OF ARCHIVELOG ALL (B) physically verifies whether each archived log backup actually exists on storage, and marks any missing files as EXPIRED in the recovery catalog. LIST EXPIRED (D) then displays only those expired (i.e., missing) backups, giving you a clean view of exactly what's gone. These two commands work as a pair: CROSSCHECK updates the catalog status, and LIST EXPIRED filters the output to show only the problem entries.

Why the distractors are wrong:

• A. RESYNC CATALOG - Syncs the catalog with the control file, but does not verify physical file existence on storage.
• C. LIST ARCHIVELOG ALL - Lists all archivelog information recorded in the catalog, including ones that still exist; it does not filter for missing backups.
• E. LIST ARCHIVELOG - Similar to C; shows catalog records without checking physical presence or filtering for missing files.
• F. REPORT OBSOLETE - Identifies backups no longer needed per the retention policy, not backups that are physically missing from storage.

Memory tip: Think of the two-step workflow as "Check, then List" - CROSSCHECK hunts for missing files and stamps them EXPIRED; LIST EXPIRED surfaces only those stamped entries. If you skip CROSSCHECK first, the catalog won't know anything is missing yet.

No community discussion yet for this question.