RMAN LEVEL 1 INCR BKP DOESN'T MARK OBSOLETE BACKUPSET
Product: Oracle Std DB 19c 19.19 Windows Server 2022.
Hi community, we hae a dozen of small windows box running ORACLE DB 19c.
We have the following RMAN script running every night.
Problem is that even with recovery windows of 3 days, backup sets older than a week are not marked as obsolete and thus not deleted.
Same RMAN script on all the boxes. Same RMAN problem on all the boxes.
RMAN config is:
CONFIGURE BACKUPOPTIMIZATION OFF; # default
CONFIGURE DEFAULTDEVICE TYPE TO DISK; # default
CONFIGURECONTROLFILE AUTOBACKUP ON;
CONFIGURECONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICETYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default