I want to use RMAN to do weekly incremental backup. I did Sunday level 0, Monday level1, Tuesday level 2,.....Saturday level 6. All differential incremental backup. Is this right? How to use cumulative incremental backup for weekly backup?
Printable View
I want to use RMAN to do weekly incremental backup. I did Sunday level 0, Monday level1, Tuesday level 2,.....Saturday level 6. All differential incremental backup. Is this right? How to use cumulative incremental backup for weekly backup?
Are you trying to do block level incrementals? Need more information on what you are trying to do....
The question is about incremental level. should I use level 1 to 6 for monday to saturday. or use level 1 for all the weekend and level 0 for sunday. I think it's table level backup by using RMAN. i didn't use veritas.
It depends on how fast you want to recover.
Level 0 backups are equivelent to full backups. Definitely take a full backup each Sunday.
Level 1 backups are an incremental backup. Level 1 backups backup any blocks changed since the Level 0 backup.
Level 2 backups are also incremental backups. Level 1 backups backup any blocks that have changed since the LEVEL 1.
Level n backups backup any blocks changed since the n-1 backup.
If you specify a level 0 on Sunday and 1-6 on Mon-Sat, you will end up going through 7 tapes if you have to do a recovery on Saturday. Although you might use more tape, I would do a level 0 on Sunday and a level 1 Mon-Sat.
If I do level 0 on sunday, level 1 on monday, and level 1 on tuesday, what tuesday's level 1 copy? everything changed since sunday level 0 backup or everything changed since monday's level 1 backup? do I need to use the word cumulative in tuesday's level 1 backup? Thank you.
Level 1 backups will backup everything since the last level 0. In essence, by repeating the level 1 every day, you already have your cumulative backup.
Let me take that back.
Level 1 backups backup everything since the last level 0 OR level 1 backup. So yes, you will have to specify "cumulative" to get a cumulative backup.