Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow - OCP: Oracle Database 12c Administrator Certified Professional - page 255

exeRCiSe 6.2 (continued)
5. Now you need to use the CROSSCHECK command so that RMAN will detect that you
have deleted the backup set piece. Note that the backup set piece you removed is
now marked as expired.
RMAN> crosscheck backup;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=122 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\
2013_10_18\O1_MF_S_668446569_4HNOPMRF_.BKP RECID=29 STAMP=668446579
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\
2013_10_18\O1_MF_ANNNN_TAG20131018T153543_4HNOP6OH_.BKP.OLD RECID=31
STAMP=668449007
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\
2013_10_18\O1_MF_NNNDF_TAG20131018T152908_4HNO9DX9_.BKP.OLD RECID=32
STAMP=668449009
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\
2013_10_18\O1_MF_NNNDF_TAG20131018T163034_4HNRWKVC_.BKP RECID=33
STAMP=668449841
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\
2013_10_18\O1_MF_S_668453268_4HNW82VT_.BKP RECID=34
STAMP=668453282
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\
2013_10_19\O1_MF_S_668533219_4HQBBXCQ_.BKP RECID=35 STAMP=668533245
Crosschecked 6 objects
6. Now issue the LIST EXPIRED BACKUP command to get a report of expired RMAN
backup set pieces:
RMAN> list expired backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1342 Full 187.87M DISK 00:56:47 18-OCT-13