This content has been marked as final. Show 5 replies
Backups older than the L0 backup that is before and closest to sysdate-7 would be "obsolete". If your L0 backups were, say, 9 days ago and 5 days ago, backups older than the 9 days ago L0 would be obsolete. But the 9 day old L0 and all backups after that would not be obsolete.1 person found this helpful
Hemant K Chitale
Thanks for the reply,
But the problem is archivelog backups. They are not image copy backups. They were backed up using the non-image copy backup command:
backup archivelog all;
In other words, the following command returns couple of rows according to the pointed backups:
RMAN> list backup of archivelog time between 'sysdate - 8' and 'sysdate - 8';
Issuing this command discovered a very strange thing for me. The list that is shown after issuing the command contains backup of archivelogs which their
NEXT_TIME field is set to 2013-01-20 (8 days ago) but their COMPLETION_TIME is set to a day in the recovery window. What do these fields mean? Is it possible to have backups of archivelogs that they started 8 days ago but were completed yesterday? I'm so confused.
1 person found this helpful
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.
ArchiveLog backups have to be retained (not obsoleted) to match up to the L0 backup that needs to be retained. Oracle is trying to allow you the facility of being able to RESTORE and RECOVER to any point in time in the past 7 days. If the L0 backup was 9 days ago, ArchiveLogs from that point (9 days ago) would still need to be retained.1 person found this helpful
Hemant K Chitale
Thanks for the answer.