Have anyone thought, if one of the major backupset (containing datafile) from current backup is physically deleted. And you check for report obsolete, what output do you find? Well, when you go for report obsolete, it shows the previous backup status as obsolete. RMAN never look whether the current datafile backup is physically present or not. Hence the recovery fails, as you don’t have the previous backup and in the current backup, the backuppiece (containing datafile) is missing. Here I will describe the whole process in detail.

Retention policy is set to 1. One backup for the database is already present.

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

Now, I will go for second backup for the same database.

RMAN> backup as compressed backupset database plus archivelog;

Starting backup at 09-JUN-11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=144 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=11 STAMP=753198100
input archived log thread=1 sequence=7 RECID=12 STAMP=753198437
input archived log thread=1 sequence=8 RECID=13 STAMP=753198474
channel ORA_DISK_1: starting piece 1 at 09-JUN-11
channel ORA_DISK_1: finished piece 1 at 09-JUN-11
piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP tag=TAG20110609T153638 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=14 STAMP=753208920
input archived log thread=1 sequence=2 RECID=15 STAMP=753208921
input archived log thread=1 sequence=3 RECID=16 STAMP=753208925
input archived log thread=1 sequence=4 RECID=17 STAMP=753208926
input archived log thread=1 sequence=5 RECID=18 STAMP=753296866
input archived log thread=1 sequence=6 RECID=19 STAMP=753368521
input archived log thread=1 sequence=7 RECID=20 STAMP=753377797
channel ORA_DISK_1: starting piece 1 at 09-JUN-11
channel ORA_DISK_1: finished piece 1 at 09-JUN-11
piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP tag=TAG20110609T153638 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUN-11

Starting backup at 09-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\ORACLE112\ORADATA\ORCL\SYSTEM01.DBF
input datafile file number=00002 name=C:\ORACLE112\ORADATA\ORCL\SYSAUX01.DBF
input datafile file number=00005 name=C:\ORACLE112\ORADATA\ORCL\EXAMPLE01.DBF
input datafile file number=00003 name=C:\ORACLE112\ORADATA\ORCL\UNDOTBS01.DBF
input datafile file number=00004 name=C:\ORACLE112\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 09-JUN-11
channel ORA_DISK_1: finished piece 1 at 09-JUN-11
piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_NNNDF_TAG20110609T153644_6Z16SNR0_.BKP tag=TAG20110609T153644 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 09-JUN-11

Starting backup at 09-JUN-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=8 RECID=21 STAMP=753377880
channel ORA_DISK_1: starting piece 1 at 09-JUN-11
channel ORA_DISK_1: finished piece 1 at 09-JUN-11
piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153800_6Z16W0K4_.BKP tag=TAG20110609T153800 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-JUN-11

Starting Control File and SPFILE Autobackup at 09-JUN-11
piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_09\O1_MF_S_753377881_6Z16W2P0_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-11

As RMAN start backup it switch log at begining and at the end of backup process. In the above backup list we have 4 backup piece,
1. backup pieces 2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP and O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP are for the archive log.
2. O1_MF_NNNDF_TAG20110609T153644_6Z16SNR0_.BKP for the datafile.
3. O1_MF_ANNNN_TAG20110609T153800_6Z16W0K4_.BKP for the archive log last generated at the end of the backup.

RMAN> list backupset;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    279.96M    DISK        00:01:16     07-JUN-11
BP Key: 16   Status: AVAILABLE  Compressed: YES  Tag: TAG20110607T134014
Piece Name: C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP
List of Datafiles in backup set 16
File LV Type Ckp SCN    Ckp Time  Name
---- -- ---- ---------- --------- ----
1       Full 1068802    07-JUN-11 C:\ORACLE112\ORADATA\ORCL\SYSTEM01.DBF
2       Full 1068802    07-JUN-11 C:\ORACLE112\ORADATA\ORCL\SYSAUX01.DBF
3       Full 1068802    07-JUN-11 C:\ORACLE112\ORADATA\ORCL\UNDOTBS01.DBF
4       Full 1068802    07-JUN-11 C:\ORACLE112\ORADATA\ORCL\USERS01.DBF
5       Full 1068802    07-JUN-11 C:\ORACLE112\ORADATA\ORCL\EXAMPLE01.DBF

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
17      9.50K      DISK        00:00:01     07-JUN-11
BP Key: 17   Status: AVAILABLE  Compressed: YES  Tag: TAG20110607T134140
Piece Name: C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP

List of Archived Logs in backup set 17
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
---- ------- ---------- --------- ---------- ---------
1    6       1068795    07-JUN-11 1068840    07-JUN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18      Full    9.36M      DISK        00:00:02     07-JUN-11
BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20110607T134141
Piece Name: C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP
SPFILE Included: Modification time: 07-JUN-11
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1068849      Ckp time: 07-JUN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    9.36M      DISK        00:00:01     07-JUN-11
BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20110607T154809
Piece Name: C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP
SPFILE Included: Modification time: 07-JUN-11
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1069521      Ckp time: 07-JUN-11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
20      153.00K    DISK        00:00:00     09-JUN-11
BP Key: 20   Status: AVAILABLE  Compressed: YES  Tag: TAG20110609T153638
Piece Name: C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP

List of Archived Logs in backup set 20
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
---- ------- ---------- --------- ---------- ---------
1    6       1068795    07-JUN-11 1068840    07-JUN-11
1    7       1068840    07-JUN-11 1069104    07-JUN-11
1    8       1069104    07-JUN-11 1069124    07-JUN-11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
21      7.23M      DISK        00:00:02     09-JUN-11
BP Key: 21   Status: AVAILABLE  Compressed: YES  Tag: TAG20110609T153638
Piece Name: C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP

List of Archived Logs in backup set 21
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
---- ------- ---------- --------- ---------- ---------
1    1       1069281    07-JUN-11 1072675    07-JUN-11
1    2       1072675    07-JUN-11 1072678    07-JUN-11
1    3       1072678    07-JUN-11 1072682    07-JUN-11
1    4       1072682    07-JUN-11 1072685    07-JUN-11
1    5       1072685    07-JUN-11 1094186    08-JUN-11
1    6       1094186    08-JUN-11 1116779    09-JUN-11
1    7       1116779    09-JUN-11 1126147    09-JUN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    280.70M    DISK        00:01:08     09-JUN-11
BP Key: 22   Status: AVAILABLE  Compressed: YES  Tag: TAG20110609T153644
Piece Name: C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_NNNDF_TAG20110609T153644_6Z16SNR0_.BKP
List of Datafiles in backup set 22
File LV Type Ckp SCN    Ckp Time  Name
---- -- ---- ---------- --------- ----
1       Full 1126158    09-JUN-11 C:\ORACLE112\ORADATA\ORCL\SYSTEM01.DBF
2       Full 1126158    09-JUN-11 C:\ORACLE112\ORADATA\ORCL\SYSAUX01.DBF
3       Full 1126158    09-JUN-11 C:\ORACLE112\ORADATA\ORCL\UNDOTBS01.DBF
4       Full 1126158    09-JUN-11 C:\ORACLE112\ORADATA\ORCL\USERS01.DBF
5       Full 1126158    09-JUN-11 C:\ORACLE112\ORADATA\ORCL\EXAMPLE01.DBF

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
23      9.50K      DISK        00:00:00     09-JUN-11
BP Key: 23   Status: AVAILABLE  Compressed: YES  Tag: TAG20110609T153800
Piece Name: C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153800_6Z16W0K4_.BKP

List of Archived Logs in backup set 23
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
---- ------- ---------- --------- ---------- ---------
1    8       1126147    09-JUN-11 1126193    09-JUN-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
24      Full    9.36M      DISK        00:00:02     09-JUN-11
BP Key: 24   Status: AVAILABLE  Compressed: NO  Tag: TAG20110609T153801
Piece Name: C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_09\O1_MF_S_753377881_6Z16W2P0_.BKP
SPFILE Included: Modification time: 09-JUN-11
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1126202      Ckp time: 09-JUN-11

In the above backup list, there are 4 backupset (21,22,23,24) which are from the recent backup.

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           16     07-JUN-11
Backup Piece       16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP
Archive Log          11     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_6_6YVQ9W0V_.ARC
Backup Set           17     07-JUN-11
Backup Piece       17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP
Archive Log          12     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_7_6YVQNF5M_.ARC
Backup Set           18     07-JUN-11
Backup Piece       18     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP
Archive Log          13     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_8_6YVQOL9T_.ARC
Archive Log          14     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_1_6YW1W008_.ARC
Backup Set           19     07-JUN-11
Backup Piece       19     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP
Archive Log          15     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_2_6YW1W1N6_.ARC
Archive Log          16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_3_6YW1W57Z_.ARC
Archive Log          17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_4_6YW1W680_.ARC
Archive Log          18     08-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_08\O1_MF_1_5_6YYQR9LR_.ARC
Archive Log          19     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_6_6Z0XQJK3_.ARC
Archive Log          20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_7_6Z16SDJQ_.ARC
Backup Set           20     09-JUN-11
Backup Piece       20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP
Backup Set           21     09-JUN-11
Backup Piece       21     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP

The output shows the previous backupset plus the obsolete archivelogs with 2 backup set (20, 21), from the current backup, which as per RMAN is not required for recovery. And thats true if you check with the backup list.
Now I will physically delete one of the backup piece (21) with contains archivelog. With crosscheck, I see its status as expired.

RMAN> crosscheck backupset;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP RECID=16 STAMP=753198014
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP RECID=17 STAMP=753198100
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP RECID=18 STAMP=753198102
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP RECID=19 STAMP=753205690
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP RECID=20 STAMP=753377799
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP RECID=21 STAMP=753377800
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_NNNDF_TAG20110609T153644_6Z16SNR0_.BKP RECID=22 STAMP=753377804
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153800_6Z16W0K4_.BKP RECID=23 STAMP=753377880
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_09\O1_MF_S_753377881_6Z16W2P0_.BKP RECID=24 STAMP=753377882
Crosschecked 9 objects
RMAN> validate backupset 21;

Starting validate at 09-JUN-11
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of validate command at 06/09/2011 16:01:53
RMAN-06160: no backup pieces found for backup set key: 21

Backup piece not found.

RMAN> validate backupset 24;

Starting validate at 09-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_09\O1_MF_S_753377881_6Z16W2P0_.BKP
channel ORA_DISK_1: piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_09\O1_MF_S_753377881_6Z16W2P0_.BKP tag=TAG20110609T153801
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
Finished validate at 09-JUN-11

I delete one more backupset (22) which contains archivelog. Now again check.

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           16     07-JUN-11
Backup Piece       16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP
Archive Log          11     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_6_6YVQ9W0V_.ARC
Backup Set           17     07-JUN-11
Backup Piece       17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP
Archive Log          12     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_7_6YVQNF5M_.ARC
Backup Set           18     07-JUN-11
Backup Piece       18     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP
Archive Log          13     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_8_6YVQOL9T_.ARC
Archive Log          14     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_1_6YW1W008_.ARC
Backup Set           19     07-JUN-11
Backup Piece       19     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP
Archive Log          15     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_2_6YW1W1N6_.ARC
Archive Log          16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_3_6YW1W57Z_.ARC
Archive Log          17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_4_6YW1W680_.ARC
Archive Log          18     08-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_08\O1_MF_1_5_6YYQR9LR_.ARC
Archive Log          19     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_6_6Z0XQJK3_.ARC
Archive Log          20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_7_6Z16SDJQ_.ARC
Backup Set           20     09-JUN-11
Backup Piece       20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP
Backup Set           21     09-JUN-11
Backup Piece       21     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP
RMAN> crosscheck backupset;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP RECID=16 STAMP=753198014
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP RECID=17 STAMP=753198100
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP RECID=18 STAMP=753198102
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP RECID=19 STAMP=753205690
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP RECID=20 STAMP=753377799
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP RECID=21 STAMP=753377800
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_NNNDF_TAG20110609T153644_6Z16SNR0_.BKP RECID=22 STAMP=753377804
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153800_6Z16W0K4_.BKP RECID=23 STAMP=753377880
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_09\O1_MF_S_753377881_6Z16W2P0_.BKP RECID=24 STAMP=753377882
Crosschecked 9 objects

When I crosscheck I do find both piece are expired. But with report obsolete, there is no difference found in the list.

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           16     07-JUN-11
Backup Piece       16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP
Archive Log          11     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_6_6YVQ9W0V_.ARC
Backup Set           17     07-JUN-11
Backup Piece       17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP
Archive Log          12     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_7_6YVQNF5M_.ARC
Backup Set           18     07-JUN-11
Backup Piece       18     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP
Archive Log          13     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_8_6YVQOL9T_.ARC
Archive Log          14     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_1_6YW1W008_.ARC
Backup Set           19     07-JUN-11
Backup Piece       19     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP
Archive Log          15     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_2_6YW1W1N6_.ARC
Archive Log          16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_3_6YW1W57Z_.ARC
Archive Log          17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_4_6YW1W680_.ARC
Archive Log          18     08-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_08\O1_MF_1_5_6YYQR9LR_.ARC
Archive Log          19     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_6_6Z0XQJK3_.ARC
Archive Log          20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_7_6Z16SDJQ_.ARC
Backup Set           20     09-JUN-11
Backup Piece       20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP
Backup Set           21     09-JUN-11
Backup Piece       21     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP

Now I will go for deleting a backup piece (23) which contains all the datafile from the current backup. Lets check with report obsolete.

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           16     07-JUN-11
Backup Piece       16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP
Archive Log          11     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_6_6YVQ9W0V_.ARC
Backup Set           17     07-JUN-11
Backup Piece       17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP
Archive Log          12     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_7_6YVQNF5M_.ARC
Backup Set           18     07-JUN-11
Backup Piece       18     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP
Archive Log          13     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_8_6YVQOL9T_.ARC
Archive Log          14     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_1_6YW1W008_.ARC
Backup Set           19     07-JUN-11
Backup Piece       19     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP
Archive Log          15     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_2_6YW1W1N6_.ARC
Archive Log          16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_3_6YW1W57Z_.ARC
Archive Log          17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_4_6YW1W680_.ARC
Archive Log          18     08-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_08\O1_MF_1_5_6YYQR9LR_.ARC
Archive Log          19     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_6_6Z0XQJK3_.ARC
Archive Log          20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_7_6Z16SDJQ_.ARC
Backup Set           20     09-JUN-11
Backup Piece       20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP
Backup Set           21     09-JUN-11
Backup Piece       21     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP

There is no change found in the obsolete list. How is it possible? RMAN shows the previous backupset as obsolete which should not be the case. As I dont have the recent backup.
Lets crosscheck.

RMAN> crosscheck backupset;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP RECID=16 STAMP=753198014
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP RECID=17 STAMP=753198100
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP RECID=18 STAMP=753198102
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP RECID=19 STAMP=753205690
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP RECID=20 STAMP=753377799
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP RECID=21 STAMP=753377800
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_NNNDF_TAG20110609T153644_6Z16SNR0_.BKP RECID=22 STAMP=753377804
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153800_6Z16W0K4_.BKP RECID=23 STAMP=753377880
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_09\O1_MF_S_753377881_6Z16W2P0_.BKP RECID=24 STAMP=753377882
Crosschecked 9 objects
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           18     07-JUN-11
Backup Piece       18     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP
Backup Set           19     07-JUN-11
Backup Piece       19     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP

Thats it. RMAN do sense, is the consistant backup available or not. It has only gone for obsolete control file backup and not for the rest(archive and datafile backupset). Now I will restore backuppiece 23 from windows recyclebin. Do remember I still dont have backuppiece 21, 22 as it is not required, which are from the current backup.
Lets crosscheck.

RMAN> crosscheck backupset;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP RECID=16 STAMP=753198014
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP RECID=17 STAMP=753198100
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP RECID=18 STAMP=753198102
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP RECID=19 STAMP=753205690
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP RECID=20 STAMP=753377799
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP RECID=21 STAMP=753377800
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_NNNDF_TAG20110609T153644_6Z16SNR0_.BKP RECID=22 STAMP=753377804
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153800_6Z16W0K4_.BKP RECID=23 STAMP=753377880
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_09\O1_MF_S_753377881_6Z16W2P0_.BKP RECID=24 STAMP=753377882
Crosschecked 9 objects
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           16     07-JUN-11
Backup Piece       16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP
Archive Log          11     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_6_6YVQ9W0V_.ARC
Backup Set           17     07-JUN-11
Backup Piece       17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP
Archive Log          12     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_7_6YVQNF5M_.ARC
Backup Set           18     07-JUN-11
Backup Piece       18     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP
Archive Log          13     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_8_6YVQOL9T_.ARC
Archive Log          14     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_1_6YW1W008_.ARC
Backup Set           19     07-JUN-11
Backup Piece       19     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP
Archive Log          15     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_2_6YW1W1N6_.ARC
Archive Log          16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_3_6YW1W57Z_.ARC
Archive Log          17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_4_6YW1W680_.ARC
Archive Log          18     08-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_08\O1_MF_1_5_6YYQR9LR_.ARC
Archive Log          19     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_6_6Z0XQJK3_.ARC
Archive Log          20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_7_6Z16SDJQ_.ARC
Backup Set           20     09-JUN-11
Backup Piece       20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP
Backup Set           21     09-JUN-11
Backup Piece       21     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP

I find the perfect backupset. Deleting the obsolete backup

RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           16     07-JUN-11
Backup Piece       16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP
Archive Log          11     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_6_6YVQ9W0V_.ARC
Backup Set           17     07-JUN-11
Backup Piece       17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP
Archive Log          12     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_7_6YVQNF5M_.ARC
Backup Set           18     07-JUN-11
Backup Piece       18     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP
Archive Log          13     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_8_6YVQOL9T_.ARC
Archive Log          14     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_1_6YW1W008_.ARC
Backup Set           19     07-JUN-11
Backup Piece       19     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP
Archive Log          15     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_2_6YW1W1N6_.ARC
Archive Log          16     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_3_6YW1W57Z_.ARC
Archive Log          17     07-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_4_6YW1W680_.ARC
Archive Log          18     08-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_08\O1_MF_1_5_6YYQR9LR_.ARC
Archive Log          19     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_6_6Z0XQJK3_.ARC
Archive Log          20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_7_6Z16SDJQ_.ARC
Backup Set           20     09-JUN-11
Backup Piece       20     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP
Backup Set           21     09-JUN-11
Backup Piece       21     09-JUN-11          C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP

Do you really want to delete the above objects (enter YES or NO)? y
deleted backup piece
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_NNNDF_TAG20110607T134014_6YVQ76VM_.BKP RECID=16 STAMP=753198014
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_6_6YVQ9W0V_.ARC RECID=11 STAMP=753198100
deleted backup piece
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_07\O1_MF_ANNNN_TAG20110607T134140_6YVQ9WN6_.BKP RECID=17 STAMP=753198100
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_7_6YVQNF5M_.ARC RECID=12 STAMP=753198437
deleted backup piece
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753198101_6YVQ9YM4_.BKP RECID=18 STAMP=753198102
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_8_6YVQOL9T_.ARC RECID=13 STAMP=753198474
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_1_6YW1W008_.ARC RECID=14 STAMP=753208920
deleted backup piece
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_06_07\O1_MF_S_753205689_6YVYQ27Y_.BKP RECID=19 STAMP=753205690
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_2_6YW1W1N6_.ARC RECID=15 STAMP=753208921
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_3_6YW1W57Z_.ARC RECID=16 STAMP=753208925
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_07\O1_MF_1_4_6YW1W680_.ARC RECID=17 STAMP=753208926
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_08\O1_MF_1_5_6YYQR9LR_.ARC RECID=18 STAMP=753296866
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_6_6Z0XQJK3_.ARC RECID=19 STAMP=753368521
deleted archived log
archived log file name=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_06_09\O1_MF_1_7_6Z16SDJQ_.ARC RECID=20 STAMP=753377797
deleted backup piece
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SHF6_.BKP RECID=20 STAMP=753377799
deleted backup piece
backup piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_ANNNN_TAG20110609T153638_6Z16SJRO_.BKP RECID=21 STAMP=753377800
Deleted 16 objects

RMAN> exit
Recovery Manager complete.

Lets check can I recover the database.

C:\Users\Rao>rman target \

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 9 16:07:31 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

target database Password:
connected to target database: ORCL (DBID=1280734387, not open)

RMAN> run
2> {
3> restore database;
4> recover database;
5> }

Starting restore at 09-JUN-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to C:\ORACLE112\ORADATA\ORCL\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00002 to C:\ORACLE112\ORADATA\ORCL\SYSAUX01.DBF
channel ORA_DISK_1: restoring datafile 00003 to C:\ORACLE112\ORADATA\ORCL\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00004 to C:\ORACLE112\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: restoring datafile 00005 to C:\ORACLE112\ORADATA\ORCL\EXAMPLE01.DBF
channel ORA_DISK_1: reading from backup piece C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_NNNDF_TAG20110609T153644_6Z16SNR0_.BKP
channel ORA_DISK_1: piece handle=C:\ORACLE112\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_06_09\O1_MF_NNNDF_TAG20110609T153644_6Z16SNR0_.BKP tag=TAG20110609T153644
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 09-JUN-11

Starting recover at 09-JUN-11
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:02

Finished recover at 09-JUN-11

RMAN>

Well thats it. RMAN do sense for expired backupset. Crosscheck your backupset and you dont have to worry. RMAN will look into it that you have the consistent backup.

Advertisements