[20171225]RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect.txt

最新推荐文章于 2024-04-24 15:20:33 发布

weixin_33829657

最新推荐文章于 2024-04-24 15:20:33 发布

阅读量121

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/lfree/p/8116724.html

本文通过三个测试案例详细解析了在Oracle RMAN备份过程中出现的RMAN-06808错误：SECTIONSIZE不能与MAXPIECESIZE同时使用的问题。展示了如何避免这两个互斥选项导致的备份失败。

[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存在冲突.