I got some weir configuration going on my production system that's making me confuse.
My 11G database is configured for recovery windows of 9days. But when I run "delete obsolete", I see files that were created three days ago to be deleted as you can see here:
N_TAG20120109T200028_7JQ3GFB7_.BKP
Backup Set 320 10-JAN-12
Backup Piece 320 10-JAN-12
N_TAG20120110T200027_7JSQTD6G_.BKP
Backup Set 321 10-JAN-12
Backup Piece 321 10-JAN-12
N_TAG20120110T200027_7JSQWVR0_.BKP
Backup Set 326 11-JAN-12
> Backup Piece 326 11-JAN-12
On the other hand, when I run "delete expired backup", I see no file:
RMAN> delete expired backup;
using channel ORA_DISK_1
specification does not match any backup in the repository
I have almost three identical databases and only this one has this problem. Any idea?