Skip to content

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