ORA-00600 ktfbhget-4

am196

OS Red Hat Enterprise Linux Server release 5.3
Database 11gR2 11.2.0.1.0

服务器断电，小伙伴看到数据库有些文件的状态是RECOVER
没有进行recover datafile
直接把为用alter database open resetlogs;打开的

现在往表里面插入资料，报ora 600错误
有些表用desc tablename可以显示信息。
select 该table的时候报找不到该对像，附件相关的trc信息。

重建了该数据库的数据字典还是不行。


ORA-06512: ine 1
Sat Sep 14 11:18:35 2013
Errors in file /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/trace/dcntrjx_ora_27703.trc  (incident=80326):
ORA-00600: , : [ktfbhget-1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/incident/incdir_80326/dcntrjx_ora_27703_i80326.trc
Sat Sep 14 11:18:38 2013
Errors in file /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/trace/dcntrjx_w000_1508.trc  (incident=80308):
ORA-00600: , : [ktfbhget-1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/incident/incdir_80308/dcntrjx_w000_1508_i80308.trc
Sat Sep 14 11:18:38 2013
Trace dumping is performing id=[cdmp_20130914111838]
Sat Sep 14 11:18:39 2013
Sweep [inc][80326]: completed
Sweep [inc][80308]: completed
Sweep [inc2][80326]: completed
Errors in file /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/trace/dcntrjx_w000_1508.trc:
ORA-00600: , : [ktfbhget-1], [], [], [], [], [], [], [], [], [], [], []
Trace dumping is performing id=[cdmp_20130914111841]
Sat Sep 14 11:19:39 2013
Sweep [inc2][80308]: completed
Sat Sep 14 11:22:22 2013
Errors in file /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/trace/dcntrjx_ora_2157.trc  (incident=80309):
ORA-00600: , : [ktfbhget-4], [7], [11], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/incident/incdir_80309/dcntrjx_ora_2157_i80309.trc
Sat Sep 14 11:22:25 2013
Trace dumping is performing id=[cdmp_20130914112225]
Sat Sep 14 11:22:27 2013
Sweep [inc][80309]: completed
Sweep [inc2][80309]: completed
Sat Sep 14 11:33:38 2013
Thread 1 advanced to log sequence 147 (LGWR switch)
  Current log# 3 seq# 147 mem# 0: /u01/app/oracle/oradata/dcntrjx/redo03.log
Sat Sep 14 11:33:38 2013
Archived Log entry 6744 added for thread 1 sequence 146 ID 0x3f6a6554 dest 1:
Sat Sep 14 11:51:28 2013
DM00 started with pid=44, OS id=5294, job POS.SYS_EXPORT_SCHEMA_01
Errors in file /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/trace/dcntrjx_dm00_5294.trc  (incident=80356):
ORA-00600: internal error code, arguments: [ktfbhget-4], [7], [11], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/incident/incdir_80356/dcntrjx_dm00_5294_i80356.trc
Sat Sep 14 11:51:33 2013
Trace dumping is performing id=[cdmp_20130914115133]
Sat Sep 14 11:51:34 2013
Errors in file /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/trace/dcntrjx_w000_4671.trc  (incident=80332):
ORA-00600: , : [ktfbhget-1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/incident/incdir_80332/dcntrjx_w000_4671_i80332.trc
Sat Sep 14 11:51:35 2013
Sweep [inc][80356]: completed
Sweep [inc][80332]: completed
Sweep [inc2][80356]: completed
Errors in file /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/trace/dcntrjx_w000_4671.trc:
ORA-00600: , : [ktfbhget-1], [], [], [], [], [], [], [], [], [], [], []
Trace dumping is performing id=[cdmp_20130914115137]
Sat Sep 14 11:52:35 2013
Sweep [inc2][80332]: completed
Sat Sep 14 13:07:12 2013
Errors in file /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/trace/dcntrjx_ora_2157.trc  (incident=80310):
ORA-00600: , : [ktfbhget-4], [7], [11], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/incident/incdir_80310/dcntrjx_ora_2157_i80310.trc

Maclean Liu(刘相兵

11.2.0.1.0 + Linux 2.6.18-128.el5


Dump continued from file: /u01/app/oracle/diag/rdbms/dcntrjx/dcntrjx/trace/dcntrjx_ora_2157.trc
ORA-00600: 内部错误代码, 参数: [ktfbhget-4], [7], [11], [], [], [], [], [], [], [], [], []


---- Current SQL Statement for this session (sql_id=10vm0760akq1b) -----
INSERT  INTO "YS_USER" "A1"


stack call  ktfbfsearch1=>ktfbhget=>ksesin=>kgesinv

Maclean Liu(刘相兵

--------------------------------------------+-----------------------------------+-------------------------+
| Id  | Operation                 | Name    | Rows  | Bytes | Cost  | Time      |  TQ  |IN-OUT|PQ Distrib |
--------------------------------------------+-----------------------------------+-------------------------+
| 0   | INSERT STATEMENT          |         |       |       |     7 |           |      |      |           |
| 1   |  LOAD TABLE CONVENTIONAL  |         |       |       |       |           |      |      |           |
| 2   |   REMOTE                  | YS_USER |   657 |  152K |     7 |  00:00:01 |!     | R->S |           |
--------------------------------------------+-----------------------------------+-------------------------+

YS_USER 是远程表

   SO: 0x600dd6420, type: 4, owner: 0x5c0d6cad8, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
     proc=0x5c0d6cad8, name=session, file=ksu.h LINE:11467, pg=0
    (session) sid: 153 ser: 13 trans: 0x611a97780, creator: 0x5c0d6cad8
              flags: (0x45) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
              flags2: (0x40008) -/-
              DID: , short-term DID:
              txn branch: 0x5d20cb250
              oct: 2, prv: 0, sql: 0x64fd2c850, psql: 0x64fd2c850, user: 85/POS
    ksuxds FALSE at location: 0
    service name: dcntrjx
    client details:
      O/S info: user: oracle, term: , ospid: 11724
      machine: jxpos program: oracle@jxpos (TNS V1-V3)
      application name: oracle@jxpos (TNS V1-V3), hash value=1791878129
    Current Wait Stack:
      Not in wait; last wait ended 2.143215 sec ago
    Wait State:
      fixed_waits=0 flags=0x21 boundary=(nil)/-1
    Session Wait History:
        elapsed time of 2.143269 sec since last wait
     0: waited for 'Disk file operations I/O'
        FileOperation=0x2, fileno=0x3, filetype=0x2
        wait_id=90 seq_num=91 snap_id=1
        wait times: snap=0.000769 sec, exc=0.000769 sec, total=0.000769 sec
        wait times: max=infinite
        wait counts: calls=0 os=0
        occurred after 0.006169 sec of elapsed time
     1: waited for 'db file sequential read'
        file#=0x1, block#=0x12dee, blocks=0x1
        wait_id=89 seq_num=90 snap_id=1
        wait times: snap=0.000062 sec, exc=0.000062 sec, total=0.000062 sec
        wait times: max=infinite
        wait counts: calls=0 os=0
        occurred after 0.001124 sec of elapsed time
               
               
[root@vrh8 ~]# grep "seg/obj" dcntrjx_ora_2157_i80310.trc
seg/obj: 0x2c  csc: 0x05.5a96b836  itc: 2  flg: -  typ: 2 - INDEX
seg/obj: 0x11  csc: 0x05.5a96b836  itc: 2  flg: O  typ: 1 - DATA
seg/obj: 0x9  csc: 0x04.e24d7852  itc: 1  flg: -  typ: 2 - INDEX
seg/obj: 0x9  csc: 0x06.6aaf5f92  itc: 2  flg: -  typ: 2 - INDEX
seg/obj: 0x8  csc: 0x05.75424bd1  itc: 2  flg: -  typ: 1 - DATA



0x11     17
0x08     8


SQL> select name from obj$ where dataobj# in (17,8);

NAME
------------------------------
FILE$
UET$
SEG$
C_FILE#_BLOCK#



check :


analyze table sys.uet$ validate structure;
analyze table sys.FILE$ validate structure;
analyze table sys.SEG$ validate structure;
analyze cluster sys.C_FILE#_BLOCK# validate structure;

am196

Maclean Liu(刘相兵 发表于 2013-9-14 20:50
--------------------------------------------+-----------------------------------+------------------- ...

谢谢刘大，由于没有进行日志恢复而把数据库强制打开的，
在读取某些表的时候，读取到一半就会报错。
怕数据库不稳定，该数据库已经重建了。