This discussion is archived
5 Replies Latest reply: May 4, 2013 2:38 AM by arizuddin RSS

Cumulative Incremental?

896971 Newbie
Currently Being Moderated
Hopefully you all can resolve a question for me. I was under the impression that a CUMULATIVE backup and an INCREMENTAL backup were two separate things.

INCREMENTAL LEVEL : Copies only those data blocks that have changed since the last incremental integer backup, where integer is 0 or 1 (see Example 2-16).
CUMULATIVE : Copies the data blocks used since the most recent level 0 backup (see Example 2-16).

So I go to "Example 2-16"...
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm

Example 2-16 Performing a Cumulative Incremental Backup

This example backs up all blocks changed in the database since the most recent level 0 incremental backup. If no level 0 backup exists when you run a level 1 backup, then RMAN makes a level 0 backup automatically. Any inaccessible files are skipped.

BACKUP 
  INCREMENTAL LEVEL 1 CUMULATIVE
  SKIP INACCESSIBLE 
  DATABASE;
I am confused. I thought that cumulative/incremental were exclusive backup types. How can they both be referenced in the same code block?

Thanks
  • 1. Re: Cumulative Incremental?
    DK2010 Guru
    Currently Being Moderated
    Hi,

    please donot be confuse In the same document it written


    Incremental Backups:

    An INCREMENTAL backup at level 0 backs up all data blocks in datafiles being backed up. An incremental backup at level 0 is identical in content to a FULL backup,
    but unlike a full backup the level 0 backup is a part of the incremental backup strategy.

    A level 1 backup copies only changed blocks. A level 1 incremental backup is either differential or CUMULATIVE.
    *If cumulative, RMAN backs up all blocks changed since the most recent level 0 backup.*
    *If differential, RMAN backs up blocks updated since the most recent level 0 or level 1 incremental backup.*


    HTH :)
  • 2. Re: Cumulative Incremental?
    arizuddin Newbie
    Currently Being Moderated
    Hi
    We have our level 0 on last friday and sat,sun,mon,tues,wed,thurs- level 1 backup. Next (then) friday, (for some reason, i cannot perform level 0) and i want to take cumulative, instead of incremental. Does it backup since last level 0 or thursday level 1?

    Please clarify.
  • 3. Re: Cumulative Incremental?
    arizuddin Newbie
    Currently Being Moderated
    Hi
    Please update.

    Regards
  • 4. Re: Cumulative Incremental?
    EdStevens Guru
    Currently Being Moderated
    arizuddin wrote:
    Hi
    We have our level 0 on last friday and sat,sun,mon,tues,wed,thurs- level 1 backup. Next (then) friday, (for some reason, i cannot perform level 0) and i want to take cumulative, instead of incremental. Does it backup since last level 0 or thursday level 1?

    Please clarify.
    As already stated in the quoted docs, a cumulative incremental backup will backup all the blocks changed since the last level 0.

    I'd be addressing why "for some reason, i cannot perform level 0". What errors do you get?
  • 5. Re: Cumulative Incremental?
    arizuddin Newbie
    Currently Being Moderated
    Hi
    Thanks for the update.
    I'd be addressing why "for some reason, i cannot perform level 0". What errors do you get?
    No, errors. Actually, if i miss level 0 backup. Instead of another level 1 incremental, i wanted to take level 1 cumulative.
    Regards
    Arizuddin

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points