crosscheck backup
AAPFeb 29 2012 — edited Feb 29 2012hi,
Where we can see the files which are expired, it is showing available when I have physically deleted the files from 2012_02_28 folder , it is also showing in EM database control in manage current backup....
RMAN> CROSSCHECK BACKUP;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\AUTOBACKUP\2012_02_28\O1_
MF_S_776427849_7NS3S9M1_.BKP recid=35 stamp=776427849
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\AUTOBACKUP\2012_02_28\O1_
MF_S_776427858_7NS3SLWS_.BKP recid=37 stamp=776427858
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\AUTOBACKUP\2012_02_28\O1_
MF_S_776433205_7NS90OY8_.BKP recid=46 stamp=776433205
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\AUTOBACKUP\2012_02_28\O1_
MF_S_776435770_7NSCJV2G_.BKP recid=55 stamp=776435771
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\AUTOBACKUP\2012_02_28\O1_
MF_S_776454258_7NSXLM4W_.BKP recid=57 stamp=776454259
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\AUTOBACKUP\2012_02_28\O1_
MF_S_776455528_7NSYTB4D_.BKP recid=64 stamp=776455530
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\AUTOBACKUP\2012_02_28\O1_
MF_S_776455550_7NSYTZFO_.BKP recid=66 stamp=776455551
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\AUTOBACKUP\2012_02_28\O1_
MF_S_776466943_7NT9Z08G_.BKP recid=76 stamp=776466944
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\BACKUPSET\2012_02_29\O1_M
F_ANNNN_TAG20120229T070142_7NVD9R2X_.BKP recid=77 stamp=776502104
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\BACKUPSET\2012_02_29\O1_M
F_NNNDF_TAG20120229T070145_7NVD9SVT_.BKP recid=78 stamp=776502105
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\BACKUPSET\2012_02_29\O1_M
F_NNNDF_TAG20120229T070145_7NVDB8J3_.BKP recid=79 stamp=776502120
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\BACKUPSET\2012_02_29\O1_M
F_NNNDF_TAG20120229T070145_7NVDBHJM_.BKP recid=80 stamp=776502127
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\BACKUPSET\2012_02_29\O1_M
F_NNNDF_TAG20120229T070145_7NVDBPL2_.BKP recid=81 stamp=776502134
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\BACKUPSET\2012_02_29\O1_M
F_NNNDF_TAG20120229T070145_7NVDBXL2_.BKP recid=82 stamp=776502141
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\BACKUPSET\2012_02_29\O1_M
F_NNNDF_TAG20120229T070145_7NVDC0NZ_.BKP recid=83 stamp=776502144
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\BACKUPSET\2012_02_29\O1_M
F_ANNNN_TAG20120229T070228_7NVDC56T_.BKP recid=84 stamp=776502149
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\FLASH_RECOVERY_AREA\DEMO\AUTOBACKUP\2012_02_29\O1_
MF_S_776502150_7NVDC6VT_.BKP recid=85 stamp=776502150
Crosschecked 17 objects
RMAN> delete expired backup;
using channel ORA_DISK_1
RMAN>