错误如下：
Sat Jul 26 10:22:23 2014 Errors in file /oracle/admin/icdb/udump/icdb_ora_459112.trc: ORA-00600: internal error code, arguments: [6711], [4257353], [1], [4255900], [0], [], [], [] Sat Jul 26 10:24:07 2014 Errors in file /oracle/admin/icdb/udump/icdb_ora_459112.trc: ORA-00600: internal error code, arguments: [6711], [4257353], [1], [4255900], [0], [], [], [] Sat Jul 26 10:31:38 2014 Errors in file /oracle/admin/icdb/udump/icdb_ora_56557800.trc: ORA-00600: 内部错误代码, 参数: [6711], [4257353], [1], [4255900], [0], [], [], [] Sat Jul 26 10:31:59 2014 Errors in file /oracle/admin/icdb/udump/icdb_ora_56557800.trc: ORA-00600: 内部错误代码, 参数: [6711], [4257353], [1], [4255900], [0], [], [], [] Sat Jul 26 11:00:30 2014 Errors in file /oracle/admin/icdb/bdump/icdb_m000_56557774.trc: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], [] Sat Jul 26 11:01:00 2014 Errors in file /oracle/admin/icdb/udump/icdb_ora_57344088.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], [] Sat Jul 26 12:00:39 2014 Errors in file /oracle/admin/icdb/bdump/icdb_m000_63307938.trc: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], [] Sat Jul 26 12:06:47 2014 Thread 1 advanced to log sequence 32908 (LGWR switch) Current log# 1 seq# 32908 mem# 0: /database/icdb/redo01.log Sat Jul 26 12:09:41 2014 Thread 1 advanced to log sequence 32909 (LGWR switch) Current log# 2 seq# 32909 mem# 0: /database/icdb/redo02.log Sat Jul 26 12:13:06 2014 Thread 1 advanced to log sequence 32910 (LGWR switch) Current log# 3 seq# 32910 mem# 0: /database/icdb/redo03.log Sat Jul 26 12:16:03 2014 Thread 1 advanced to log sequence 32911 (LGWR switch) Current log# 1 seq# 32911 mem# 0: /database/icdb/redo01.log Sat Jul 26 12:18:58 2014 Thread 1 advanced to log sequence 32912 (LGWR switch) Current log# 2 seq# 32912 mem# 0: /database/icdb/redo02.log Sat Jul 26 13:00:41 2014 Errors in file /oracle/admin/icdb/bdump/icdb_m000_7668146.trc: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], [] Sat Jul 26 13:00:44 2014 Errors in file /oracle/admin/icdb/bdump/icdb_m000_7668146.trc: ORA-00600: internal error code, arguments: [13013], [5001], [9001], [12637871], [26], [12613723], [3], []
可以确认
ORA-00600: internal error code, arguments: [qertbFetchByRowID]
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []以及为BUG
| 7329252 | 10.2.0.4.4, 10.2.0.5, 11.1.0.7.5, 11.2.0.1 | ORA-8102/ORA-1499/OERI[kdsgrp1] Index corruption after rebuild index ONLINE |
剩下就是
[kcbz_check_objd_typ]， [13013]，[6711] 先分析6711的错误，根据对整体日志的分析过程如下： [root@ludatou /]# cat alert_icdb.log | grep 6711 |wc -l 39 [root@ludatou /]# cat alert_icdb.log | grep 4257353 |wc -l 31 [root@ludatou /]# cat alert_icdb.log | grep 4255900 |wc -l 31 [root@ludatou /]# cat alert_icdb.log | grep -v 4257353 |wc -l 171179 [root@ludatou /]# cat alert_icdb.log | grep -v 4257353 |grep 6711 |wc -l 8 [root@ludatou /]# cat alert_icdb.log | grep -v 4257353 |grep 6711 Thread 1 cannot allocate new log, sequence 6711 Thread 1 advanced to log sequence 6711 (LGWR switch) Current log# 3 seq# 6711 mem# 0: /database/icdb/redo03.log Current log# 3 seq# 6711 mem# 0: /database/icdb/redo03.log Thread 1 advanced to log sequence 16711 (LGWR switch) Current log# 1 seq# 16711 mem# 0: /database/icdb/redo01.log Thread 1 advanced to log sequence 26711 (LGWR switch) Current log# 2 seq# 26711 mem# 0: /database/icdb/redo02.log 通过以上的分析我们可以发现，6711的错误集中的对应数据块都为 [6711], [4257353], [1], [4255900] SQL> SELECT dbms_utility.data_block_address_block(4257353) "BLOCK", 2 dbms_utility.data_block_address_file(4257353) "FILE" from dual; BLOCK FILE ---------- ---------- 63049 1 SQL> SELECT dbms_utility.data_block_address_block(4255900) "BLOCK", 2 dbms_utility.data_block_address_file(4255900) "FILE" from dual; BLOCK FILE ---------- ---------- 61596 1 set linesize 200; select segment_name, segment_type from dba_extents where relative_fno = 1 and (663049 between block_id and block_id + blocks or 61596 between block_id and block_id + blocks);
