转载

解决ORA-00600[ktspgfb-1]一例

解决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数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 400-690-3643 备用电话： 18501767907 邮箱：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

正文到此结束