RMAN back up. need your help

[wren01]

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?

[marist89]

Are you trying to do block level incrementals? Need more information on what you are trying to do....

[wren01]

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.

[marist89]

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.

[wren01]

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.

[marist89]

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.

[marist89]

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.