RMAN delete obsolete

Posted by Roshan on Nov 11, 2021; 2:14am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-delete-obsolete-tp10415.html

Oracle DB 12.1.0.2
Solaris

Hello Erman,

can you please advise why delete obsolete does now work?

$ORACLE_HOME/bin/rman target / <<EOF >> /scripts/logdelobsolete.log
#CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT='/backup2/dwaredr/dwareARC_%U';
ALLOCATE CHANNEL FOR MAINTENANCE TYPE DISK;
delete noprompt obsolete device type disk;
exit;
EOF

I see full backups still on disk for October. Window size is 7 days.

total 15910802656
-rw-r-----   1 ora12c   nobody   705439232 Oct 11 00:05 dwareFULL_g00bac55_1_1
-rw-r-----   1 ora12c   nobody   100888705024 Oct 11 00:06 dwareFULL_ft0ba7lg_1_1
-rw-r-----   1 ora12c   nobody   321475264512 Oct 17 20:18 dwareFULL_iu0bs8u6_1_1
-rw-r-----   1 ora12c   nobody   374881878016 Oct 17 20:30 dwareFULL_it0bs8u5_1_1
-rw-r-----   1 ora12c   nobody   357041684480 Oct 17 20:40 dwareFULL_is0bs8u5_1_1
-rw-r-----   1 ora12c   nobody   362161225728 Oct 17 20:47 dwareFULL_ir0bs8u3_1_1
-rw-r-----   1 ora12c   nobody   461285097472 Oct 17 22:22 dwareFULL_iv0bsdhl_1_1
-rw-r-----   1 ora12c   nobody   423047561216 Oct 17 22:42 dwareFULL_j10bsepq_1_1
-rw-r-----   1 ora12c   nobody   340355809280 Oct 24 20:30 dwareFULL_vc0ceni9_1_1
-rw-r-----   1 ora12c   nobody   425351364608 Oct 24 20:38 dwareFULL_vd0cenia_1_1
-rw-r-----   1 ora12c   nobody   432131850240 Oct 24 20:48 dwareFULL_vb0ceni7_1_1
-rw-r-----   1 ora12c   nobody   404707688448 Oct 24 20:53 dwareFULL_va0ceni6_1_1
-rw-r-----   1 ora12c   nobody   396234686464 Oct 24 22:09 dwareFULL_vf0cetag_1_1
-rw-r-----   1 ora12c   nobody   397793427456 Oct 24 22:11 dwareFULL_ve0cess4_1_1
-rw-r-----   1 ora12c   nobody   318682955776 Oct 24 22:13 dwareFULL_vg0cettf_1_1
-rw-r-----   1 ora12c   nobody   371382386688 Oct 24 22:29 dwareFULL_vh0ceu5r_1_1
-rw-r-----   1 ora12c   nobody   25393254912 Oct 24 22:51 dwareFULL_vl0cf3qr_1_1
-rw-r-----   1 ora12c   nobody   29089207296 Oct 24 22:51 dwareFULL_vk0cf3qq_1_1
-rw-r-----   1 ora12c   nobody   383203704832 Oct 31 20:31 dwareFULL_c90d1662_1_1
-rw-r-----   1 ora12c   nobody   406526623744 Oct 31 20:48 dwareFULL_c70d1660_1_1
-rw-r-----   1 ora12c   nobody   363666718720 Oct 31 21:59 dwareFULL_cb0d1bgm_1_1
-rw-r-----   1 ora12c   nobody   357607374848 Oct 31 22:15 dwareFULL_cc0d1ch3_1_1
-rw-r-----   1 ora12c   nobody   299100667904 Oct 31 23:29 dwareFULL_ce0d1hk7_1_1
-rw-r-----   1 ora12c   nobody   430489370624 Oct 31 23:42 dwareFULL_cd0d1gmk_1_1

Regards,

Roshan