incremental and cumulative backup using RMAN (Examples)

RMAN> backup incremental level 0 database plus archivelog;


Starting backup at 05-APR-10
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=120 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=126 RECID=8 STAMP=715445352
input archived log thread=1 sequence=127 RECID=9 STAMP=715447009
input archived log thread=1 sequence=128 RECID=10 STAMP=715447264
input archived log thread=1 sequence=129 RECID=11 STAMP=715471263
input archived log thread=1 sequence=130 RECID=12 STAMP=715513719
channel ORA_DISK_1: starting piece 1 at 05-APR-10
channel ORA_DISK_1: finished piece 1 at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_05\O1_MF_ANNNN_TAG20100405T094842_5VM8ZD15_.BKP tag=TAG20100405T094842 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 05-APR-10

Starting backup at 05-APR-10
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=00002 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSAUX01.DBF
input datafile file number=00001 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
input datafile file number=00005 name=D:\11GSOFTWARE\ORADATA\SANDEEP\EXAMPLE01.DBF
input datafile file number=00003 name=D:\11GSOFTWARE\ORADATA\SANDEEP\UNDOTBS01.DBF
input datafile file number=00004 name=D:\11GSOFTWARE\ORADATA\SANDEEP\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 05-APR-10
channel ORA_DISK_1: finished piece 1 at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_05\O1_MF_NNND0_TAG20100405T094909_5VM907OC_.BKP tag=TAG20100405T094909 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:05
Finished backup at 05-APR-10

Starting backup at 05-APR-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=131 RECID=13 STAMP=715513997
channel ORA_DISK_1: starting piece 1 at 05-APR-10
channel ORA_DISK_1: finished piece 1 at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_05\O1_MF_ANNNN_TAG20100405T095317_5VM97YDJ_.BKP tag=TAG20100405T095317 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 05-APR-10

Starting Control File and SPFILE Autobackup at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\AUTOBACKUP\2010_04_05\O1_MF_S_715513999_5VM981FF_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 05-APR-10

RMAN> backup incremental level 1 database plus archivelog;


Starting backup at 05-APR-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=126 RECID=8 STAMP=715445352
input archived log thread=1 sequence=127 RECID=9 STAMP=715447009
input archived log thread=1 sequence=128 RECID=10 STAMP=715447264
input archived log thread=1 sequence=129 RECID=11 STAMP=715471263
input archived log thread=1 sequence=130 RECID=12 STAMP=715513719
input archived log thread=1 sequence=131 RECID=13 STAMP=715513997
input archived log thread=1 sequence=132 RECID=14 STAMP=715514053
channel ORA_DISK_1: starting piece 1 at 05-APR-10
channel ORA_DISK_1: finished piece 1 at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_05\O1_MF_ANNNN_TAG20100405T095414_5VM99Q5L_.BKP tag=TAG20100405T095414 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 05-APR-10

Starting backup at 05-APR-10
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=00002 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSAUX01.DBF
input datafile file number=00001 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
input datafile file number=00005 name=D:\11GSOFTWARE\ORADATA\SANDEEP\EXAMPLE01.DBF
input datafile file number=00003 name=D:\11GSOFTWARE\ORADATA\SANDEEP\UNDOTBS01.DBF
input datafile file number=00004 name=D:\11GSOFTWARE\ORADATA\SANDEEP\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 05-APR-10
channel ORA_DISK_1: finished piece 1 at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_05\O1_MF_NNND1_TAG20100405T095440_5VM9BMKJ_.BKP tag=TAG20100405T095440 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:15
Finished backup at 05-APR-10

Starting backup at 05-APR-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=133 RECID=15 STAMP=715514220
channel ORA_DISK_1: starting piece 1 at 05-APR-10
channel ORA_DISK_1: finished piece 1 at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_05\O1_MF_ANNNN_TAG20100405T095700_5VM9GXHN_.BKP tag=TAG20100405T095700 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 05-APR-10

Starting Control File and SPFILE Autobackup at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\AUTOBACKUP\2010_04_05\O1_MF_S_715514222_5VM9H0T9_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 05-APR-10

RMAN> backup incremental level 1 cumulative database;

Starting backup at 05-APR-10
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=00002 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSAUX01.DBF
input datafile file number=00001 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
input datafile file number=00005 name=D:\11GSOFTWARE\ORADATA\SANDEEP\EXAMPLE01.DBF
input datafile file number=00003 name=D:\11GSOFTWARE\ORADATA\SANDEEP\UNDOTBS01.DBF
input datafile file number=00004 name=D:\11GSOFTWARE\ORADATA\SANDEEP\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 05-APR-10
channel ORA_DISK_1: finished piece 1 at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_05\O1_MF_NNND1_TAG20100405T095916_5VM9M5PB_.BKP tag=TAG20100405T095916 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05
Finished backup at 05-APR-10

Starting Control File and SPFILE Autobackup at 05-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\AUTOBACKUP\2010_04_05\O1_MF_S_715514482_5VM9Q4TZ_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 05-APR-10

RMAN>