Home > Oracle > 正文

RMAN-00600: internal error, arguments [13205]

     备份的时候看到有个错误,点开一看是这个信息RMAN-00600: internal error, arguments  [13205] 国内百度一搜搜到有用的信息并不多,顺手去metalink搜了下,原来是个bug。

    bug id:6325947

    出现在oracle10.2.0.2之后,一直到10.2.0.5才被修复,临时解决方法是在备份中使用filesperset 且值为1 。

    由于现有环境的备份参数里filesperset值是32,更改为1后进行操作并备份测试,果然没问题了。因为是第三方备份软件调用rman备份的,所以日志里部分信息请过滤,仅作参考

修改之前的备份日志

-----------------

Client : jgdb01
------------------------------------------------------------
Rman Script:
[CONFIGURE CONTROLFILE AUTOBACKUP ON;
run {
allocate channel ch1 type 'sbt_tape' connect sys/********@orcl1
PARMS="SBT_LIBRARY=/opt/simpana/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine= -chg 1:1 -rac 15 -cn jgdb01 -vm Instance001)"
TRACE 0;
allocate channel ch2 type 'sbt_tape' connect sys/********@orcl2
PARMS="SBT_LIBRARY=/opt/simpana/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch2,ThreadCommandLine= -chg 2:1 -rac 16 -cn jgdb02 -cs CVBackup)"
TRACE 0;
send "BACKUP -jm 45 -a 2:121 -cl 167 -ins 28 -at 80 -j 12556 -jt 12556:4:1 -bal 1 -rcp 0 -ms 2 -data -ma 96 -hn jgdb01";
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
sql "alter session set optimizer_mode=RULE";
backup
incremental level = 0
filesperset = 32
format='12556_%d_%U'
database
;
}
exit;
]
Rman Log:[
Recovery Manager: Release 10.2.0.4.0 - Production on Sat Oct 15 04:15:38 2016
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
RMAN>
connected to target database: ORCL (DBID=1294175266)
using target database control file instead of recovery catalog
RMAN>
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>
allocated channel: ch1
channel ch1: sid=2096 instance=orcl1 devtype=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 10.0.0(BUILD116)
allocated channel: ch2
channel ch2: sid=979 instance=orcl2 devtype=SBT_TAPE
channel ch2: CommVault Systems for Oracle: Version 10.0.0(BUILD116)
sent command to channel: ch1
sent command to channel: ch2
sql statement: alter session set optimizer_mode=RULE
Starting backup at Oct 15 2016 04:15:48
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 10/15/2016 04:16:51
RMAN-00600: internal error, arguments [13205] [] [] [] []
RMAN>
Recovery Manager complete.

修改之后的备份日志

-----------------

Rman Script:
[run {
allocate channel ch1 type 'sbt_tape' connect sys/********@orcl1
PARMS="SBT_LIBRARY=/opt/simpana/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine= -chg 1:1 -rac 15 -cn jgdb01 -vm Instance001)"
TRACE 0;
allocate channel ch2 type 'sbt_tape' connect sys/********@orcl2
PARMS="SBT_LIBRARY=/opt/simpana/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch2,ThreadCommandLine= -chg 2:1 -rac 16 -cn jgdb02 -cs CVBackup)"
TRACE 0;
send "BACKUP -jm 45 -a 2:121 -cl 167 -ins 28 -at 80 -j 12611 -jt 12611:4:1 -bal 1 -rcp 0 -ms 2 -data -ma 96 -hn jgdb01";
backup
incremental level = 0
filesperset = 1
database
include current controlfile ;
}
exit;
]
Rman Log:[
Recovery Manager: Release 10.2.0.4.0 - Production on Mon Oct 17 16:49:57 2016
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
RMAN>
connected to target database: ORCL (DBID=1294175266)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19>
allocated channel: ch1
channel ch1: sid=1611 instance=orcl1 devtype=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 10.0.0(BUILD116)
allocated channel: ch2
channel ch2: sid=1277 instance=orcl2 devtype=SBT_TAPE
channel ch2: CommVault Systems for Oracle: Version 10.0.0(BUILD116)
sent command to channel: ch1
sent command to channel: ch2
Starting backup at Oct 17 2016 16:50:03
channel ch1: starting incremental level 0 datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00002 name=+HDS/orcl/datafile/undotbs1.342.814109189
channel ch1: starting piece 1 at Oct 17 2016 16:51:15
channel ch2: starting incremental level 0 datafile backupset
channel ch2: specifying datafile(s) in backupset
input datafile fno=00005 name=+HDS/orcl/datafile/undotbs2.256.814080923
channel ch2: starting piece 1 at Oct 17 2016 17:00:05
channel ch1: finished piece 1 at Oct 17 2016 16:54:11
piece handle=flrijns3_1_1 tag=TAG20161017T165043 comment=API Version 2.0,MMS Version 10.0.0.116
channel ch1: backup set complete, elapsed time: 00:02:56
channel ch1: starting incremental level 0 datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00020 name=+HDS/orcl/datafile/dt_sys_dat.257.814081289
channel ch1: starting piece 1 at Oct 17 2016 16:54:11
channel ch2: finished piece 1 at Oct 17 2016 17:03:00
piece handle=fmrijocl_1_1 tag=TAG20161017T165043 comment=API Version 2.0,MMS Version 10.0.0.116
channel ch2: backup set complete, elapsed time: 00:02:55
channel ch2: starting incremental level 0 datafile backupset
channel ch2: specifying datafile(s) in backupset
input datafile fno=00022 name=+HDS/orcl/datafile/dt_tra_dat.258.814081643
channel ch2: starting piece 1 at Oct 17 2016 17:03:00
channel ch2: finished piece 1 at Oct 17 2016 17:05:26
piece handle=forijoi4_1_1 tag=TAG20161017T165043 comment=API Version 2.0,MMS Version 10.0.0.116
channel ch2: backup set complete, elapsed time: 00:02:26
channel ch2: starting incremental level 0 datafile backupset
channel ch2: specifying datafile(s) in backupset
input datafile fno=00068 name=+HDS/orcl/datafile/ntcis.330.814104799
channel ch2: starting piece 1 at Oct 17 2016 17:05:26
channel ch1: finished piece 1 at Oct 17 2016 16:56:38
piece handle=fnrijo1j_1_1 tag=TAG20161017T165043 comment=API Version 2.0,MMS Version 10.0.0.116
channel ch1: backup set complete, elapsed time: 00:02:27
channel ch1: starting incremental level 0 datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00087 name=+HDS/orcl/datafile/ntcis_drv_a.397.814117971
channel ch1: starting piece 1 at Oct 17 2016 16:56:38
channel ch2: finished piece 1 at Oct 17 2016 17:08:32

THE END

上一篇:Oracle ORA-1691的报错处理
下一篇:Oracle安装目录权限不能错,chmod chown
关于数据库用户登录缓慢的问题

关于数据库用户登录缓慢的问题

数据库RAC 磁盘组磁盘调整

数据库RAC 磁盘组磁盘调整

CRS-2730集群资源DG无法删除

CRS-2730集群资源DG无法删除

oracle 安装设置shmmall shmmax 参数

oracle 安装设置shmmall shmmax 参数

XX平台数据库无法启动CRS-2674  HAIP

XX平台数据库无法启动CRS-2674 HAIP

某数据库日常检查故障处理报告

某数据库日常检查故障处理报告

kernel.shmmax参数详解

kernel.shmmax参数详解

发表评论

昵称
邮箱
网址

沙发空闲中,快来抢!