5 Replies Latest reply: May 4, 2013 4:38 AM by arizuddin RSS

    Cumulative Incremental?

    896971
      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
          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
            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
              Hi
              Please update.

              Regards
              • 4. Re: Cumulative Incremental?
                EdStevens
                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
                  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