[20171225]RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect.txt
--//朋友拿我的一些例子来测试遇到的RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect问题.
$ oerr rman 6808
6808, 1, "SECTION SIZE cannot be used when piece limit is in effect"
// *Cause: The SECTION SIZE backup option was used together with the
// MAXPIECESIZE channel limit.
// These options are mutually exclusive, because they are independant
// methods of creating multiple backup pieces with one backup command.
// *Action: Use one option or the other, but not both.
--//实际上并不是我测试中disk rate设置问题,而是通道设置中存在maxpiecesize参数,在使用SECTION SIZE时存在冲突,
--//在我的测试环境演示看看.
1.环境:
SCOTT@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
2.测试一:
--//设置maxpiecesize=200M rate=50M:
RMAN> CONFIGURE CHANNEL device type disk maxpiecesize=200M rate=50M;
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 200 M RATE 50 M;
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 200 M RATE 50 M;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
RMAN> backup as backupset section size 10M datafile 6 format '/home/oracle/backup/data6_%U';
Starting backup at 2017-12-25 12:08:20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=119 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=132 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/25/2017 12:08:20
RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect
3.测试二:
RMAN> CONFIGURE CHANNEL device type disk maxpiecesize=200M ;
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 200 M;
new RMAN configuration parameters are successfully stored
RMAN> show channel ;
RMAN configuration parameters for database with db_unique_name BOOK are:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 200 M;
RMAN> backup as backupset section size 10M datafile 6 format '/home/oracle/backup/data6_%U';
Starting backup at 2017-12-25 14:51:23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=119 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=132 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/25/2017 14:51:24
RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect
--//显然MAXPIECESIZE设置与section size参数存在冲突.
4.测试三:
RMAN> CONFIGURE CHANNEL device type disk clear;
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 200 M;
old RMAN configuration parameters are successfully deleted
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
RMAN> show channel ;
RMAN configuration parameters for database with db_unique_name BOOK are:
RMAN configuration has no stored or default parameters
RMAN> backup as backupset section size 10M datafile 6 format '/home/oracle/backup/data6_%U';
Starting backup at 2017-12-25 14:53:14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=119 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=132 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/25/2017 14:53:14
RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect
--//退出rman然后进入就ok了.
RMAN> backup as backupset section size 10M datafile 6 format '/home/oracle/backup/data6_%U';
Starting backup at 2017-12-25 14:53:46
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=119 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=132 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=00006 name=/mnt/ramdisk/book/tea01.dbf
channel ORA_DISK_1: starting piece 1 at 2017-12-25 14:53:47
channel ORA_DISK_1: finished piece 1 at 2017-12-25 14:53:48
piece handle=/home/oracle/backup/data6_nrsn0unr_1_1 tag=TAG20171225T145347 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-12-25 14:53:48
Starting Control File and SPFILE Autobackup at 2017-12-25 14:53:48
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2017_12_25/o1_mf_s_963672828_f4183wgb_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2017-12-25 14:53:49
--//重复测试:
RMAN> CONFIGURE CHANNEL device type disk maxpiecesize=200M ;
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 200 M;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
RMAN> backup as backupset section size 10M datafile 6 format '/home/oracle/backup/data6_%U';
Starting backup at 2017-12-25 14:58:52
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=119 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=132 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/25/2017 14:58:52
RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect
--//这样应该可以证明是maxpiecesize参数与SECTION SIZE存在冲突.