|Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)
Part Number B10770-02
To verify the status of backups and copies recorded in the RMAN repository against media such as disk or tape. The
CROSSCHECK command only processes files created on the same device type as the channels running the crosscheck.
CROSSCHECK command checks only objects marked
EXPIRED by examining the files on disk for
DISK channels or by querying the media manager for
sbt channels. Table 2-2 describes the meaning of each status.
Object is available for use by RMAN. For a backup set to be
Object is not available for use by RMAN. For a backup set to be
CROSSCHECK command does not delete any files that it is unable to find, but updates their repository records to
EXPIRED. Then, you can run
EXPIRED to remove the repository records for all expired files as well as any existing physical files whose records show the status
If some backup pieces or copies were erroneously marked as
EXPIRED, for example, because the media manager was misconfigured, then after ensuring that the files really do exist in the media manager, run the
BACKUP command again to restore those files to
Oracle Database Backup and Recovery Basics to learn how to manage target database records in the catalog
CROSSCHECKis used with a file that is on disk. However, if you run
CROSSCHECKon files stored on a media manager, and you have not configured automatic channels for the media manager, then you must manually allocate maintenance channels for these objects. For example, if you created a backup on an
sbtchannel, but have not configured automatic channels for your
sbtdevice, then you must manually allocate an
sbtchannel before the
CROSSCHECKcommand can check the backup.
Crosschecks files output by the
The following example, which assumes that the default configured channel is
sbt, queries the status of all backups and copies on tape and disk. Because RMAN preconfigures a disk channel, you do not need to manually allocate a disk channel:
The following example queries the media manager for the status of the backup sets in a given six month range. Note that RMAN uses the date format specified in the
NLS_DATE_FORMAT parameter, which is '
DD-MON-YY' in this example:
# if you manually allocate an sbt channel, then RMAN does not crosscheck disk ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt; CROSSCHECK BACKUP COMPLETED BETWEEN '01-JAN-01' AND '01-SEP-01'; RELEASE CHANNEL; # to crosscheck only disk, specify CROSSCHECK DEVICE TYPE DISK CROSSCHECK BACKUP DEVICE TYPE DISK COMPLETED BETWEEN '01-JAN-01' AND '01-SEP-01'; # assuming that the default channel is sbt, you can crosscheck on both disk # and sbt backups by simply running CROSSCHECK with the default channels CROSSCHECK BACKUP COMPLETED BETWEEN '01-JAN-01' AND '01-SEP-01';