遇到ora-00600 [6200]错误

最新推荐文章于 2025-08-06 15:38:43 发布

原创最新推荐文章于 2025-08-06 15:38:43 发布 · 711 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ora-00600 #6200

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文介绍如何通过trace文件定位并修复ORA-00600[6200]错误导致的索引损坏问题。首先从trace文件中获取错误信息，并转换为十六进制数，再查询DBA_OBJECTS视图找到对应损坏的索引名称，最后删除并重建该索引。

同事遇到ora-00600 [6200]错误,根据mos文章How to Identify the Corrupt Index following an ORA-600 [6200] error (文档 ID 1080640.6)得知,
可以通过报错时的trace文件得到是哪个索引有问题.

This example shows an exerpt from the trace file and how to determine
which index is corrupt.


1.  Excerpt from trace file:


  ksedmp: internal or fatal error
  ORA-00600: internal error code, arguments: [6200], [260], [262], [], [], [], [], []


  Block header dump: dba: 0x7b404757
   Object id on Block? Y
   seg/obj: 0x6190 csc: 0x00.4e537b5  itc: 2  flg: -typ: 2 - INDEX
       fsl: 0  fnx: 0x0 


2.  Note the value of the seg/obj field (i.e. 0x6190) and translate this to 
    a decimal number.
    $A==%x6190
    $show sym a
    A == 24976   Hex = 00006190  Octal = 00000060620


3.  Look up the object name in the DBA_OBJECTS view.


    SVRMGR> SELECT OBJECT_ID, OBJECT_NAME FROM DBA_OBJECTS
            WHERE DATA_OBJECT_ID  = '24976';


    DATA_OBJEC OBJECT_NAME                                                          
           
    ---------- ------------------------------------------------------
         24976 tab1_index5
   
    This is the index that you should drop and recreate. ------>>>额外注意:需要drop and recreate相关索引,不是rebuild相关索引.