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';