4 Replies Latest reply: Jul 14, 2013 9:50 PM by Hemant K Chitale RSS

    diffrence b/w diffrential level1 and level2 and level3 and level4 backup.

    Niket Kumar

      diffrence b/w diffrential level1 and level2 and level3 and level4 backup.

        • 1. Re: diffrence b/w diffrential level1 and level2 and level3 and level4 backup.
          Paul M.

          diffrence b/w diffrential level1 and level2 and level3 and level4 backup.

          Where did you read/heard of level2, level3 and level4 backup ?

           

          See Making Incremental Backups in Getting Started with RMAN

          • 2. Re: diffrence b/w diffrential level1 and level2 and level3 and level4 backup.
            Niket Kumar

            {code}

             

            please check...

            version 11.2.0.3

            windows 7

             

            RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;

             

             

            Starting backup at 13-JUL-13

            using channel ORA_DISK_1

            channel ORA_DISK_1: starting incremental level 0 datafile backup set

            channel ORA_DISK_1: specifying datafile(s) in backup set

            input datafile file number=00001 name=C:\APP\J\ORADATA\ORAGG1\SYSTEM01.DBF

            input datafile file number=00002 name=C:\APP\J\ORADATA\ORAGG1\SYSAUX01.DBF

            input datafile file number=00006 name=C:\APP\J\ORADATA\ORAGG1\GGS_DATA01.DBF

            input datafile file number=00005 name=C:\APP\J\ORADATA\ORAGG1\EXAMPLE01.DBF

            input datafile file number=00004 name=C:\APP\J\ORADATA\ORAGG1\USERS01.DBF

            input datafile file number=00003 name=C:\APP\J\ORADATA\ORAGG1\UNDOTBS01.DBF

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NNND0_TAG20130713T163801_8Y2F8MBP_.BKP tag=TAG20130713T163801 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45

            channel ORA_DISK_1: starting incremental level 0 datafile backup set

            channel ORA_DISK_1: specifying datafile(s) in backup set

            including current control file in backup set

            including current SPFILE in backup set

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NCSN0_TAG20130713T163801_8Y2FB0KH_.BKP tag=TAG20130713T163801 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

            Finished backup at 13-JUL-13

             

             

            RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;

             

             

            Starting backup at 13-JUL-13

            using channel ORA_DISK_1

            channel ORA_DISK_1: starting incremental level 1 datafile backup set

            channel ORA_DISK_1: specifying datafile(s) in backup set

            input datafile file number=00001 name=C:\APP\J\ORADATA\ORAGG1\SYSTEM01.DBF

            input datafile file number=00002 name=C:\APP\J\ORADATA\ORAGG1\SYSAUX01.DBF

            input datafile file number=00006 name=C:\APP\J\ORADATA\ORAGG1\GGS_DATA01.DBF

            input datafile file number=00005 name=C:\APP\J\ORADATA\ORAGG1\EXAMPLE01.DBF

            input datafile file number=00004 name=C:\APP\J\ORADATA\ORAGG1\USERS01.DBF

            input datafile file number=00003 name=C:\APP\J\ORADATA\ORAGG1\UNDOTBS01.DBF

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NNND1_TAG20130713T164145_8Y2FHLHZ_.BKP tag=TAG20130713T164145 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

            channel ORA_DISK_1: starting incremental level 1 datafile backup set

            channel ORA_DISK_1: specifying datafile(s) in backup set

            including current control file in backup set

            including current SPFILE in backup set

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NCSN1_TAG20130713T164145_8Y2FJDQ8_.BKP tag=TAG20130713T164145 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

            Finished backup at 13-JUL-13

             

             

            RMAN> BACKUP INCREMENTAL LEVEL 2 DATABASE;

             

             

            Starting backup at 13-JUL-13

            using channel ORA_DISK_1

            channel ORA_DISK_1: starting incremental level 2 datafile backup set

            channel ORA_DISK_1: specifying datafile(s) in backup set

            input datafile file number=00001 name=C:\APP\J\ORADATA\ORAGG1\SYSTEM01.DBF

            input datafile file number=00002 name=C:\APP\J\ORADATA\ORAGG1\SYSAUX01.DBF

            input datafile file number=00006 name=C:\APP\J\ORADATA\ORAGG1\GGS_DATA01.DBF

            input datafile file number=00005 name=C:\APP\J\ORADATA\ORAGG1\EXAMPLE01.DBF

            input datafile file number=00004 name=C:\APP\J\ORADATA\ORAGG1\USERS01.DBF

            input datafile file number=00003 name=C:\APP\J\ORADATA\ORAGG1\UNDOTBS01.DBF

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NNND2_TAG20130713T164325_8Y2FLP22_.BKP tag=TAG20130713T164325 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26

            channel ORA_DISK_1: starting incremental level 2 datafile backup set

            channel ORA_DISK_1: specifying datafile(s) in backup set

            including current control file in backup set

            including current SPFILE in backup set

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NCSN2_TAG20130713T164325_8Y2FMLB7_.BKP tag=TAG20130713T164325 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

            Finished backup at 13-JUL-13

             

             

            RMAN>

             

             

            RMAN> BACKUP INCREMENTAL LEVEL 3 DATABASE;

             

             

            Starting backup at 13-JUL-13

            using channel ORA_DISK_1

            channel ORA_DISK_1: starting incremental level 3 datafile backup set

            channel ORA_DISK_1: specifying datafile(s) in backup set

            input datafile file number=00001 name=C:\APP\J\ORADATA\ORAGG1\SYSTEM01.DBF

            input datafile file number=00002 name=C:\APP\J\ORADATA\ORAGG1\SYSAUX01.DBF

            input datafile file number=00006 name=C:\APP\J\ORADATA\ORAGG1\GGS_DATA01.DBF

            input datafile file number=00005 name=C:\APP\J\ORADATA\ORAGG1\EXAMPLE01.DBF

            input datafile file number=00004 name=C:\APP\J\ORADATA\ORAGG1\USERS01.DBF

            input datafile file number=00003 name=C:\APP\J\ORADATA\ORAGG1\UNDOTBS01.DBF

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NNND3_TAG20130713T164444_8Y2FO4S0_.BKP tag=TAG20130713T164444 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

            channel ORA_DISK_1: starting incremental level 3 datafile backup set

            channel ORA_DISK_1: specifying datafile(s) in backup set

            including current control file in backup set

            including current SPFILE in backup set

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NCSN3_TAG20130713T164444_8Y2FOZ2K_.BKP tag=TAG20130713T164444 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

            Finished backup at 13-JUL-13

             

             

            RMAN> BACKUP INCREMENTAL LEVEL 4 DATABASE;

             

             

            Starting backup at 13-JUL-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=C:\APP\J\ORADATA\ORAGG1\SYSTEM01.DBF

            input datafile file number=00002 name=C:\APP\J\ORADATA\ORAGG1\SYSAUX01.DBF

            input datafile file number=00006 name=C:\APP\J\ORADATA\ORAGG1\GGS_DATA01.DBF

            input datafile file number=00005 name=C:\APP\J\ORADATA\ORAGG1\EXAMPLE01.DBF

            input datafile file number=00004 name=C:\APP\J\ORADATA\ORAGG1\USERS01.DBF

            input datafile file number=00003 name=C:\APP\J\ORADATA\ORAGG1\UNDOTBS01.DBF

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NNND4_TAG20130713T164530_8Y2FPLZ5_.BKP tag=TAG20130713T164530 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26

            channel ORA_DISK_1: starting incremental level 4 datafile backup set

            channel ORA_DISK_1: specifying datafile(s) in backup set

            including current control file in backup set

            including current SPFILE in backup set

            channel ORA_DISK_1: starting piece 1 at 13-JUL-13

            channel ORA_DISK_1: finished piece 1 at 13-JUL-13

            piece handle=C:\APP\J\FLASH_RECOVERY_AREA\ORAGG1\BACKUPSET\2013_07_13\O1_MF_NCSN4_TAG20130713T164530_8Y2FQFBY_.BKP tag=TAG20130713T164530 comment=NONE

            channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

            Finished backup at 13-JUL-13

             

             

            RMAN> BACKUP INCREMENTAL LEVEL 5 DATABASE;

             

             

            Starting backup at 13-JUL-13

            using channel ORA_DISK_1

            RMAN-00571: ===========================================================

            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

            RMAN-00571: ===========================================================

            RMAN-03002: failure of backup command at 07/13/2013 16:46:08

            RMAN-06011: invalid level specified: 5

             

             

            RMAN>

             

            {CODE}

            • 3. Re: diffrence b/w diffrential level1 and level2 and level3 and level4 backup.
              Paul M.

              Well... 12c, 11g and 10g documentation do not mention incremental level above 1... but 9i does :

               

              RMAN Concepts I: Channels, Backups, and Copies

              • 4. Re: diffrence b/w diffrential level1 and level2 and level3 and level4 backup.
                Hemant K Chitale

                Since 10g (at least 10gR2, maybe 10gR1),  Oracle only runs L1  backups above L0 backups.  All higher "levels" are ignored  but executed (as L1 backups) without error.  You need to be careful about using DIFFERENTIAL and CUMULATIVE.

                 

                See Oracle Support Note


                Hemant K Chitale