---

crosscheck

Syntax

Purpose

To determine whether backups stored on disk or tape exist. Backups are either backup sets or media-managed proxy copies.

The crosscheck command checks only backup sets marked available or expired, either by examining the backup pieces on disk when the channel is type disk, or by querying the media manager when the channel is type 'sbt_tape'. It only processes backups created on the specified channel.

RMAN does not delete any backup pieces that it is unable to find, but updates their metadata records to expired status. If some backup pieces were erroneously marked as expired, e.g., because the media manager was misconfigured, then after ensuring that the files really do exist in the media manager, run the crosscheck backup command again to restore those files to available status.

Requirements

• Execute crosscheck backup only at the RMAN prompt.

• Allocate a maintenace channel before issuing crosscheck backup.

• You must use a recovery catalog.

Keywords and Parameters

of listObjList	restricts the list of objects operated on to the object type specified in the listObjList clause. If no objects are specified, the command checks all objects: of database controlfile archivelog all. See "listObjList".
tag tag_name	specifies the tag for the backup set.
completedTimeSpec	specifies a time range for backup completion. See "completedTimeSpec".

Examples

Crosschecking All Backups

The following example queries the status of all backups on disk and includes sample output:

RMAN> allocate channel for maintenance type disk;

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: delete
RMAN-08500: channel delete: sid=15 devtype=DISK

RMAN> crosscheck backup;

RMAN-03022: compiling command: XCHECK
RMAN-03023: executing command: XCHECK
RMAN-08517: backup piece handle=/vobs/oracle/dbs/01a8t4pq_1_1 recid=1 stamp=3448
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/vobs/oracle/dbs/05a9cfs3_1_1 recid=5 stamp=3453
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/vobs/oracle/dbs/06a9cfv8_1_1 recid=6 stamp=3453
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/vobs/oracle/dbs/07a9ck4t_1_1 recid=7 stamp=3453
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/vobs/oracle/dbs/08a9cl23_1_1 recid=8 stamp=3453
RMAN-08074: crosschecked backup piece: found to be 'EXPIRED'
RMAN-08517: backup piece handle=/vobs/oracle/dbs/09a9cl2b_1_1 recid=9 stamp=3453
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'

RMAN> release channel;

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: delete

Crosschecking Within a Range of Dates

The following example queries the media manager for the status of the backup sets for datafile 3 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:

allocate channel for maintenance type 'sbt_tape';
crosscheck backup of datafile 3 device type 'sbt_tape' completed between '01-JAN-98' and 
     '01-JUL-98';
release channel;

Related Topics

"allocateForMaint"

"change"

"list"

"report"

---