Name

CROSSCHECK

Synopsis

Oracle9i syntax:

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

Oracle8i syntax:

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

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

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.

Common keywords and clauses: completedTimeSpec, listObjList, mntQualifier, tag_name.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial