Crosscheck Clause
Check whether backup pieces, proxy copies, or disk copies
still exist in comparison to the control file's repository.
Syntax:
CROSSCHECK { { BACKUP [OF listObjList] | COPY [OF listObjList] | archivelogRecordSpecifier } [maintQualifier [maintQualifier]…] | recordSpec [DEVICE TYPE deviceSpecifier [, deviceSpecifier]…] }; listObjList::= [ DATAFILE datafileSpec [, datafileSpec]… | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]… | archivelogRecordSpecifier | DATABASE [SKIP TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]…] | CONTROLFILE | SPFILE ]…
Use RMAN Crosscheck to check that files are in place ready for a restore.
To validate a restore has worked, use the RMAN restore validate command.
Examples:
Assuming you have configured automatic channels:
RMAN> CROSSCHECK BACKUP;
RMAN> CROSSCHECK COPY;
RMAN> CROSSCHECK backup of database;
RMAN> CROSSCHECK backup of controlfile;
RMAN> CROSSCHECK archivelog all;
Query the media manager for the status of backup sets in a given date range:
RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
RMAN> CROSSCHECK BACKUP DEVICE TYPE sbt COMPLETED BETWEEN '01-AUG-04' AND
'31-DEC-04';
"Wealth heaped on wealth, nor truth nor safety buys,
The dangers gather as the treasures rise" - Samuel Johnson: The Vanity Of Human Wishes
Related Oracle Commands:
RMAN Restore Validate
RMAN CHANGE - Update the status of a backup in the RMAN repository.
RMAN CONFIGURE - Persistent RMAN settings.
RMAN DELETE - Delete backups from disk or tape
RMAN LIST - List backups and copies
RMAN REPORT - Report backup status: database, files, backups
NLS_DATE_FORMAT parameter
Related Views:
RC_BACKUP_FILES V$BACKUP_FILES RMAN backups and copies in the repository. RC_BACKUP_PIECE V$BACKUP_PIECE Backup pieces