RMAN Differential and Incremental

[Matsul]

Anbody know what the difference in the two scenarios will be

SCENARIO ONE
-------------

Sunday Level 0 Backup using BACKUP INCREMENTAL LEVEL 0 DATABASE

Monday Level 2 Backup using BACKUP INCREMENTAL LEVEL 2 DATABASE

Tuesday Level 2 again using BACKUP INCREMENTAL LEVEL 2 DATABASE

Wednesday Level 2 using BACKUP INCREMENTAL LEVEL 1 DATABASE



SCENARIO TWO
-------------

Sunday Level 0 Backup using BACKUP INCREMENTAL LEVEL 0 DATABASE

Monday Level 2 Backup using BACKUP INCREMENTAL LEVEL 2 DATABASE

Tuesday Level 2 again using BACKUP INCREMENTAL LEVEL 2 DATABASE

Wednesday Level 2 using BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE

Would the Wedesday backup be the same in both cases ?

 

[jouell]

Not sure off the top of my head, BUT

Why do you care?
What are rying to do?
Save tapes?
Save time?

 

[Matsul]

Hi Jouell,

really only to understand in prep for OCP exam.

thanks

 

[sruff]

These scenarios are exactly the same.

Differential tells RMAN to backup changes since Leveln or lower incremental backup.

Cumulative tells RMAN to backup changes since Leveln-1 or lower incremental backup.

So both Level 1 incrementals would go all the way back to the last level 0. If there was a level 1 accomplished on Monday or Tuesday, the differential would go back to that, but cumulative would still go back to level 0. Make sense?