4 Replies Latest reply: Apr 22, 2013 9:16 AM by Prashant Dixit RSS

    RMAN Incremental Backup Levels

    Prashant Dixit
      Hi Everyone,

      I'm very much clear about backup types:
      Level 0 (Base Backup - Incremental and works just like Full Backup.
      Level 1 (Could be Differential or Cumulative Incremental Backups).
      Level 2

      There are levels (0-4) for Incremental Backups, but can someone please help me to understand Level 3 and 4 in particular.
      * Oracle Allows incremental levels with a limit of 4 (Please check below provided RMAN backup snippets with message).


      RMAN> backup incremental level 5 database;

      Starting backup at 21-APR-13
      using channel ORA_DISK_1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of backup command at 04/21/2013 10:15:12
      RMAN-06011: invalid level specified: 5





      RMAN> backup incremental level 4 datafile 1;

      Starting backup at 21-APR-13
      using channel ORA_DISK_1
      channel ORA_DISK_1: starting incremental level 4 datafile backup set
      channel ORA_DISK_1: specifying datafile(s) in backup set
      input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
      channel ORA_DISK_1: starting piece 1 at 21-APR-13
      channel ORA_DISK_1: finished piece 1 at 21-APR-13
      piece handle=/u01/app/oracle/flash_recovery_area/REDANT/backupset/2013_04_21/o1_mf_nnnd4_TAG20130421T105417_8q6y021p_.bkp tag=TAG20130421T105417 comment=NONE
      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
      channel ORA_DISK_1: starting incremental level 4 datafile backup set
      channel ORA_DISK_1: specifying datafile(s) in backup set

      user interrupt received



      As per one of the documentation available online (Although for 9i)
      Source: http://sqltech.cl/doc/oracle9i/server.901/a90202/rmanus.htm

      "RMAN-06011 invalid level specified: number
      Cause: An invalid incremental backup level was specified.
      Action: *Incremental backup level must be between 0 and 8.* /* I'm Zapped Now/



      Thanks
      Prashant Dixit
        • 1. Re: RMAN Incremental Backup Levels
          Balazs Papp
          Nth level backup contains change since the last (N-1)th (however differential and incremental backups were introduced after 9i).

          Features change with versions, level 4 is the maximum now.

          http://docs.oracle.com/cd/E11882_01/server.112/e17766/rmanus.htm#sthref16578

          RMAN-06011: invalid level specified: number
          Cause: An invalid incremental backup level was specified.
          Action: Incremental backup level must be between 0 and 4.
          • 2. Re: RMAN Incremental Backup Levels
            Prashant Dixit
            Thanks Balazs for replying.

            Well error code is very much direct and says about invalid level specified: That is 5 and can be easily collected from OERR Utility or by referring any xyz webpage or Metalink.
            There were more than Level 4 in older release. 0-4 are still available in Oracle 11g R2.

            But my query stands still.

            Question: what is the significance of using Level 3 - Level 4 ? ... If possible please provide any examples.


            Thanks
            Prashant Dixit
            • 3. Re: RMAN Incremental Backup Levels
              Hemant K Chitale
              Since 10g, Levels above 1 behave as Level 1 Differential Backups. They are no longer documented.
              For example, see Oracle Support Note "Does RMAN Oracle10g Db support Incremental Level 2 backups? [ID 733535.1]"

              Hemant K Chitale
              • 4. Re: RMAN Incremental Backup Levels
                Prashant Dixit
                Thanks Hemant.
                A perfect Answer!!

                This is what i was looking for. Thanks for providing reference doc to prove the point.


                Thanks
                Prashant Dixit