ORA-00600 [kddummy_blkchk], [9], [1718652], [6110]
来源:互联网 发布:linux more 中查找 编辑:程序博客网 时间:2024/05/01 21:29
今天生产库日志错误ORA-00600故障分析
1.日志报错信息
Mon Mar 4 22:20:22 2013
Corrupt Block Found
TSN = 5, TSNAME = MAS_DATA
RFN = 9, BLK = 1718652, RDBA = 39467388
OBJN = 501517, OBJD = 501517, OBJECT = CUS_ACT_DTL_DEP_T, SUBOBJECT =
SEGMENT OWNER = MASTER, SEGMENT TYPE = Table Segment
Mon Mar 4 22:20:23 2013
Errors in file /oracle/admin/masdb/udump/masdb2_ora_1560762.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [9], [1718652], [6110], [], [], [], []
Mon Mar 4 22:20:28 2013
Trace dumping is performing id=[cdmp_20130304222028]
Mon Mar 4 22:20:28 2013
Doing block recovery for file 12 block 35429
Block recovery from logseq 24412, block 389718 to scn 23299993348
Mon Mar 4 22:20:28 2013
2.错误现象和特征
AIX 5310
oracle RAC 10.2.0.4
通过日志文件和trace文件发现如下:
(1)
[kddummy_blkchk], [9], [1718652], [6110],6110为检查代码
(2)导致错误发生时候的sql
UPDATE "CUS_ACT_DTL_DEP_T" "A1" SET "LSTBAL" = "A1"."AVA_BAL" WHERE "A1"."PROV_ORG"=:B1
(3)
Block Checking: DBA = 39467388, Block Type = KTB-managed data block
data header at 0x700000121eee094
kdbchk: the amount of space used is not equal to block size
这是由于在对表CUS_ACT_DTL_DEP_T进行大并发的更新操作时候,数据块的检查已使用的空间和块大小不一致而触发的错误。
确定为bug7662491
3.解决办法:
(1)安装补丁7662491
In order to prevent this issue install Patch 7662491
(2)升级到11.2.3版本
This issue is fixed in ?11.2.0.1 (Base Release)
1.日志报错信息
Mon Mar 4 22:20:22 2013
Corrupt Block Found
TSN = 5, TSNAME = MAS_DATA
RFN = 9, BLK = 1718652, RDBA = 39467388
OBJN = 501517, OBJD = 501517, OBJECT = CUS_ACT_DTL_DEP_T, SUBOBJECT =
SEGMENT OWNER = MASTER, SEGMENT TYPE = Table Segment
Mon Mar 4 22:20:23 2013
Errors in file /oracle/admin/masdb/udump/masdb2_ora_1560762.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [9], [1718652], [6110], [], [], [], []
Mon Mar 4 22:20:28 2013
Trace dumping is performing id=[cdmp_20130304222028]
Mon Mar 4 22:20:28 2013
Doing block recovery for file 12 block 35429
Block recovery from logseq 24412, block 389718 to scn 23299993348
Mon Mar 4 22:20:28 2013
2.错误现象和特征
AIX 5310
oracle RAC 10.2.0.4
通过日志文件和trace文件发现如下:
(1)
[kddummy_blkchk], [9], [1718652], [6110],6110为检查代码
(2)导致错误发生时候的sql
UPDATE "CUS_ACT_DTL_DEP_T" "A1" SET "LSTBAL" = "A1"."AVA_BAL" WHERE "A1"."PROV_ORG"=:B1
(3)
Block Checking: DBA = 39467388, Block Type = KTB-managed data block
data header at 0x700000121eee094
kdbchk: the amount of space used is not equal to block size
这是由于在对表CUS_ACT_DTL_DEP_T进行大并发的更新操作时候,数据块的检查已使用的空间和块大小不一致而触发的错误。
确定为bug7662491
3.解决办法:
(1)安装补丁7662491
In order to prevent this issue install Patch 7662491
(2)升级到11.2.3版本
This issue is fixed in ?11.2.0.1 (Base Release)
- ORA-00600 [kddummy_blkchk], [9], [1718652], [6110]
- ora-00600 [kddummy_blkchk]模拟与处理
- FLZYY数据库意外宕机恢复记录 ORA-00600 [kddummy_blkchk]
- ORA-00600 ORA-07445
- ora-00607 ora-00600
- ORA-00600: ORA-12012 ORA-08102解决
- ORA-12560、ORA-01033、ORA-00600
- Oracle ORA-01034,ORA-27101,ORA-00600
- ORA-00600 ORA-01565 ORA-27046
- ora-00600
- ORA-00600
- ORA 00600
- oracle ORA-00600,ORA-01033
- ORA-00607 ORA-00600解决方法
- ORA Error Solutions——ORA-00020 ORA-00257 ORA-00600 ORA-01012 ORA-01031 ORA-01102
- ora-00600 [1236] & ora-00600 [16365] & ora-04031
- ora-01595 ora-00607 ora-00600错误解决方法
- oracle数据库错误:ORA-01033、ORA-00600、ORA-01589
- highchart插件属性说明
- 数组快速去重复数据方法
- java与C++的区别
- Android ViewPager多页面滑动切换以及动画效果
- debug 输出 以及宏定义
- ORA-00600 [kddummy_blkchk], [9], [1718652], [6110]
- java中this用法注意点
- MYSQL连接数过大瞬间断开的解决办法
- SQL Server高级内容之子查询和表链接
- Android4.0框架–【Activity-Loader】
- HTK数据文件的字节顺序交换
- 串口
- 正向代理 反向代理
- 从别人写的 Object-C 中 Singleton (单例) 模式 中的一些理解