December 2002
Intermediate to advanced
928 pages
85h 29m
English
CROSSCHECK
Oracle9i syntax:
CROSSCHECK
{ { BACKUP | COPY }
[OF listObjList] [mntQualifer [mntQualifer]...]
| recordSpec
[DEVICE TYPE deviceSpecifier [, deviceSpecifier]...]
};Oracle8i syntax:
CROSSCHECK BACKUP [ OFlistObjList] [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.