What is the CROSSCHECK command?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to
ace your certification exam in first attempt.
The CROSSCHECK command is provided by RMAN to perform a crosscheck. A crosscheck is performed to ensure that data about backup sets and image copies in the RMAN repository (recovery catalog or control file) is synchronized with the corresponding data on disk or in the media management catalog. The CROSSCHECK command operates on only those files that are recorded in the RMAN repository.
Backup sets and copies can have the status AVAILABLE, UNAVAILABLE, or EXPIRED. The CROSSCHECK command checks all backup sets and copies that do not have the UNAVAILABLE status. The LIST command can be executed, or recovery catalog views can be queried to determine the status of backup sets and copies. The CROSSCHECK command checks whether or not the backup sets and copies (archived redo logs and image copies) recorded in the RMAN repository still exist on disk or tape. If RMAN does not find a backup set or copy, whose records exist in the RMAN repository, on disk or tape, RMAN updates its repository record to EXPIRED status. The DELETE EXPIRED command can be used to delete the expired records from the repository, thereby synchronizing the RMAN repository with the actual data on disk or tape.
Other articles
