1Z0-062 · Question #298
Identify three uses of the CROSSCHECK command (Choose three.)
The correct answer is B. to synchronize logical backup records with physical files in backup storage D. to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or E. to update the recovery catalog or control file if archived log files are deleted with operating system. The RMAN CROSSCHECK command is used to synchronize the RMAN repository with the physical status of backup files and archived logs on disk or tape.
Question
Identify three uses of the CROSSCHECK command (Choose three.)
Options
- Ato validate the database backup
- Bto synchronize logical backup records with physical files in backup storage
- Cto check the obsolete backups that can be deleted from the file system
- Dto update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or
- Eto update the recovery catalog or control file if archived log files are deleted with operating system
How the community answered
(46 responses)- A7% (3)
- B89% (41)
- C4% (2)
Why each option
The RMAN CROSSCHECK command is used to synchronize the RMAN repository with the physical status of backup files and archived logs on disk or tape.
The RMAN VALIDATE command is used to check the integrity of database backups to ensure they are recoverable, not the CROSSCHECK command.
CROSSCHECK examines the RMAN repository (control file or recovery catalog) records against the actual physical files on disk or tape, marking any backup pieces or copies that no longer exist as EXPIRED to synchronize the logical records with physical reality.
The RMAN REPORT OBSOLETE or DELETE OBSOLETE commands are used to identify and remove backups that are no longer needed based on the retention policy, not the CROSSCHECK command.
If backup pieces or copies become unavailable due to deletion, corruption, or media issues outside of RMAN, CROSSCHECK updates their status in the recovery catalog or control file to EXPIRED, reflecting their inaccessibility.
When archived log files are deleted directly from the operating system, bypassing RMAN's management, the CROSSCHECK command detects their absence and updates the RMAN repository to accurately reflect that these logs are no longer available for recovery operations.
Concept tested: Oracle RMAN CROSSCHECK command functionality
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/crosscheck.html#GUID-E26AEF2E-3121-4A2D-BE48-7359F7C25E3E
Topics
Community Discussion
No community discussion yet for this question.