RMAN CROSSCHECK

RMAN CROSSCHECK Command to Cross-Check All Backups and Copies

This example, which assumes that the default configured channel is DEVICE TYPE sbt, cross-checks all backups and disk (partial output is included). Because RMAN preconfigures a disk channel, you do not need to manually allocate a disk channel.

RMAN> CROSSCHECK BACKUP;

allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=84 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=86 device type=DISK
backup piece handle=/disk2/backup/08i9umon_1_1 RECID=7 STAMP=614423319
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/disk2/backup/09i9umso_1_1 RECID=8 STAMP=614423448
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/disk1/cfauto/c-26213402-20130213-00 RECID=9 STAMP=614423452
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0bi9uo81_1_1 RECID=10 STAMP=614424833
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=c-26213402-20130213-01 RECID=11 STAMP=614424851
crosschecked backup piece: found to be 'AVAILABLE'
.
.
.

RMAN CROSSCHECK Command to Cross-Check within a Range of Dates

This example queries the media manager for the status of the backup sets in a given six week range. RMAN uses the date format specified in the NLS_DATE_FORMAT parameter, which is ‘DD-MON-YY‘ in this example. The first command cross-checks backups on tape only:

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
CROSSCHECK BACKUP 
  COMPLETED BETWEEN '01-JAN-13' AND '14-FEB-13';
RELEASE CHANNEL;

The following command specifies DEVICE TYPE DISK to cross-check only disk:

CROSSCHECK BACKUP DEVICE TYPE DISK 
  COMPLETED BETWEEN '01-JAN-13' AND '14-FEB-13';

If the default channel is SBT, then you can cross-check both disk and SBT backups by running CROSSCHECK with the default channels:

CROSSCHECK BACKUP COMPLETED BETWEEN '01-JAN-13' AND '14-FEB-13';

Also See:

Maintaining RMAN Backups

Oracle RMAN