3 Replies Latest reply: Apr 23, 2012 8:40 AM by mBk77 RSS

    FULL backup and LEVEL 0

    user522961
      Hi,
      on 11g R2 on Win 2008.
      I backup in NOCATALOG.
      When I issue list backup Command I have :
       
      BS Key  Type LV Size       Device Type Elapsed Time Completion Time 
      ------- ---- -- ---------- ----------- ------------ --------------- 
      6       Incr 0  3.73G ;     DISK        00:09:50     23/04/12 
              BP Key: 6   Status: AVAILABLE  Compressed: YES  Tag: TAG20120423T134319 
      
      BS Key  Type LV Size       Device Type Elapsed Time Completion Time 
      ------- ---- -- ---------- ----------- ------------ --------------- 
      3       Full    1.05M ;     DISK        00:00:01     23/04/12 
              BP Key: 3   Status: AVAILABLE  Compressed: YES  Tag: TAG20120423T132033 
      Then what is the difference between Type=FULL and Type=Incr 0 ?

      Thank you.
      Context :
      I ran full backup first :
      backup as compressed backupset format '%WORK_DIR%\%DB%\rman\full/df_%%d_%%T_%%s_%%p' database;

      And then ran incremental :

      backup as compressed backupset format '%WORK_DIR%\%DB%\rman\incr/df_%%d_%%T_%%s_%%p' INCREMENTAL LEVEL 1 database;

      And for the second it showed me :
      no backup or copy of parent data file nn was found.
        • 1. Re: FULL backup and LEVEL 0
          hitgon
          Hello,


          Full
          -----=

          A backup of a datafile that includes every allocated block in the file being backed up. A full backup of a datafile can be an image copy, in which case every data block is backed up. It can also be stored in a backup set, in which case datafile blocks not in use may be skipped, according to rules in Oracle Database Backup and Recovery Reference.

          A full backup cannot be part of an incremental backup strategy; that is, it cannot be the parent for a subsequent incremental backup.

          Incremental
          -----=
          An incremental backup is either a level 0 backup, which includes every block in the file except blocks compressed out because they have never been used, or a level 1 backup, which includes only those blocks that have been changed since the parent backup was taken.

          A level 0 incremental backup is physically identical to a full backup. The only difference is that the level 0 backup is recorded as an incremental backup in the RMAN repository, so it can be used as the parent for a level 1 backup.

          Please find the detail document
          http://web.njit.edu/info/oracle/DOC/backup.102/b14191/rcmconc1005.htm

          Regards
          Hitgon
          • 2. Re: FULL backup and LEVEL 0
            user522961
            Thank you.
            yes I have already read and re read this documents. That's the reason of my question and I can not understand why after a FULL backup RMAN has done a Level 0 (i.e Incr=0) backup which is the same ?

            Regards;
            • 3. Re: FULL backup and LEVEL 0
              mBk77
              An incremental backup at level 0 is identical in content to a full backup, but unlike a full backup the level 0 backup is considered a part of the incremental backup strategy.

              A level 1 incremental backup can be either of the following types:

              A differential incremental backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0

              A cumulative incremental backup, which backs up all blocks changed after the most recent incremental backup at level 0

              Incremental backups are differential by default.