暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Oracle RMAN最大分段与截面尺寸

ASKTOM 2019-09-24
418

问题描述

你好,
我已经做了一些测试来尝试并行最大数据库的最佳备份,我想知道是否有可能用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 ....

有办法把这个比喻成什么样子吗?


谢谢你的帮助

专家解答

这不只是为您的截面尺寸选择合适的乘数的情况吗?

例如,我做了:

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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论