Hi, I'm running a delete obsolete using recovery windows of 30 days today (Nov 16th). Rman has deleted backup pieces going back to the 18th to 4th of November which are a lot younger then 30 days! Can anyone explain this please?
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Nov 16 11:50:39 2016
RMAN> delete obsolete recovery window of 30 days;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 device type=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 3 18-OCT-16
Backup Piece 3 18-OCT-16 /mnt/u01/ebstest-backup/db0_EBSTEST_08rilucj_1_1
Backup Set 5 18-OCT-16
Backup Piece 5 18-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_0arim06q_1_1
Backup Set 16 18-OCT-16
Backup Piece 16 18-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_0lrim7c7_1_1
Backup Set 18 18-OCT-16
Backup Piece 18 18-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_0nrim8a6_1_1
Backup Set 20 18-OCT-16
Backup Piece 20 18-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_0prim92f_1_1
Backup Set 22 18-OCT-16
Backup Piece 22 18-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_0rrim9dl_1_1
Backup Set 24 18-OCT-16
Backup Piece 24 18-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_0trima6c_1_1
Backup Set 26 19-OCT-16
Backup Piece 26 19-OCT-16 /mnt/u01/ebstest-backup/db0_EBSTEST_0vring36_1_1
Backup Set 28 19-OCT-16
Backup Piece 28 19-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_11rinhvu_1_1
Backup Set 30 19-OCT-16
Backup Piece 30 19-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_13rinjjm_1_1
Backup Set 32 19-OCT-16
Backup Piece 32 19-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_15rinkih_1_1
Backup Set 34 20-OCT-16
Backup Piece 34 20-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_17riq7vo_1_1
Backup Set 36 20-OCT-16
Backup Piece 36 20-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_19riq98f_1_1
Backup Set 38 21-OCT-16
Backup Piece 38 21-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_1brissbn_1_1
Backup Set 40 21-OCT-16
Backup Piece 40 21-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_1dristjg_1_1
Backup Set 42 25-OCT-16
Backup Piece 42 25-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_1grj7drm_1_1
Backup Set 44 25-OCT-16
Backup Piece 44 25-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_1irj7eds_1_1
Backup Set 46 26-OCT-16
Backup Piece 46 26-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_1krja27m_1_1
Backup Set 48 26-OCT-16
Backup Piece 48 26-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_1mrja2oj_1_1
Backup Set 50 27-OCT-16
Backup Piece 50 27-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_1orjcmjn_1_1
Backup Set 52 27-OCT-16
Backup Piece 52 27-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_1qrjcn90_1_1
Backup Set 54 28-OCT-16
Backup Piece 54 28-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_1srjfavm_1_1
Backup Set 56 28-OCT-16
Backup Piece 56 28-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_1urjfbgk_1_1
Backup Set 58 29-OCT-16
Backup Piece 58 29-OCT-16 /mnt/u01/ebstest-backup/db0_EBSTEST_20rjhvbm_1_1
Backup Set 60 29-OCT-16
Backup Piece 60 29-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_22rji0ir_1_1
Backup Set 62 30-OCT-16
Backup Piece 62 30-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_24rjkjnn_1_1
Backup Set 64 30-OCT-16
Backup Piece 64 30-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_26rjkkhn_1_1
Backup Set 66 31-OCT-16
Backup Piece 66 31-OCT-16 /mnt/u01/ebstest-backup/db1_EBSTEST_28rjn83m_1_1
Backup Set 68 31-OCT-16
Backup Piece 68 31-OCT-16 /mnt/u01/ebstest-backup/cf_EBSTEST_2arjn8r6_1_1
Backup Set 70 01-NOV-16
Backup Piece 70 01-NOV-16 /mnt/u01/ebstest-backup/db1_EBSTEST_2crjpsfm_1_1
Backup Set 72 01-NOV-16
Backup Piece 72 01-NOV-16 /mnt/u01/ebstest-backup/cf_EBSTEST_2erjpt7f_1_1
Backup Set 74 02-NOV-16
Backup Piece 74 02-NOV-16 /mnt/u01/ebstest-backup/db1_EBSTEST_2grjsgrn_1_1
Backup Set 76 02-NOV-16
Backup Piece 76 02-NOV-16 /mnt/u01/ebstest-backup/cf_EBSTEST_2irjshhk_1_1
Backup Set 78 03-NOV-16
Backup Piece 78 03-NOV-16 /mnt/u01/ebstest-backup/db1_EBSTEST_2krjv57m_1_1
Backup Set 80 03-NOV-16
Backup Piece 80 03-NOV-16 /mnt/u01/ebstest-backup/cf_EBSTEST_2mrjv5sm_1_1
Backup Set 87 04-NOV-16
Backup Piece 87 04-NOV-16 /mnt/u01/ebstest-backup/db1_EBSTEST_2urk1pjm_1_1
Backup Set 89 04-NOV-16
Backup Piece 89 04-NOV-16 /mnt/u01/ebstest-backup/cf_EBSTEST_30rk1qas_1_1
The File Systems show this:
Delete obsolete has left archivelog backups but removed full and incremental backups up to November 5th!
-rw-r----- 1 oracle oinstall 2272513024 Oct 18 13:57 arch_EBSTEST_0crim1sg_1_1
-rw-r----- 1 oracle oinstall 2317407232 Oct 18 14:01 arch_EBSTEST_0drim237_1_1
-rw-r----- 1 oracle oinstall 1059085312 Oct 18 14:03 arch_EBSTEST_0erim2a8_1_1
-rw-r----- 1 oracle oinstall 1686337024 Oct 18 14:06 arch_EBSTEST_0frim2e5_1_1
-rw-r----- 1 oracle oinstall 1268318720 Oct 18 14:09 arch_EBSTEST_0grim2ju_1_1
-rw-r----- 1 oracle oinstall 19063296 Oct 18 14:09 arch_EBSTEST_0hrim2o6_1_1
-rw-r----- 1 oracle oinstall 2071040 Oct 18 15:27 arch_EBSTEST_0jrim7b1_1_1
-rw-r----- 1 oracle oinstall 998400 Oct 18 15:57 arch_EBSTEST_0orim92e_1_1
-rw-r----- 1 oracle oinstall 90060288 Oct 18 16:16 arch_EBSTEST_0srima5t_1_1
-rw-r----- 1 oracle oinstall 1017141248 Oct 19 03:33 arch_EBSTEST_10rinhod_1_1
-rw-r----- 1 oracle oinstall 1370112 Oct 19 04:19 arch_EBSTEST_14rinkig_1_1
-rw-r----- 1 oracle oinstall 214147072 Oct 20 04:24 arch_EBSTEST_18riq97l_1_1
-rw-r----- 1 oracle oinstall 213104640 Oct 21 04:24 arch_EBSTEST_1cristim_1_1
-rw-r----- 1 oracle oinstall 565265408 Oct 25 04:12 arch_EBSTEST_1hrj7ec5_1_1
-rw-r----- 1 oracle oinstall 211927552 Oct 26 04:11 arch_EBSTEST_1lrja2nq_1_1
-rw-r----- 1 oracle oinstall 1200697856 Oct 27 04:14 arch_EBSTEST_1prjcn5d_1_1
-rw-r----- 1 oracle oinstall 211860480 Oct 28 04:11 arch_EBSTEST_1trjfbfq_1_1
-rw-r----- 1 oracle oinstall 212190208 Oct 29 04:23 arch_EBSTEST_21rji0i1_1_1
-rw-r----- 1 oracle oinstall 33369088 Oct 30 04:16 arch_EBSTEST_25rjkkhj_1_1
-rw-r----- 1 oracle oinstall 124309504 Oct 31 04:15 arch_EBSTEST_29rjn8qm_1_1
-rw-r----- 1 oracle oinstall 208559616 Nov 1 04:15 arch_EBSTEST_2drjpt6m_1_1
-rw-r----- 1 oracle oinstall 207347712 Nov 2 04:14 arch_EBSTEST_2hrjshgr_1_1
-rw-r----- 1 oracle oinstall 214431232 Nov 3 04:14 arch_EBSTEST_2lrjv5rs_1_1
-rw-r----- 1 oracle oinstall 14548992 Nov 3 16:48 c-1045700069-20161103-03
-rw-r----- 1 oracle oinstall 210447872 Nov 4 04:15 arch_EBSTEST_2vrk1qa2_1_1
-rw-r----- 1 oracle oinstall 14548992 Nov 4 04:15 c-1045700069-20161104-00
-rw-r----- 1 oracle oinstall 9522765824 Nov 5 04:21 db0_EBSTEST_32rk4dvm_1_1
-rw-r----- 1 oracle oinstall 201637888 Nov 5 04:22 arch_EBSTEST_33rk4f36_1_1
-rw-r----- 1 oracle oinstall 14516224 Nov 5 04:22 cf_EBSTEST_34rk4f40_1_1