f9smsk wrote:All backup and recovery must begin with a L0 backup. And all backups of all types that are necessary to enforce the recovery policy must be retained. That means the newest (most recent) L0 backup can never be obsolete, no matter how old it is. And all L1, archivelog, controlfile and spfille backups taken since the most recent L0 backup also must be retained, no matter how old they are.
(OS=OL 5.5, DB = 11.2 g)
I have a problem with "delete obsolete" command of RMAN which does not delete the obsolete backup of archive logs, but before that please take a look at the configuration and scenario:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
Daily Image Copy Backup of database;
daily backup of archivelog all;
daily call of "delete noprompt obsolete".
As I think about, according to described config and actions, all backup of archive logs completed before 7 days must be deleted every day. But I can seen they do are and were not deleted.
calling "delete obsolete" manually does not change the situation as well:
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=954 device type=DISK
no obsolete backups found
Also there will be shown backups completed before a week ago after issuing the "*RMAN> list backup completed before 'sysdate - 7';*" command.
Can anyone help me, plz.