解决ORA-00600[ktspgfb-1]一例，该案例的trace信息如下：
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []
Current SQL statement for this session:
INSERT INTO XX
---- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+0148 bl ksedst 102973B94 ?
ksfdmp+0018 bl 01FD34D8
kgerinv+00e8 bl _ptrgl
kgeasnmierr+004c bl kgerinv 042888888 ? 022488888 ?
102A8F8D0 ? 000000000 ?
000000000 ?
ktspgfblk+0240 bl kgeasnmierr 110006728 ? 1103FCB28 ?
102A8F9B0 ? 000000000 ?
000000180 ? 7000008730AC6E8 ?
000000307 ? 7000008230AD080 ?
ktspgfbs+01b0 bl ktspgfblk 000000058 ? 000001FE8 ?
022046489 ? 7000008829255B4 ?
FFFFFFFFFFF7030 ? 000000002 ?
FFFFFFFFFFF6DF0 ?
4448224200000000 ?
ktspfsrch+00a4 bl ktspgfbs 700000018BD8014 ? 000000000 ?
1101D65E0 ? FFFFFFFFFFF6FF8 ?
000000000 ? 000000000 ?
000000000 ?
ktspscan_bmb+01e4 bl ktspfsrch 100EC61D0 ? 000000000 ?
ktspgsp_cbk1+049c bl ktspscan_bmb 1009BA2C4 ?
ktspgsp_cbk+0098 bl ktspgsp_cbk1 00000000F ? 1101FB1D0 ?
700000877E9C140 ? 000000000 ?
0000000F0 ? 000000000 ?
000000000 ? 0000000C0 ?
kdtgsp+04d4 bl ktspgsp_cbk FFFFFFFFFFF7470 ? 110216600 ?
FFFFFFFFFFF7440 ? 110061460 ?
000000008 ? 1103DB9F0 ?
000000000 ? 110405C30 ?
kdtgsph+01ec bl kdtgsp 000000001 ? 1103D04D0 ?
kdtFlushBuf+03f8 bl kdtgsph FFFFFFFFFFF7600 ? 110006728 ?
insflush+01e8 bl kdtFlushBuf 70000088292C480 ?
insrow+01ec bl insflush 1103CEDF8 ? 000000000 ?
10009E1D4 ? FFFFFFFFFFF86F0 ?
ktspgfbs的含义为Get first level bitmap block for search
ktspgfblk的含义为KTSP Get first level bitmap block
发生该ORA-00600: internal error code, arguments: [ktspgfb-1]错误，基本可以认为是数据对象的基本信息一级位图块可能存在逻辑损坏/讹误。
针对该错误需要根据不同的数据对象类型制定不同的修复策略。
如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com
该ORA-00600[ktspgfb-1]错误的bug信息如下：
Bug# 7260057 See Note:7260057.8
Instance crash after failed RESIZE on NFS
Fixed: 10.2.0.5, 11.2
Bug# 2424226 See Note:2424226.8
OERI:[ktspgfb-1] possible after direct load of bitmap managed segment
Fixed: 9.0.1.4, 9.2.0.1
Bug# 2253389 See Note:2253389.8
ORA-00600:[KTSPGFB-1] possible after direct load of bitmap managed table
Fixed: 9.0.1.4, 9.2.0.1
Comment