This content has been marked as final. Show 4 replies
1 backups of Sunday 13th , Monday 14th and Tuesday 15th marked as obsolete?
If I understand the information given then the answer is no.
I think of level 1 backups as pieces or additions to level 0 backups. Without the level 0 backup they are worthless.
So they are not obsolete until the level 0 they are based on is.
This may help :
I am reviewing my logs and some of the level 1 backups of Sunday, Monday and Tuesday are marked obsolete while the others are not, till not I am still seeing some level 1 backups in my FRA for day 13.
I am not able to understand the criteria marking level 1 backups as obsolete, can it be something related to the backups of the system table spaces?
and even the backup of the archive logs of 13, 14, and 15 are not marked as obsolete yet. while logically I will not use it in case i want to recover my database, since i am using cumulative level 1 backups.
All the documentation i have read it, do not mention if there is any difference on how recovery window deals with cumulative or differential level 1 backups.
291223 wrote:Hmm. I'd never thought of this, but if I understand the OP correctly, consider:
RMAN holds all level 1 backups that are related to Level 0 backup.
When you make a backup that make the level 0 obsolete are related level 1 backups are then obsolete.
Remember level 1 backups are junk if you don't have a level 0 backup.
Day 1 - level 0
Day 2 - level 1 cumulative - all changes since day 1
Day 3 - level 1 cumulative - all changes since day 1 -- which would include all changes covered in Day 2 backup.
So, at this point, since day 3 includes what day 2 includes, why couldn't day 2 be considered obsolete? If rman needs to recover the changes that were recorded in the Day 2 backup, they are available in the day 2.
No, as I write it, I think it through a bit more and see the issue.
On day 2 rman finds block 'xyz' changed from when it was backed up on Day 1, so backs it up. Fine.
On Day 3 rman will obviously again find that block 'xyz' changed from when it was backed up on Day 1, and so will back it up again. However, block 'xyz' could also have been changed since the Day 2 backup, making the day 3 version of the block the second version since Day 1 - different from the version in the Day 2 backup. If we were to make the Day 2 backup obsolete we would have lost the ability to use Day 2 backup as part of a PIT recovery and would be forced to use archivelogs back to the Day one backup. And that would make all of our Inc 1 cumulative backups pretty much pointless for anything less than a full recovery.