增量备份无法使用section size参数

11g的rman备份有使用section size的参数，利用这个参数，你可以针对单个大文件的数据文件（如big file tablespace）采用并发的方式进行备份。可惜很遗憾，这个新特性的参数不能和增量备份一起使用。演示如下：

非增量备份的情况下：

RMAN>  run
2>  {
3>  allocate channel c1 type disk;
4>  allocate channel c2 type disk;
5>  allocate channel c3 type disk;
6>  allocate channel c4 type disk;
7>  allocate channel c5 type disk;
8>  allocate channel c6 type disk;
9>  allocate channel c7 type disk;
10>  allocate channel c8 type disk;
11>  backup section size 200M datafile 5 format 'c:\file5_%U_.bk';
12>  release channel c1;
13>  release channel c2;
14>  release channel c3;
15>  release channel c4;
16>  release channel c5;
17>  release channel c6;
18>  release channel c7;
19>  release channel c8;
20>  }

allocated channel: c1
channel c1: SID=11 device type=DISK

allocated channel: c2
channel c2: SID=68 device type=DISK

allocated channel: c3
channel c3: SID=133 device type=DISK

allocated channel: c4
channel c4: SID=196 device type=DISK

allocated channel: c5
channel c5: SID=72 device type=DISK

allocated channel: c6
channel c6: SID=132 device type=DISK

allocated channel: c7
channel c7: SID=191 device type=DISK

allocated channel: c8
channel c8: SID=13 device type=DISK

Starting backup at 13-JUN-13
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1 through 25600
channel c1: starting piece 1 at 13-JUN-13
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 25601 through 51200
channel c2: starting piece 2 at 13-JUN-13
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 51201 through 76800
channel c3: starting piece 3 at 13-JUN-13
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 76801 through 102400
channel c4: starting piece 4 at 13-JUN-13
channel c5: starting full datafile backup set
channel c5: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 102401 through 128000
channel c5: starting piece 5 at 13-JUN-13
channel c6: starting full datafile backup set
channel c6: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 128001 through 153600
channel c6: starting piece 6 at 13-JUN-13
channel c7: starting full datafile backup set
channel c7: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 153601 through 179200
channel c7: starting piece 7 at 13-JUN-13
channel c8: starting full datafile backup set
channel c8: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 179201 through 204800
channel c8: starting piece 8 at 13-JUN-13
channel c1: finished piece 1 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_1_1_.BK tag=TAG20130613T110804 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 204801 through 230400
channel c1: starting piece 9 at 13-JUN-13
channel c2: finished piece 2 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_2_1_.BK tag=TAG20130613T110804 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:03
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 230401 through 256000
channel c2: starting piece 10 at 13-JUN-13
channel c3: finished piece 3 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_3_1_.BK tag=TAG20130613T110804 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:03
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 256001 through 281600
channel c3: starting piece 11 at 13-JUN-13
channel c4: finished piece 4 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_4_1_.BK tag=TAG20130613T110804 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:02
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 281601 through 307200
channel c4: starting piece 12 at 13-JUN-13
channel c5: finished piece 5 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_5_1_.BK tag=TAG20130613T110804 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:03
channel c5: starting full datafile backup set
channel c5: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 307201 through 332800
channel c5: starting piece 13 at 13-JUN-13
channel c6: finished piece 6 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_6_1_.BK tag=TAG20130613T110804 comment=NONE
channel c6: backup set complete, elapsed time: 00:00:03
channel c6: starting full datafile backup set
channel c6: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 332801 through 358400
channel c6: starting piece 14 at 13-JUN-13
channel c1: finished piece 9 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_9_1_.BK tag=TAG20130613T110804 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 358401 through 384000
channel c1: starting piece 15 at 13-JUN-13
channel c2: finished piece 10 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_10_1_.BK tag=TAG20130613T110804 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 384001 through 409600
channel c2: starting piece 16 at 13-JUN-13
channel c3: finished piece 11 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_11_1_.BK tag=TAG20130613T110804 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 409601 through 435200
channel c3: starting piece 17 at 13-JUN-13
channel c4: finished piece 12 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_12_1_.BK tag=TAG20130613T110804 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:02
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 435201 through 460800
channel c4: starting piece 18 at 13-JUN-13
channel c7: finished piece 7 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_7_1_.BK tag=TAG20130613T110804 comment=NONE
channel c7: backup set complete, elapsed time: 00:00:04
channel c7: starting full datafile backup set
channel c7: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 460801 through 486400
channel c7: starting piece 19 at 13-JUN-13
channel c8: finished piece 8 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_8_1_.BK tag=TAG20130613T110804 comment=NONE
channel c8: backup set complete, elapsed time: 00:00:04
channel c8: starting full datafile backup set
channel c8: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 486401 through 512000
channel c8: starting piece 20 at 13-JUN-13
channel c1: finished piece 15 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_15_1_.BK tag=TAG20130613T110804 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 512001 through 537600
channel c1: starting piece 21 at 13-JUN-13
channel c2: finished piece 16 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_16_1_.BK tag=TAG20130613T110804 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 537601 through 563200
channel c2: starting piece 22 at 13-JUN-13
channel c3: finished piece 17 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_17_1_.BK tag=TAG20130613T110804 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 563201 through 588800
channel c3: starting piece 23 at 13-JUN-13
channel c4: finished piece 18 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_18_1_.BK tag=TAG20130613T110804 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:02
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 588801 through 614400
channel c4: starting piece 24 at 13-JUN-13
channel c5: finished piece 13 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_13_1_.BK tag=TAG20130613T110804 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:04
channel c5: starting full datafile backup set
channel c5: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 614401 through 640000
channel c5: starting piece 25 at 13-JUN-13
channel c6: finished piece 14 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_14_1_.BK tag=TAG20130613T110804 comment=NONE
channel c6: backup set complete, elapsed time: 00:00:04
channel c6: starting full datafile backup set
channel c6: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 640001 through 665600
channel c6: starting piece 26 at 13-JUN-13
channel c1: finished piece 21 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_21_1_.BK tag=TAG20130613T110804 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 665601 through 691200
channel c1: starting piece 27 at 13-JUN-13
channel c2: finished piece 22 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_22_1_.BK tag=TAG20130613T110804 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:01
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 691201 through 716800
channel c2: starting piece 28 at 13-JUN-13
channel c3: finished piece 23 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_23_1_.BK tag=TAG20130613T110804 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 716801 through 742400
channel c3: starting piece 29 at 13-JUN-13
channel c4: finished piece 24 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_24_1_.BK tag=TAG20130613T110804 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:02
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 742401 through 768000
channel c4: starting piece 30 at 13-JUN-13
channel c7: finished piece 19 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_19_1_.BK tag=TAG20130613T110804 comment=NONE
channel c7: backup set complete, elapsed time: 00:00:05
channel c7: starting full datafile backup set
channel c7: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 768001 through 793600
channel c7: starting piece 31 at 13-JUN-13
channel c8: finished piece 20 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_20_1_.BK tag=TAG20130613T110804 comment=NONE
channel c8: backup set complete, elapsed time: 00:00:04
channel c8: starting full datafile backup set
channel c8: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 793601 through 819200
channel c8: starting piece 32 at 13-JUN-13
channel c1: finished piece 27 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_27_1_.BK tag=TAG20130613T110804 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 819201 through 844800
channel c1: starting piece 33 at 13-JUN-13
channel c2: finished piece 28 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_28_1_.BK tag=TAG20130613T110804 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 844801 through 870400
channel c2: starting piece 34 at 13-JUN-13
channel c3: finished piece 29 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_29_1_.BK tag=TAG20130613T110804 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 870401 through 896000
channel c3: starting piece 35 at 13-JUN-13
channel c4: finished piece 30 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_30_1_.BK tag=TAG20130613T110804 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:02
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 896001 through 921600
channel c4: starting piece 36 at 13-JUN-13
channel c5: finished piece 25 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_25_1_.BK tag=TAG20130613T110804 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:04
channel c5: starting full datafile backup set
channel c5: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 921601 through 947200
channel c5: starting piece 37 at 13-JUN-13
channel c6: finished piece 26 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_26_1_.BK tag=TAG20130613T110804 comment=NONE
channel c6: backup set complete, elapsed time: 00:00:04
channel c6: starting full datafile backup set
channel c6: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 947201 through 972800
channel c6: starting piece 38 at 13-JUN-13
channel c1: finished piece 33 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_33_1_.BK tag=TAG20130613T110804 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 972801 through 998400
channel c1: starting piece 39 at 13-JUN-13
channel c2: finished piece 34 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_34_1_.BK tag=TAG20130613T110804 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 998401 through 1024000
channel c2: starting piece 40 at 13-JUN-13
channel c3: finished piece 35 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_35_1_.BK tag=TAG20130613T110804 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1024001 through 1049600
channel c3: starting piece 41 at 13-JUN-13
channel c4: finished piece 36 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_36_1_.BK tag=TAG20130613T110804 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:02
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1049601 through 1075200
channel c4: starting piece 42 at 13-JUN-13
channel c7: finished piece 31 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_31_1_.BK tag=TAG20130613T110804 comment=NONE
channel c7: backup set complete, elapsed time: 00:00:04
channel c7: starting full datafile backup set
channel c7: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1075201 through 1100800
channel c7: starting piece 43 at 13-JUN-13
channel c8: finished piece 32 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_32_1_.BK tag=TAG20130613T110804 comment=NONE
channel c8: backup set complete, elapsed time: 00:00:04
channel c8: starting full datafile backup set
channel c8: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1100801 through 1126400
channel c8: starting piece 44 at 13-JUN-13
channel c1: finished piece 39 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_39_1_.BK tag=TAG20130613T110804 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1126401 through 1152000
channel c1: starting piece 45 at 13-JUN-13
channel c2: finished piece 40 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_40_1_.BK tag=TAG20130613T110804 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1152001 through 1177600
channel c2: starting piece 46 at 13-JUN-13
channel c3: finished piece 41 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_41_1_.BK tag=TAG20130613T110804 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:03
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1177601 through 1203200
channel c3: starting piece 47 at 13-JUN-13
channel c4: finished piece 42 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_42_1_.BK tag=TAG20130613T110804 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:03
channel c4: starting full datafile backup set
channel c4: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1203201 through 1228800
channel c4: starting piece 48 at 13-JUN-13
channel c5: finished piece 37 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_37_1_.BK tag=TAG20130613T110804 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:06
channel c5: starting full datafile backup set
channel c5: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1228801 through 1254400
channel c5: starting piece 49 at 13-JUN-13
channel c6: finished piece 38 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_38_1_.BK tag=TAG20130613T110804 comment=NONE
channel c6: backup set complete, elapsed time: 00:00:05
channel c6: starting full datafile backup set
channel c6: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1254401 through 1280000
channel c6: starting piece 50 at 13-JUN-13
channel c1: finished piece 45 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_45_1_.BK tag=TAG20130613T110804 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1280001 through 1305600
channel c1: starting piece 51 at 13-JUN-13
channel c2: finished piece 46 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_46_1_.BK tag=TAG20130613T110804 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
backing up blocks 1305601 through 1310720
channel c2: starting piece 52 at 13-JUN-13
channel c3: finished piece 47 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_47_1_.BK tag=TAG20130613T110804 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:02
channel c4: finished piece 48 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_48_1_.BK tag=TAG20130613T110804 comment=NONE
channel c4: backup set complete, elapsed time: 00:00:01
channel c7: finished piece 43 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_43_1_.BK tag=TAG20130613T110804 comment=NONE
channel c7: backup set complete, elapsed time: 00:00:04
channel c8: finished piece 44 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_44_1_.BK tag=TAG20130613T110804 comment=NONE
channel c8: backup set complete, elapsed time: 00:00:03
channel c5: finished piece 49 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_49_1_.BK tag=TAG20130613T110804 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:01
channel c6: finished piece 50 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_50_1_.BK tag=TAG20130613T110804 comment=NONE
channel c6: backup set complete, elapsed time: 00:00:01
channel c1: finished piece 51 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_51_1_.BK tag=TAG20130613T110804 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
channel c2: finished piece 52 at 13-JUN-13
piece handle=C:\FILE5_0MOC318K_52_1_.BK tag=TAG20130613T110804 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:01
Finished backup at 13-JUN-13

released channel: c1

released channel: c2

released channel: c3

released channel: c4

released channel: c5

released channel: c6

released channel: c7

released channel: c8

RMAN>

RMAN>

RMAN>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

RMAN> run

2> {

3> allocate channel c1 type disk;

4> allocate channel c2 type disk;

5> allocate channel c3 type disk;

6> allocate channel c4 type disk;

7> allocate channel c5 type disk;

8> allocate channel c6 type disk;

9> allocate channel c7 type disk;

10> allocate channel c8 type disk;

11> backup section size 200M datafile 5 format 'c:\file5_%U_.bk';

12> release channel c1;

13> release channel c2;

14> release channel c3;

15> release channel c4;

16> release channel c5;

17> release channel c6;

18> release channel c7;

19> release channel c8;

20> }

allocated channel: c1

channel c1: SID=11 device type=DISK

allocated channel: c2

channel c2: SID=68 device type=DISK

allocated channel: c3

channel c3: SID=133 device type=DISK

allocated channel: c4

channel c4: SID=196 device type=DISK

allocated channel: c5

channel c5: SID=72 device type=DISK

allocated channel: c6

channel c6: SID=132 device type=DISK

allocated channel: c7

channel c7: SID=191 device type=DISK

allocated channel: c8

channel c8: SID=13 device type=DISK

Starting backup at 13-JUN-13

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1 through 25600

channel c1: starting piece 1 at 13-JUN-13

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 25601 through 51200

channel c2: starting piece 2 at 13-JUN-13

channel c3: starting full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 51201 through 76800

channel c3: starting piece 3 at 13-JUN-13

channel c4: starting full datafile backup set

channel c4: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 76801 through 102400

channel c4: starting piece 4 at 13-JUN-13

channel c5: starting full datafile backup set

channel c5: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 102401 through 128000

channel c5: starting piece 5 at 13-JUN-13

channel c6: starting full datafile backup set

channel c6: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 128001 through 153600

channel c6: starting piece 6 at 13-JUN-13

channel c7: starting full datafile backup set

channel c7: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 153601 through 179200

channel c7: starting piece 7 at 13-JUN-13

channel c8: starting full datafile backup set

channel c8: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 179201 through 204800

channel c8: starting piece 8 at 13-JUN-13

channel c1: finished piece 1 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_1_1_.BK tag=TAG20130613T110804 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:02

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 204801 through 230400

channel c1: starting piece 9 at 13-JUN-13

channel c2: finished piece 2 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_2_1_.BK tag=TAG20130613T110804 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:03

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 230401 through 256000

channel c2: starting piece 10 at 13-JUN-13

channel c3: finished piece 3 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_3_1_.BK tag=TAG20130613T110804 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:03

channel c3: starting full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 256001 through 281600

channel c3: starting piece 11 at 13-JUN-13

channel c4: finished piece 4 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_4_1_.BK tag=TAG20130613T110804 comment=NONE

channel c4: backup set complete, elapsed time: 00:00:02

channel c4: starting full datafile backup set

channel c4: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 281601 through 307200

channel c4: starting piece 12 at 13-JUN-13

channel c5: finished piece 5 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_5_1_.BK tag=TAG20130613T110804 comment=NONE

channel c5: backup set complete, elapsed time: 00:00:03

channel c5: starting full datafile backup set

channel c5: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 307201 through 332800

channel c5: starting piece 13 at 13-JUN-13

channel c6: finished piece 6 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_6_1_.BK tag=TAG20130613T110804 comment=NONE

channel c6: backup set complete, elapsed time: 00:00:03

channel c6: starting full datafile backup set

channel c6: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 332801 through 358400

channel c6: starting piece 14 at 13-JUN-13

channel c1: finished piece 9 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_9_1_.BK tag=TAG20130613T110804 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:02

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 358401 through 384000

channel c1: starting piece 15 at 13-JUN-13

channel c2: finished piece 10 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_10_1_.BK tag=TAG20130613T110804 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:02

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 384001 through 409600

channel c2: starting piece 16 at 13-JUN-13

channel c3: finished piece 11 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_11_1_.BK tag=TAG20130613T110804 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:02

channel c3: starting full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 409601 through 435200

channel c3: starting piece 17 at 13-JUN-13

channel c4: finished piece 12 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_12_1_.BK tag=TAG20130613T110804 comment=NONE

channel c4: backup set complete, elapsed time: 00:00:02

channel c4: starting full datafile backup set

channel c4: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 435201 through 460800

channel c4: starting piece 18 at 13-JUN-13

channel c7: finished piece 7 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_7_1_.BK tag=TAG20130613T110804 comment=NONE

channel c7: backup set complete, elapsed time: 00:00:04

channel c7: starting full datafile backup set

channel c7: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 460801 through 486400

channel c7: starting piece 19 at 13-JUN-13

channel c8: finished piece 8 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_8_1_.BK tag=TAG20130613T110804 comment=NONE

channel c8: backup set complete, elapsed time: 00:00:04

channel c8: starting full datafile backup set

channel c8: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 486401 through 512000

channel c8: starting piece 20 at 13-JUN-13

channel c1: finished piece 15 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_15_1_.BK tag=TAG20130613T110804 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:02

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 512001 through 537600

channel c1: starting piece 21 at 13-JUN-13

channel c2: finished piece 16 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_16_1_.BK tag=TAG20130613T110804 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:02

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 537601 through 563200

channel c2: starting piece 22 at 13-JUN-13

channel c3: finished piece 17 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_17_1_.BK tag=TAG20130613T110804 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:02

channel c3: starting full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 563201 through 588800

channel c3: starting piece 23 at 13-JUN-13

channel c4: finished piece 18 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_18_1_.BK tag=TAG20130613T110804 comment=NONE

channel c4: backup set complete, elapsed time: 00:00:02

channel c4: starting full datafile backup set

channel c4: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 588801 through 614400

channel c4: starting piece 24 at 13-JUN-13

channel c5: finished piece 13 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_13_1_.BK tag=TAG20130613T110804 comment=NONE

channel c5: backup set complete, elapsed time: 00:00:04

channel c5: starting full datafile backup set

channel c5: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 614401 through 640000

channel c5: starting piece 25 at 13-JUN-13

channel c6: finished piece 14 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_14_1_.BK tag=TAG20130613T110804 comment=NONE

channel c6: backup set complete, elapsed time: 00:00:04

channel c6: starting full datafile backup set

channel c6: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 640001 through 665600

channel c6: starting piece 26 at 13-JUN-13

channel c1: finished piece 21 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_21_1_.BK tag=TAG20130613T110804 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:02

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 665601 through 691200

channel c1: starting piece 27 at 13-JUN-13

channel c2: finished piece 22 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_22_1_.BK tag=TAG20130613T110804 comment=NONE

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

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 691201 through 716800

channel c2: starting piece 28 at 13-JUN-13

channel c3: finished piece 23 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_23_1_.BK tag=TAG20130613T110804 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:02

channel c3: starting full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 716801 through 742400

channel c3: starting piece 29 at 13-JUN-13

channel c4: finished piece 24 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_24_1_.BK tag=TAG20130613T110804 comment=NONE

channel c4: backup set complete, elapsed time: 00:00:02

channel c4: starting full datafile backup set

channel c4: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 742401 through 768000

channel c4: starting piece 30 at 13-JUN-13

channel c7: finished piece 19 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_19_1_.BK tag=TAG20130613T110804 comment=NONE

channel c7: backup set complete, elapsed time: 00:00:05

channel c7: starting full datafile backup set

channel c7: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 768001 through 793600

channel c7: starting piece 31 at 13-JUN-13

channel c8: finished piece 20 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_20_1_.BK tag=TAG20130613T110804 comment=NONE

channel c8: backup set complete, elapsed time: 00:00:04

channel c8: starting full datafile backup set

channel c8: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 793601 through 819200

channel c8: starting piece 32 at 13-JUN-13

channel c1: finished piece 27 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_27_1_.BK tag=TAG20130613T110804 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:03

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 819201 through 844800

channel c1: starting piece 33 at 13-JUN-13

channel c2: finished piece 28 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_28_1_.BK tag=TAG20130613T110804 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:02

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 844801 through 870400

channel c2: starting piece 34 at 13-JUN-13

channel c3: finished piece 29 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_29_1_.BK tag=TAG20130613T110804 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:02

channel c3: starting full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 870401 through 896000

channel c3: starting piece 35 at 13-JUN-13

channel c4: finished piece 30 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_30_1_.BK tag=TAG20130613T110804 comment=NONE

channel c4: backup set complete, elapsed time: 00:00:02

channel c4: starting full datafile backup set

channel c4: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 896001 through 921600

channel c4: starting piece 36 at 13-JUN-13

channel c5: finished piece 25 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_25_1_.BK tag=TAG20130613T110804 comment=NONE

channel c5: backup set complete, elapsed time: 00:00:04

channel c5: starting full datafile backup set

channel c5: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 921601 through 947200

channel c5: starting piece 37 at 13-JUN-13

channel c6: finished piece 26 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_26_1_.BK tag=TAG20130613T110804 comment=NONE

channel c6: backup set complete, elapsed time: 00:00:04

channel c6: starting full datafile backup set

channel c6: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 947201 through 972800

channel c6: starting piece 38 at 13-JUN-13

channel c1: finished piece 33 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_33_1_.BK tag=TAG20130613T110804 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:02

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 972801 through 998400

channel c1: starting piece 39 at 13-JUN-13

channel c2: finished piece 34 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_34_1_.BK tag=TAG20130613T110804 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:02

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 998401 through 1024000

channel c2: starting piece 40 at 13-JUN-13

channel c3: finished piece 35 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_35_1_.BK tag=TAG20130613T110804 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:02

channel c3: starting full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1024001 through 1049600

channel c3: starting piece 41 at 13-JUN-13

channel c4: finished piece 36 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_36_1_.BK tag=TAG20130613T110804 comment=NONE

channel c4: backup set complete, elapsed time: 00:00:02

channel c4: starting full datafile backup set

channel c4: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1049601 through 1075200

channel c4: starting piece 42 at 13-JUN-13

channel c7: finished piece 31 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_31_1_.BK tag=TAG20130613T110804 comment=NONE

channel c7: backup set complete, elapsed time: 00:00:04

channel c7: starting full datafile backup set

channel c7: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1075201 through 1100800

channel c7: starting piece 43 at 13-JUN-13

channel c8: finished piece 32 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_32_1_.BK tag=TAG20130613T110804 comment=NONE

channel c8: backup set complete, elapsed time: 00:00:04

channel c8: starting full datafile backup set

channel c8: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1100801 through 1126400

channel c8: starting piece 44 at 13-JUN-13

channel c1: finished piece 39 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_39_1_.BK tag=TAG20130613T110804 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:03

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1126401 through 1152000

channel c1: starting piece 45 at 13-JUN-13

channel c2: finished piece 40 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_40_1_.BK tag=TAG20130613T110804 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:02

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1152001 through 1177600

channel c2: starting piece 46 at 13-JUN-13

channel c3: finished piece 41 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_41_1_.BK tag=TAG20130613T110804 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:03

channel c3: starting full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1177601 through 1203200

channel c3: starting piece 47 at 13-JUN-13

channel c4: finished piece 42 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_42_1_.BK tag=TAG20130613T110804 comment=NONE

channel c4: backup set complete, elapsed time: 00:00:03

channel c4: starting full datafile backup set

channel c4: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1203201 through 1228800

channel c4: starting piece 48 at 13-JUN-13

channel c5: finished piece 37 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_37_1_.BK tag=TAG20130613T110804 comment=NONE

channel c5: backup set complete, elapsed time: 00:00:06

channel c5: starting full datafile backup set

channel c5: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1228801 through 1254400

channel c5: starting piece 49 at 13-JUN-13

channel c6: finished piece 38 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_38_1_.BK tag=TAG20130613T110804 comment=NONE

channel c6: backup set complete, elapsed time: 00:00:05

channel c6: starting full datafile backup set

channel c6: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1254401 through 1280000

channel c6: starting piece 50 at 13-JUN-13

channel c1: finished piece 45 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_45_1_.BK tag=TAG20130613T110804 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:02

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1280001 through 1305600

channel c1: starting piece 51 at 13-JUN-13

channel c2: finished piece 46 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_46_1_.BK tag=TAG20130613T110804 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:02

channel c2: starting full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

backing up blocks 1305601 through 1310720

channel c2: starting piece 52 at 13-JUN-13

channel c3: finished piece 47 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_47_1_.BK tag=TAG20130613T110804 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:02

channel c4: finished piece 48 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_48_1_.BK tag=TAG20130613T110804 comment=NONE

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

channel c7: finished piece 43 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_43_1_.BK tag=TAG20130613T110804 comment=NONE

channel c7: backup set complete, elapsed time: 00:00:04

channel c8: finished piece 44 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_44_1_.BK tag=TAG20130613T110804 comment=NONE

channel c8: backup set complete, elapsed time: 00:00:03

channel c5: finished piece 49 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_49_1_.BK tag=TAG20130613T110804 comment=NONE

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

channel c6: finished piece 50 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_50_1_.BK tag=TAG20130613T110804 comment=NONE

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

channel c1: finished piece 51 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_51_1_.BK tag=TAG20130613T110804 comment=NONE

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

channel c2: finished piece 52 at 13-JUN-13

piece handle=C:\FILE5_0MOC318K_52_1_.BK tag=TAG20130613T110804 comment=NONE

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

Finished backup at 13-JUN-13

released channel: c1

released channel: c2

released channel: c3

released channel: c4

released channel: c5

released channel: c6

released channel: c7

released channel: c8

RMAN>

可以在log中看到确实用到了多个channel来备份单个数据文件。

增量备份的情况下：

RMAN>  run
2>  {
3>  allocate channel c1 type disk;
4>  allocate channel c2 type disk;
5>  allocate channel c3 type disk;
6>  allocate channel c4 type disk;
7>  allocate channel c5 type disk;
8>  allocate channel c6 type disk;
9>  allocate channel c7 type disk;
10>  allocate channel c8 type disk;
11>  backup as compressed backupset incremental level 1 datafile 5 section size 200M format 'c:\file5_%U_.bk';
12>  release channel c1;
13>  release channel c2;
14>  release channel c3;
15>  release channel c4;
16>  release channel c5;
17>  release channel c6;
18>  release channel c7;
19>  release channel c8;
20>  }

allocated channel: c1
channel c1: SID=11 device type=DISK

allocated channel: c2
channel c2: SID=68 device type=DISK

allocated channel: c3
channel c3: SID=133 device type=DISK

allocated channel: c4
channel c4: SID=196 device type=DISK

allocated channel: c5
channel c5: SID=72 device type=DISK

allocated channel: c6
channel c6: SID=132 device type=DISK

allocated channel: c7
channel c7: SID=191 device type=DISK

allocated channel: c8
channel c8: SID=13 device type=DISK

Starting backup at 13-JUN-13
channel c1: starting compressed incremental level 1 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF
channel c1: starting piece 1 at 13-JUN-13
channel c1: finished piece 1 at 13-JUN-13
piece handle=C:\FILE5_2AOC31G0_1_1_.BK tag=TAG20130613T111200 comment=NONE
channel c1: backup set complete, elapsed time: 00:02:27
Finished backup at 13-JUN-13

released channel: c1

released channel: c2

released channel: c3

released channel: c4

released channel: c5

released channel: c6

released channel: c7

released channel: c8

RMAN>

RMAN>

RMAN>

RMAN>

RMAN>

RMAN> run

2> {

3> allocate channel c1 type disk;

4> allocate channel c2 type disk;

5> allocate channel c3 type disk;

6> allocate channel c4 type disk;

7> allocate channel c5 type disk;

8> allocate channel c6 type disk;

9> allocate channel c7 type disk;

10> allocate channel c8 type disk;

11> backup as compressed backupset incremental level 1 datafile 5 section size 200M format 'c:\file5_%U_.bk';

12> release channel c1;

13> release channel c2;

14> release channel c3;

15> release channel c4;

16> release channel c5;

17> release channel c6;

18> release channel c7;

19> release channel c8;

20> }

allocated channel: c1

channel c1: SID=11 device type=DISK

allocated channel: c2

channel c2: SID=68 device type=DISK

allocated channel: c3

channel c3: SID=133 device type=DISK

allocated channel: c4

channel c4: SID=196 device type=DISK

allocated channel: c5

channel c5: SID=72 device type=DISK

allocated channel: c6

channel c6: SID=132 device type=DISK

allocated channel: c7

channel c7: SID=191 device type=DISK

allocated channel: c8

channel c8: SID=13 device type=DISK

Starting backup at 13-JUN-13

channel c1: starting compressed incremental level 1 datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=E:\ORA11G\APP\ORACLEUSER\ORADATA\ORA11G\TEST_BIG.DBF

channel c1: starting piece 1 at 13-JUN-13

channel c1: finished piece 1 at 13-JUN-13

piece handle=C:\FILE5_2AOC31G0_1_1_.BK tag=TAG20130613T111200 comment=NONE

channel c1: backup set complete, elapsed time: 00:02:27

Finished backup at 13-JUN-13

released channel: c1

released channel: c2

released channel: c3

released channel: c4

released channel: c5

released channel: c6

released channel: c7

released channel: c8

RMAN>

不管从log中分配的channel还是看备份出来的备份集，我们都看到没有使用多channel的并发。

该问题在RMAN-06183 When executing Level 1 Incremental backup and using Section Size [ID 1299598.1] 也说起了。只不过，我们演示的情况中甚至没有报错，还是一样不能在增量备份的时候，使用section size并发。

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Apr-2013***
Symptoms

When trying to run an rman incremental level 1 backup and using section size, errors are received:

mrma70p11 /opt/rccl/ora/bin->rman target / nocatalog
Recovery Manager: Release 11.1.0.7.0 - Production on Tue Feb 22 11:10:39 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: DWCORET (DBID=3153785040)
using target database control file instead of recovery catalog
RMAN> backup section size 300m incremental level 1 database;

Starting backup at 22-FEB-11
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=279 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Tivoli Data Protection for Oracle: version 5.2.0.0
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=285 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Tivoli Data Protection for Oracle: version 5.2.0.0
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=268 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Tivoli Data Protection for Oracle: version 5.2.0.0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/22/2011 11:11:16
RMAN-06183:  datafile or datafile copy +DWCORET_ORADATA/dwcoret/datafile/undo.359.742176923 (file number 3) larger than MAXSETSIZE

Cause

The functionality for performing an rman incremental leve1 1 or higher backup and using section size is not currently supported.

Solution

You cannot currently use these two rman features together.

This documentation bug has been filed because this limitation is not documented: 11813067.

This code bug has been filed because the error needs to be better indicate that this is not supported:  11813097.

This enhancement request has been filed because this functionality is requested in a future version of Oracle: 
11818263.

References

BUG:11813067 - NEED TO DOC SECTION SIZE & INCREMENTAL LEVEL 1 AND GREATER BACKUPS NOT SUPPORTED
BUG:11813097 - RMAN-6183 NEED BETTER ERROR FOR INCREMENTAL SECTION SIZE BACKUP NOT SUPPORTED

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later

Information in this document applies to any platform.

***Checked for relevance on 03-Apr-2013***

Symptoms

When trying to run an rman incremental level 1 backup and using section size, errors are received:

mrma70p11 /opt/rccl/ora/bin->rman target / nocatalog

Recovery Manager: Release 11.1.0.7.0 - Production on Tue Feb 22 11:10:39 2011

connected to target database: DWCORET (DBID=3153785040)

using target database control file instead of recovery catalog

RMAN> backup section size 300m incremental level 1 database;

Starting backup at 22-FEB-11

allocated channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: SID=279 device type=SBT_TAPE

channel ORA_SBT_TAPE_1: Tivoli Data Protection for Oracle: version 5.2.0.0

allocated channel: ORA_SBT_TAPE_2

channel ORA_SBT_TAPE_2: SID=285 device type=SBT_TAPE

channel ORA_SBT_TAPE_2: Tivoli Data Protection for Oracle: version 5.2.0.0

allocated channel: ORA_SBT_TAPE_3

channel ORA_SBT_TAPE_3: SID=268 device type=SBT_TAPE

channel ORA_SBT_TAPE_3: Tivoli Data Protection for Oracle: version 5.2.0.0

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

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

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

RMAN-03002: failure of backup command at 02/22/2011 11:11:16

RMAN-06183: datafile or datafile copy +DWCORET_ORADATA/dwcoret/datafile/undo.359.742176923 (file number 3) larger than MAXSETSIZE

Cause

The functionality for performing an rman incremental leve1 1 or higher backup and using section size is not currently supported.

Solution

You cannot currently use these two rman features together.

This documentation bug has been filed because this limitation is not documented: 11813067.

This code bug has been filed because the error needs to be better indicate that this is not supported: 11813097.

This enhancement request has been filed because this functionality is requested in a future version of Oracle:

11818263.

References

BUG:11813067 - NEED TO DOC SECTION SIZE & INCREMENTAL LEVEL 1 AND GREATER BACKUPS NOT SUPPORTED

BUG:11813097 - RMAN-6183 NEED BETTER ERROR FOR INCREMENTAL SECTION SIZE BACKUP NOT SUPPORTED

2013-06-23 update：

该问题已经在12c中修复，rman中的增量备份特性已经能和section size一起配合使用，详见惜纷飞的文章《ORACLE 12C RMAN 功能增强》

增量备份无法使用section size参数

相关文章

利用Oracle存储过程发送邮件

升级数据库时报错Text file busy

另一种找asm disk dir的方法

发表回复 取消回复

发表回复取消回复