Making Faster Backups of Large Files :Using backup section size

RMAN> run
2> {
3> allocate channel d1 device type disk;
4> allocate channel d2 device type disk;
5> allocate channel d3 device type disk;
6> backup section size 200m tablespace system;
7> }

released channel: ORA_DISK_1
allocated channel: d1
channel d1: SID=170 device type=DISK

allocated channel: d2
channel d2: SID=140 device type=DISK

allocated channel: d3
channel d3: SID=130 device type=DISK

Starting backup at 04-APR-10
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
backing up blocks 1 through 25600
channel d1: starting piece 1 at 04-APR-10
channel d2: starting full datafile backup set
channel d2: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
backing up blocks 25601 through 51200
channel d2: starting piece 2 at 04-APR-10
channel d3: starting full datafile backup set
channel d3: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
backing up blocks 51201 through 76800
channel d3: starting piece 3 at 04-APR-10
channel d1: finished piece 1 at 04-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO45BZ_.BKP tag=TAG20100404T190348 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\11GSOFTWARE\ORADATA\SANDEEP\SYSTEM01.DBF
backing up blocks 76801 through 93440
channel d1: starting piece 4 at 04-APR-10
channel d2: finished piece 2 at 04-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO4FDF_.BKP tag=TAG20100404T190348 comment=NONE
channel d2: backup set complete, elapsed time: 00:01:21
channel d3: finished piece 3 at 04-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO5015_.BKP tag=TAG20100404T190348 comment=NONE
channel d3: backup set complete, elapsed time: 00:01:17
channel d1: finished piece 4 at 04-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\BACKUPSET\2010_04_04\O1_MF_NNNDF_TAG20100404T190348_5VKO6M5K_.BKP tag=TAG20100404T190348 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:30
Finished backup at 04-APR-10

Starting Control File and SPFILE Autobackup at 04-APR-10
piece handle=D:\11GSOFTWARE\FLASH_RECOVERY_AREA\SANDEEP\AUTOBACKUP\2010_04_04\O1_MF_S_715460735_5VKO7JO0_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 04-APR-10
released channel: d1
released channel: d2
released channel: d3

RMAN>

No comments:

Post a Comment