ORA-00600: [6749], [3], [12596882], [49], [], [], [], []

dai_xuej

1、主机：IBM 366
2、操作系统信息
[root@oracle2 ~]# uname -a
Linux oracle2 2.6.18-92.el5 #1 SMP Tue Apr 29 13:16:15 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
3、数据库版本信息
[ora-app@oracle2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jun 1 09:48:55 2012
Copyright (c) 1982, 2005, Oracle.
All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
4、部分alert log:
Tue Jul 10 07:01:34 2012
Errors in file /opt/oracle/admin/oraapp/bdump/oraapp_j000_11584.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12596882], [49], [], [], [], []
Tue Jul 10 07:01:38 2012
Errors in file /opt/oracle/admin/oraapp/bdump/oraapp_j000_11584.trc:
Tue Jul 10 08:01:05 2012
Errors in file /opt/oracle/admin/oraapp/bdump/oraapp_j000_24529.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12596882], [49], [], [], [], []
Tue Jul 10 08:01:08 2012
Errors in file /opt/oracle/admin/oraapp/bdump/oraapp_j000_24529.trc:
5、trace文件可疑点：
DUMP OF REDO FROM FILE '/opt/oracle/oradata/oraapp/systable/redo02.log'
Opcodes 11.*
DBAs (file#, block#):
      (3, 13970)
RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
6、trace文件见附件：
7、参考mos上的[文章 ID 467439.1]做了以下诊断操作：
       a、SELECT tablespace_name, segment_type, owner, segment_name  
               FROM dba_extents  
            WHERE file_id = 3  
                   and 13970 between block_id AND block_id + blocks - 1;
查询结果：
TABLESPACE_NAME      SEGMENT_TYPE       OWNER           SEGMENT_NAME
-------------------- ------------------ --------------- ------------------------
SYSAUX               TABLE              SYSMAN          SYS_IOT_OVER_10448
      b、SQL> select table_name, iot_name from all_tables where table_name='SYS_IOT_OVER_10448';
TABLE_NAME                     IOT_NAME
------------------------------ ------------------------------
SYS_IOT_OVER_10448             MGMT_METRICS_RAW
结合mos上的[文章 ID 467439.1]据此断定是Bug 6127434
8、处理办法：
      1. )Ensure you have a good backup before proceeding.
      2. )Create a copy of the SYSMAN.MGMT_METRICS_RAW table:
            SQL> create table SYSMAN.MGMT_METRICS_RAW_COPY  as select * from SYSMAN.MGMT_METRICS_RAW;
      3. )Truncate the table:
            SQL> truncate table SYSMAN.MGMT_METRICS_RAW;

                   May need  to disable trigger: "sysman.raw_metrics_after_insert" before proceeding.  Re-enable after the insert.
      4. )Re-insert the rows:
            SQL> insert into SYSMAN.MGMT_METRICS_RAW select * from SYSMAN.MGMT_METRICS_RAW_COPY;
            SQL> commit;
       5. )Drop the copy table:
             SQL> drop table SYSMAN.MGMT_METRICS_RAW_COPY;