To be honest I am thoroughly CONFUSED.

I don't know if I am troubling you with all my clouded understandings.

Originally posted by pando
I just made up for that Thursday level 1 backup, I can make it level 0, 2, or 3 or 4 it does not matter.
Do you mean to say that even if yesterday's is Level 2 and Level 2 blocks got changed, I can use any number and NOT necessarliy "3"??

Originally posted by pando

if instead I had a level 2 backup yesterday then I CANNOT backup changed blocks because today´s level 2 is not bigger than yesterday´slevel 2, instead I have to go further backwards until I find a level less than my today´s level

Here, my question is (and was): Since yesterday was Level 2 and that these Level 2 blocks got changed, why didn't you go far Level 3 to backup these changes??? Why make a Level 2 and backup Level 1 changes?
I mean, how will I then backup Yesterday's Level 2 changes, today?

Originally posted by pando


level 0 -- base backup
level 1 -- monthly backup
level 2 -- weekly backup
level 3 -- daily backup
level 4 -- hourly backup
To be honest, never understood the significance of this mapping...I mean why a "hourly" for Level 4 and not any other level?


Another question: As you said, even if it were 5 levels, lets say Level 4 blocks were changed yesterday and today I need to backup these "changed-Level 4 Blocks"; so what would my Level be then today?

Very sorry for all the queries, but honestly I think I will take the Oracle reference manual and go through again from the beginning.