Oracle RMAN Pocket Reference

Name

CROSSCHECK

Synopsis

Determines whether a backup set and its related pieces still exist on media. If a backup piece exists in the location recorded in the control file of the target database or in the optional recovery catalog, its status is marked as AVAILABLE. If it is not at the specified location, it is marked as EXPIRED.

Oracle9i syntax

CROSSCHECK
   { { BACKUP | COPY } 
      [OF listObj] [mntQualifer [mntQualifer]...] 
   | recordSpec 
      [DEVICE TYPE deviceSpecifier [, deviceSpecifier]...]
   };

Oracle8i syntax

CROSSCHECK BACKUP 
   [ OF listObj ] 
   [ checkOptions [ checkOptions...]];

checkOptions :=
{ TAG [=] [']tag_name[']
| completedTimeSpec }

Example

In the following example, the existence of all backup sets are verified:

RMAN> allocate channel for maintenance type disk;
RMAN> crosscheck backup;
RMAN> release channel;

In the following example, the backup pieces that contain the SYSTEM tablespace are validated for all backup sets:

RMAN> allocate channel for maintenance type disk;
RMAN> crosscheck backup of tablespace system;
RMAN> release channel;