ORA-600 [6749]/ORA-00600: [kdsgrp1]

北柏

os：ol linux
db：ora 10201

这是一个自己的测试环境，昨天要做测试时，打开db时发现 后台报错，写了3g的 trace日志，导致audit 日志不能写，后来观察alert日志后发现如下：

alert。log：
Tue Dec  3 23:01:50 2013
Errors in file /oracle/admin/lixora/bdump/lixora_j000_22278.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12620597], [387], [], [], [], []
Wed Dec  4 00:01:09 2013
Errors in file /oracle/admin/lixora/bdump/lixora_j000_22781.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12620597], [387], [], [], [], []
Wed Dec  4 01:00:06 2013
Errors in file /oracle/admin/lixora/bdump/lixora_j000_23282.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12620597], [387], [], [], [], []
Wed Dec  4 02:00:48 2013
Errors in file /oracle/admin/lixora/bdump/lixora_j000_23801.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12620597], [387], [], [], [], []
Wed Dec  4 03:00:26 2013
Errors in file /oracle/admin/lixora/bdump/lixora_j000_24303.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12620597], [387], [], [], [], []
Wed Dec  4 04:00:04 2013
Errors in file /oracle/admin/lixora/bdump/lixora_j000_24800.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12620597], [387], [], [], [], []
Wed Dec  4 05:00:46 2013
Errors in file /oracle/admin/lixora/bdump/lixora_j000_25642.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12620597], [387], [], [], [], []
Wed Dec  4 06:00:20 2013
Errors in file /oracle/admin/lixora/bdump/lixora_j000_26124.trc:


后来在mos上确定了以下为bug：
问题确定为Bug 6127434
ORA-600 [6749] Occurring on SYSMAN.MGMT_METRICS_RAW (Doc ID 467439.1)
按照文档的solution操作如下：


SQL> select * from v$version;


BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> SELECT tablespace_name, segment_type, owner, segment_name  
  2      FROM dba_extents  
  3      WHERE file_id = 3  
  4      and 22950 between block_id AND block_id + blocks - 1;

TABLESPACE_NAME                SEGMENT_TYPE       OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSAUX                         TABLE              SYSMAN
MGMT_LICENSES


SQL> c/22950/37685
  4*     and 37685 between block_id AND block_id + blocks - 1
SQL> r
  1  SELECT tablespace_name, segment_type, owner, segment_name
  2      FROM dba_extents
  3      WHERE file_id = 3
  4*     and 37685 between block_id AND block_id + blocks - 1

TABLESPACE_NAME                SEGMENT_TYPE       OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
SYSAUX                         TABLE              SYSMAN
SYS_IOT_OVER_49869


SQL> select table_name, iot_name from all_tables where table_name like '%IOT%';

TABLE_NAME                     IOT_NAME
------------------------------ ------------------------------
SYS_IOT_OVER_4478              RULE_SET_PR$
SYS_IOT_OVER_4484              RULE_SET_IOT$
SYS_IOT_OVER_4488              RULE_SET_ROP$
SYS_IOT_OVER_5082              AQ$_SCHEDULER$_JOBQTAB_G
SYS_IOT_OVER_5168              AQ$_SCHEDULER$_EVENT_QTAB_G
SYS_IOT_OVER_7157              AQ$_KUPC$DATAPUMP_QUETAB_G
SYS_IOT_OVER_8689              AQ$_AQ$_MEM_MC_G
SYS_IOT_OVER_8799              AQ$_ALERT_QT_G
SYS_IOT_OVER_9692              RECENT_RESOURCE_INCARNATIONS$
SYS_IOT_OVER_10099             AQ$_WM$EVENT_QUEUE_TABLE_G
SYS_IOT_OVER_35428             AQ$_SYS$SERVICE_METRICS_TAB_G

TABLE_NAME                     IOT_NAME
------------------------------ ------------------------------
SYS_IOT_OVER_40409             EXF$IDXSECOBJ
SYS_IOT_OVER_40883             DR$SQE
SYS_IOT_OVER_40928             DR$PARALLEL
SYS_IOT_OVER_42445             RLM$ERRCODE
SYS_IOT_OVER_42452             RLM$RULESET
SYS_IOT_OVER_42459             RLM$PRIMEVTTYPEMAP
SYS_IOT_OVER_42462             RLM$EQUALSPEC
SYS_IOT_OVER_42481             RLM$JOBQUEUE
SYS_IOT_OVER_42484             RLM4J$EVTSTRUCTS
SYS_IOT_OVER_42487             RLM4J$RULESET
SYS_IOT_OVER_42490             RLM4J$ATTRALIASES

TABLE_NAME                     IOT_NAME
------------------------------ ------------------------------
SYS_IOT_OVER_49766             AQ$_MGMT_NOTIFY_QTABLE_G
SYS_IOT_OVER_49869             MGMT_METRICS_RAW
SYS_IOT_OVER_49872             MGMT_CURRENT_METRICS
SYS_IOT_OVER_52389             ACTION_TABLE
SYS_IOT_OVER_52394             LINEITEM_TABLE
SYS_IOT_OVER_52776             AQ$_KUPC$DATAPUMP_QUETAB_D
RULE_SET_IOT$
SYS_IOT_OVER_51984             AQ$_STREAMS_QUEUE_TABLE_G
SYS_IOT_OVER_51967             AQ$_ORDERS_QUEUETABLE_G

31 rows selected.

SQL> create table SYSMAN.MGMT_METRICS_RAW_COPY
  2  as select * from SYSMAN.MGMT_METRICS_RAW;

as select * from SYSMAN.MGMT_METRICS_RAW
                        *
ERROR at line 2:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],
[]


问题到这里，先处理ORA-00600 [kdsgrp1], 按照ORA-600 [kdsgrp1] During Table/Index Full Scans (Doc ID 468883.1)  提供的solution 来处理坏块：
SQL> alter session set events '10231 trace name context forever, level 10';
SQL> create table salvage_table as select *  from corrupt_table;

还是包相同的错误：

SQL> alter session set events '10231 trace name context forever, level 10';

Session altered.

SQL>  create table SYSMAN.MGMT_METRICS_RAW_COPY
  2    as select * from SYSMAN.MGMT_METRICS_RAW;


  as select * from SYSMAN.MGMT_METRICS_RAW
                          *
ERROR at line 2:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],
[]

目前数据库是可以正常使用，但是一直在写大量的trace 。 请大家指点下解决思路。

北柏

trace ：http://pan.baidu.com/share/link?shareid=488291353&uk=1175986083

北柏

Liu Maclean(刘相兵 发表于 2013-12-5 21:10
FYI

Applies to:

ths, 测试有效，谢谢刘大！