问题描述
你好,
我已经做了一些测试来尝试并行最大数据库的最佳备份,我想知道是否有可能用maxpiecesize在多个通道上并行备份 (多个备份) 的备份,因为我们的SBT媒体仅限于190 Go (如果备份在多个媒体):
将设备类型 “SBT_TAPE” 并行性4备份类型配置为BACKUPSET;
截面尺寸:
-在多个通道上可以,但是此属性是带有calcul的通道数,例如在bigfile中:
表空间大小/截面大小 = 通道数
但是,如果50% 使用tbablespace,它将为100% 属性通道,并且50% 通道将不备份任何内容。
最大分段:
-这更好,因为它不给通道保存 “什么都没有”,但是如果我有4个通道,更大的表空间将只备份在同一个通道上,当其他文件完成备份时,只有一个通道被用来完成最大的所以
-它打开了文件的通道c1保存MAXPIECESIZE
-关闭通道c1
-打开文件的通道c1 save MAXPIECESIZE
-关闭通道c1
-打开文件的通道c1 save MAXPIECESIZE
-关闭通道c1
所以没有使用通道c2、c3、c4 ....
有办法把这个比喻成什么样子吗?
谢谢你的帮助
我已经做了一些测试来尝试并行最大数据库的最佳备份,我想知道是否有可能用maxpiecesize在多个通道上并行备份 (多个备份) 的备份,因为我们的SBT媒体仅限于190 Go (如果备份在多个媒体):
将设备类型 “SBT_TAPE” 并行性4备份类型配置为BACKUPSET;
截面尺寸:
-在多个通道上可以,但是此属性是带有calcul的通道数,例如在bigfile中:
表空间大小/截面大小 = 通道数
但是,如果50% 使用tbablespace,它将为100% 属性通道,并且50% 通道将不备份任何内容。
最大分段:
-这更好,因为它不给通道保存 “什么都没有”,但是如果我有4个通道,更大的表空间将只备份在同一个通道上,当其他文件完成备份时,只有一个通道被用来完成最大的所以
-它打开了文件的通道c1保存MAXPIECESIZE
-关闭通道c1
-打开文件的通道c1 save MAXPIECESIZE
-关闭通道c1
-打开文件的通道c1 save MAXPIECESIZE
-关闭通道c1
所以没有使用通道c2、c3、c4 ....
有办法把这个比喻成什么样子吗?
谢谢你的帮助
专家解答
这不只是为您的截面尺寸选择合适的乘数的情况吗?
例如,我做了:
所以我将有4的并行性。
我有一个表空间LARGETS,分配的文件大小为16G,有大约1.5G段。
因此,只要我选择一个小于1.5的截面尺寸,负载就应该分散在4个通道上。
是的,我最终会得到一些 “空” (通常是64k) 块,但我仍然得到并行性4,文件的上限为部分大小
例如,我做了:
RMAN> configure device type disk parallelism 4; using target database control file instead of recovery catalog old RMAN configuration parameters: CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET; new RMAN configuration parameters: CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET; new RMAN configuration parameters are successfully stored
所以我将有4的并行性。
我有一个表空间LARGETS,分配的文件大小为16G,有大约1.5G段。
因此,只要我选择一个小于1.5的截面尺寸,负载就应该分散在4个通道上。
RMAN> backup tablespace largets section size 300m; Starting backup at 25-SEP-19 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=865 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=983 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=1108 device type=DISK allocated channel: ORA_DISK_4 channel ORA_DISK_4: SID=1228 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1 through 38400 channel ORA_DISK_1: starting piece 1 at 25-SEP-19 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 38401 through 76800 channel ORA_DISK_2: starting piece 2 at 25-SEP-19 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 76801 through 115200 channel ORA_DISK_3: starting piece 3 at 25-SEP-19 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 115201 through 153600 channel ORA_DISK_4: starting piece 4 at 25-SEP-19 channel ORA_DISK_1: finished piece 1 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_1_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 153601 through 192000 channel ORA_DISK_1: starting piece 5 at 25-SEP-19 channel ORA_DISK_2: finished piece 2 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_2_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:05 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 192001 through 230400 channel ORA_DISK_2: starting piece 6 at 25-SEP-19 channel ORA_DISK_3: finished piece 3 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_3_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:05 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 230401 through 268800 channel ORA_DISK_3: starting piece 7 at 25-SEP-19 channel ORA_DISK_1: finished piece 5 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_5_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 268801 through 307200 channel ORA_DISK_1: starting piece 8 at 25-SEP-19 channel ORA_DISK_2: finished piece 6 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_6_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 307201 through 345600 channel ORA_DISK_2: starting piece 9 at 25-SEP-19 channel ORA_DISK_4: finished piece 4 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_4_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:06 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 345601 through 384000 channel ORA_DISK_4: starting piece 10 at 25-SEP-19 channel ORA_DISK_1: finished piece 8 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_8_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 384001 through 422400 channel ORA_DISK_1: starting piece 11 at 25-SEP-19 channel ORA_DISK_3: finished piece 7 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_7_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 422401 through 460800 channel ORA_DISK_3: starting piece 12 at 25-SEP-19 channel ORA_DISK_2: finished piece 9 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_9_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 460801 through 499200 channel ORA_DISK_2: starting piece 13 at 25-SEP-19 channel ORA_DISK_4: finished piece 10 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_10_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 499201 through 537600 channel ORA_DISK_4: starting piece 14 at 25-SEP-19 channel ORA_DISK_1: finished piece 11 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_11_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 537601 through 576000 channel ORA_DISK_1: starting piece 15 at 25-SEP-19 channel ORA_DISK_3: finished piece 12 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_12_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 576001 through 614400 channel ORA_DISK_3: starting piece 16 at 25-SEP-19 channel ORA_DISK_2: finished piece 13 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_13_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 614401 through 652800 channel ORA_DISK_2: starting piece 17 at 25-SEP-19 channel ORA_DISK_4: finished piece 14 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_14_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 652801 through 691200 channel ORA_DISK_4: starting piece 18 at 25-SEP-19 channel ORA_DISK_1: finished piece 15 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_15_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 691201 through 729600 channel ORA_DISK_1: starting piece 19 at 25-SEP-19 channel ORA_DISK_3: finished piece 16 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_16_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 729601 through 768000 channel ORA_DISK_3: starting piece 20 at 25-SEP-19 channel ORA_DISK_1: finished piece 19 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_19_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 768001 through 806400 channel ORA_DISK_1: starting piece 21 at 25-SEP-19 channel ORA_DISK_2: finished piece 17 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_17_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 806401 through 844800 channel ORA_DISK_2: starting piece 22 at 25-SEP-19 channel ORA_DISK_4: finished piece 18 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_18_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 844801 through 883200 channel ORA_DISK_4: starting piece 23 at 25-SEP-19 channel ORA_DISK_1: finished piece 21 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_21_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 883201 through 921600 channel ORA_DISK_1: starting piece 24 at 25-SEP-19 channel ORA_DISK_3: finished piece 20 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_20_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 921601 through 960000 channel ORA_DISK_3: starting piece 25 at 25-SEP-19 channel ORA_DISK_2: finished piece 22 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_22_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 960001 through 998400 channel ORA_DISK_2: starting piece 26 at 25-SEP-19 channel ORA_DISK_4: finished piece 23 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_23_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 998401 through 1036800 channel ORA_DISK_4: starting piece 27 at 25-SEP-19 channel ORA_DISK_1: finished piece 24 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_24_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1036801 through 1075200 channel ORA_DISK_1: starting piece 28 at 25-SEP-19 channel ORA_DISK_2: finished piece 26 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_26_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1075201 through 1113600 channel ORA_DISK_2: starting piece 29 at 25-SEP-19 channel ORA_DISK_3: finished piece 25 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_25_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1113601 through 1152000 channel ORA_DISK_3: starting piece 30 at 25-SEP-19 channel ORA_DISK_1: finished piece 28 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_28_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1152001 through 1190400 channel ORA_DISK_1: starting piece 31 at 25-SEP-19 channel ORA_DISK_4: finished piece 27 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_27_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1190401 through 1228800 channel ORA_DISK_4: starting piece 32 at 25-SEP-19 channel ORA_DISK_2: finished piece 29 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_29_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1228801 through 1267200 channel ORA_DISK_2: starting piece 33 at 25-SEP-19 channel ORA_DISK_3: finished piece 30 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_30_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1267201 through 1305600 channel ORA_DISK_3: starting piece 34 at 25-SEP-19 channel ORA_DISK_1: finished piece 31 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_31_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1305601 through 1344000 channel ORA_DISK_1: starting piece 35 at 25-SEP-19 channel ORA_DISK_4: finished piece 32 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_32_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1344001 through 1382400 channel ORA_DISK_4: starting piece 36 at 25-SEP-19 channel ORA_DISK_2: finished piece 33 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_33_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1382401 through 1420800 channel ORA_DISK_2: starting piece 37 at 25-SEP-19 channel ORA_DISK_3: finished piece 34 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_34_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1420801 through 1459200 channel ORA_DISK_3: starting piece 38 at 25-SEP-19 channel ORA_DISK_1: finished piece 35 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_35_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1459201 through 1497600 channel ORA_DISK_1: starting piece 39 at 25-SEP-19 channel ORA_DISK_4: finished piece 36 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_36_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1497601 through 1536000 channel ORA_DISK_4: starting piece 40 at 25-SEP-19 channel ORA_DISK_2: finished piece 37 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_37_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1536001 through 1574400 channel ORA_DISK_2: starting piece 41 at 25-SEP-19 channel ORA_DISK_3: finished piece 38 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_38_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1574401 through 1612800 channel ORA_DISK_3: starting piece 42 at 25-SEP-19 channel ORA_DISK_1: finished piece 39 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_39_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1612801 through 1651200 channel ORA_DISK_1: starting piece 43 at 25-SEP-19 channel ORA_DISK_2: finished piece 41 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_41_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1651201 through 1689600 channel ORA_DISK_2: starting piece 44 at 25-SEP-19 channel ORA_DISK_4: finished piece 40 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_40_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1689601 through 1728000 channel ORA_DISK_4: starting piece 45 at 25-SEP-19 channel ORA_DISK_1: finished piece 43 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_43_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1728001 through 1766400 channel ORA_DISK_1: starting piece 46 at 25-SEP-19 channel ORA_DISK_3: finished piece 42 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_42_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1766401 through 1804800 channel ORA_DISK_3: starting piece 47 at 25-SEP-19 channel ORA_DISK_2: finished piece 44 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_44_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1804801 through 1843200 channel ORA_DISK_2: starting piece 48 at 25-SEP-19 channel ORA_DISK_4: finished piece 45 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_45_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1843201 through 1881600 channel ORA_DISK_4: starting piece 49 at 25-SEP-19 channel ORA_DISK_1: finished piece 46 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_46_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1881601 through 1920000 channel ORA_DISK_1: starting piece 50 at 25-SEP-19 channel ORA_DISK_2: finished piece 48 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_48_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1920001 through 1958400 channel ORA_DISK_2: starting piece 51 at 25-SEP-19 channel ORA_DISK_3: finished piece 47 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_47_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_3: starting full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1958401 through 1996800 channel ORA_DISK_3: starting piece 52 at 25-SEP-19 channel ORA_DISK_1: finished piece 50 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_50_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 1996801 through 2035200 channel ORA_DISK_1: starting piece 53 at 25-SEP-19 channel ORA_DISK_4: finished piece 49 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_49_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_4: starting full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 2035201 through 2073600 channel ORA_DISK_4: starting piece 54 at 25-SEP-19 channel ORA_DISK_2: finished piece 51 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_51_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_2: starting full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00013 name=X:\ORADATA\DB18\PDB1\LARGETS.DBF backing up blocks 2073601 through 2076160 channel ORA_DISK_2: starting piece 55 at 25-SEP-19 channel ORA_DISK_3: finished piece 52 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_52_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_1: finished piece 53 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_53_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_4: finished piece 54 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_54_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_2: finished piece 55 at 25-SEP-19 piece handle=X:\ORACLE\BKP\1KUCL963_55_1 tag=TAG20190925T131651 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01 Finished backup at 25-SEP-19 RMAN>
是的,我最终会得到一些 “空” (通常是64k) 块,但我仍然得到并行性4,文件的上限为部分大小
文章转载自ASKTOM,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




