ORA-600 [kdsgrp1] 处理

ORA-600 [6947]/ORA-600 [kdsgrp1] 处理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 - ProductionSQL> 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 - 1TABLESPACE_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_GTABLE_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$ATTRALIASESTABLE_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_G31 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], [], [], [], [], [], [],
[]问题确定为bug，Bug 6127434
ORA-600 [6749] Occurring on SYSMAN.MGMT_METRICS_RAW （Doc ID 467439.1）##########################################
ORA-600 [6749] Occurring on SYSMAN.MGMT_METRICS_RAW （Doc ID 467439.1） To BottomTo Bottom
--------------------------------------------------------------------------------Modified:13-Jun-2013Type:PROBLEM Rate this document Email link to this document Open document in new window Printable Page
In this Document
Symptoms
Cause
Solution
References
--------------------------------------------------------------------------------
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.3 and later [Release: 10.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 28-Feb-2012***Symptoms
1. The following error is occurring in the alert.log:ORA-00600: internal error code, arguments: [6749], [6], [12605862], [78], [], [], [], []2. The trace file may report the DBA and block number for the error. If it does not, please engage Oracle Support for assistance:TRACE FILE ataccess_j000_8790.trc
--------------------------------------------------------
*** SESSION ID:（133.1713） 2007-11-02 16:00:45.275
Dumping current redo log in thread 1DUMP OF REDO FROM FILE "/u04/oradata/ACCESS16/ataccess/redo4.log"
Opcodes 11.*
DBAs （file#, block#）: （3, 22950）
RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Compatibility Vsn = 169869568=0xa200100
Db ID=1655231844=0x62a8d564, Db Name="ATACCESS"
Activation ID=1655191140=0x62a83664
Control Seq=4582=0x11e6, File size=204800=0x32000
File Number=4, Blksiz=512, File Type=2 LOG3. The table affected is SYSMAN.MGMT_METRICS_RAW:SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = 3
and 22950 between block_id AND block_id + blocks - 1; TABLESPACE_NAME SEGMENT_TYPE OWNER SEGMENT_NAME
--------------- ------------ ----- ------------
SYSAUX TABLE SYSMAN SYS_IOT_OVER_49869
select table_name, iot_name from all_tables where table_name like "%IOT%"; .
..
... SYS_IOT_OVER_49766 AQ$_MGMT_NOTIFY_QTABLE_G
SYS_IOT_OVER_49869 MGMT_METRICS_RAW <<<<<<<------------
SYS_IOT_OVER_49872 MGMT_CURRENT_METRICS
Cause
This issue was investigated in Bug 6127434 but not resolved due to lack of information.Abstract: ORA-600[6749] RAISED BY DELETE COMMAND; NO CORRUPTION IDENTIFIED
Solution
The following workaround may resolve the problem temporarily: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; References
BUG:6127434 - ORA-600[6749] RAISED BY DELETE COMMAND; NO CORRUPTION IDENTIFIED#############################################如何评估Oracle AWR 的在Oracle 中的存储情况remote_listener 设置问题导致数据库不能打开相关资讯 ORA-600

深入分析ORA-600[2662] 错误系列一（12/04/2015 10:25:04）
RMAN备份遭遇ORA-600错误（05/13/2015 19:33:33）
ORA-600[13011] 错误解决一例（11/17/2014 23:12:43）

ORA-600[kcbz_check_objd_typ]错误（05/28/2015 06:04:06）
ORA-600[13013]处理过程（11/20/2014 18:53:01）
ORA-600 [kcblasm_1]bug解决一例（08/04/2014 20:03:23）

本文评论查看全部评论（0）