出现ora-600 12700错误

显示全部楼层 · 2010-10-8 09:28:51

客户数据库出现ORA-00600: internal error code, arguments: [12700], [3377611], [163225310], [3], [665353120], [25], [], []数据库有时要down掉
我看了metalink 相近的是说相关表的索引有问题而且trc文件会有SQL语句
但是我看了我的trc文件，没发现有相关SQL：出现的是如下信息---》
DUMP OF REDO FROM FILE '/arch/fif_db02/redo08_02.log'
Opcodes *.*
DBA's: (file # 34, block # 522474) thru (file # 22, block # 122335)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=3459156420=0xce2e89c4, Db Name='YSDB'
Activation ID=3459182276=0xce2eeec4
Control Seq=1861559=0x1c67b7, File size=4194304=0x400000
File Number=19, Blksiz=512, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000050430, SCN 0x0b50d0c38fc1-0xffffffffffff"
thread: 1 nab: 0xffffffff seq: 0x0000c4fe hws: 0x1 eot: 1 dis: 0
reset logs count: 0x24061f44 scn: 0x0000.00000001
Low scn: 0x0b50.d0c38fc1 10/15/2011 10:15:36
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
一时不知道什么情况，请有过相关处理经验的兄弟赐教

千问 · 2010-10-8 09:28:51

What note did you read? Can you check this?
Resolving an ORA-600 [12700] error in Oracle 8 and above. (Doc ID 155933.1)
3377611 in your case may be the data_object_id of the corrupted object.
Yong Huang

千问 · 2010-10-8 09:28:51

感谢版主亲自回答，我已经读了Doc ID 155933.1这个文档，我说到的那些信息是读的报错时生成的trc文件，并没有发现相关的sql。根据3377611查到了相关对象，然后把该对象涉及的段也进行了analyze和DBV检查，没有发现有问题

千问 · 2010-10-8 09:28:51

Is the object an index? If it's a table, run analyze table ... validate structure cascade on the table. If it's an index, I don't know if you need to do the analyze table cascade on its table. But it doesn't hurt to try.
If still nothing, follow the instruction to set event 10226. Please read through the whole document.
Yong Huang

千问 · 2010-10-8 09:28:51

感谢回复我已经analyze table了，没有报错所以准备等业务停止窗口做下面的。如果版主有时间，我可以把trc文件传给你帮我看下