【Oracle数据恢复】ORA-600 [kcbgcur_9]错误解析

ORA-600 [kcbgcur_9]错误的触发原理是 当 buffer被以某种类型顺序pin住以便防止内部死锁时,发现当前buffer被以错误的类型顺序pinned或者同一class中有重复的buffer;  也可能在更新只读表空间时与ORA-372错误一起发生。
该ORA-600 [kcbgcur_9]错误隶属于内核 buffer cache模块

这个ORA-600 [kcbgcur_9]错误一般有4个argument:

 

Arg [a] The Database Block Address (DBA)
Arg [b] The buffer class
Arg [c] Block class order mask
Arg [d] Block class checking mask

ORA-600 [kcbgcur_9]错误可能的影响是造成进程失败,但一般不会造成数据块的损坏

 

ORACLE SUPPORT对遇到该问题的主要建议是 检查所有的系统硬件 磁盘和内存, 以便保证不是底层系统造成了该问题。

 

一些可能造成ORA-600 [kcbgcur_9]的BUG:

 

 

NB Bug Fixed Description
10061015 11.2.0.2.3, 11.2.0.2.BP08, 11.2.0.3, 12.1.0.1 ORA-600 [ktfbhget:clsviol_kcbgcur_9] can occur on transported in tablespace
9407198 11.2.0.3, 12.1.0.1 “LOG ERRORS INTO” can cause ORA-600 [kcb***] or hang scenarios
9133601 12.1.0.1 ORA-600 [kcbgcur_9] from MERGE into an IOT
8459467 10.2.0.5, 11.2.0.1 ORA-600 [ktfbhget:clsviol_kcbgcur_9] attempting to ONLINE a tablespace
7644703 10.2.0.5, 11.2.0.1 OERI[kcbgcur_9] on alter tablespace online
6918892 11.2.0.1 ORA-600 [kcbgcur_9] from DML on sys.aud$
4917666 10.2.0.3, 11.1.0.6 OERI[kcbgcur_9] from type constructor
8778379 10.2.0.5 Fix event 10227 in 10.2 ORA-600[kcbgcur_3] or ORA-600[kcbgcur_9]
3655948 10.1.0.5, 10.2.0.1 OERI:kcbgcur_9 during disconnect with distributed transaction
3127116 9.2.0.5, 10.1.0.2 OERI:kcbgcur_9 during rollback of DML in ASSM segment
2771042 9.2.0.6, 10.1.0.2 OERI[kcbgcur_9] when performing DML on an IOT with an FGA policy
2747873 9.2.0.8, 10.1.0.2 DBMS_SPACE.UNUSED_SPACE may fail with OERI:kcbgcur_9
2722809 9.2.0.4, 10.1.0.2 OERI:kcbgcur_9 on direct load into AUTO space managed segment
2716406 10.1.0.2 OERI[kcbgcur_9] executing DBMS_SPACE.FREE_BLOCKS procedure on bitmapped segment
2619895 9.2.0.8, 10.1.0.2 Dump / OERI:kcbgcur_9 using PLSQL in SET clause of MERGE .. UPDATE
2392885 9.2.0.4, 10.1.0.2 Direct path load may fail with OERI:kcbgcur_9 / OERI:ktfduedel2
2311214 9.0.1.4, 9.2.0.2, 10.1.0.2 OERI:KCBGCUR_9 possible for SQL against IOT
1785175 9.2.0.2, 10.1.0.2 OERI:kcbgcur_9 from CLOB TO CHAR or BLOB TO RAW conversion
4124059 9.2.0.8 OERI[kcbget_31] / similar KCB errors in single instance
2202310 9.0.1.4, 9.2.0.1 OERI:KCBGCUR_9 possible from SMON dropping a rollback segment in locally managed tablespace
2035267 9.0.1.3, 9.2.0.1 OERI:KCBGCUR_9 possible during TEMP space operations
1804676 8.1.7.3, 9.0.1.3, 9.2.0.1 OERI:KCBGCUR_9 possible from ONLINE REBUILD INDEX with concurrent DML
1397075 8.1.7.2, 9.0.1.0 OERI:KCBGCUR_9 from SMON during temp seg cleanup for segment in read only LOCALLY MANAGED TABLESPACE

 

如果自己搞不定可以找ASKMACLEAN专业数据库修复团队成员帮您恢复!

 

 

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Comments

  1. Diagnosis: May occur with ORA-372 error when trying to update read-only tablespace or partition via direct load. Also reported with block corruption problems.The Buffer Class Order mask is a bitmap for each class of buffer.The values correspond to the classes of buffer which must NOT already be held when attempting to pin this buffer, including the current class.The Buffer Class Checking mask is a bitmap corresponding to the classes of buffers currently held by this process. This is what is being compared to the buffer class order mask. This internal error is identical to kcbget_33

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569