关闭

ora-600 [6947]/ora-600 [kdsgrp1] 处理

1701人阅读 评论(2) 收藏 举报
分类:


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 - 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], [], [], [], [], [], [],
[]

问题确定为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 1

DUMP 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 LOG

3. 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

#############################################


1
0
查看评论
发表评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场

ORA-600 各个参数含义说明

一. ORA-600 概述 ORA-600 是一个非常头疼的一个错误。比如:        ORA-00600:internal error code, arguments: [4194], [4...
  • bw_xinyun
  • bw_xinyun
  • 2016-02-02 12:40
  • 1045

[升级] 数据库升级到11g的应急方案

数据库升级应急方案 通过对数据库初始化参数进行调整来对出现的故障或者性能问题进行处理。 _subquery_pruning_enabled 参数:_subquery_pruning_...
  • launch_225
  • launch_225
  • 2013-11-25 17:12
  • 4897

ORACLE10G 出现00600的一个BUG的解决方案

今天又一同事遇到一个oracle数据库bug问题,如下: --ORACLE 10.1 OR 10.2中所有平台都存在该问题. 在进行多表关联复杂查询时出现 ORA-00600: 内部错误代码...
  • lichangzai
  • lichangzai
  • 2013-01-25 16:47
  • 1205

ora-600 13013处理方案

  • 2015-12-14 16:13
  • 1KB
  • 下载

ORA-600 [kqlnrc_1]

ON: Oracle 10.2.0.5,HP-UX IA64   数据库告警日志中抛出大量ORA-600错误: Mon Apr 20 16:59:01 EAT 2015 Errors in file ...
  • liglewang
  • liglewang
  • 2015-04-27 11:11
  • 586

ORA-600 [ksuinfos_modact1]

用户日志报改错,日志如下:
  • wenzhongyan
  • wenzhongyan
  • 2014-09-12 11:26
  • 682

一次ora-600 ktubko_1故障简单分析

=================================================================================================== ...
  • panda1219
  • panda1219
  • 2016-06-27 10:58
  • 429

ORA-600 [2662] Block SCN is ahead of Current SCN 处理方法 说明

一. ORA-600[2662] 说明 关于ORA-600[2662]的的错误,之前的blog 有说明:        ORA-600[2662] "Block SCN is ahea...
  • xujinyang
  • xujinyang
  • 2011-09-26 17:16
  • 574

断电与ORA-600错误处理

目 录断电与ORA-600错误处理集合....................................................................................
  • zftang
  • zftang
  • 2011-05-26 21:55
  • 2103

记一次数据库在线current redo损坏故障,2662,ora-600

ora-600 2662, current redo损坏 环境:开发库 oracle 11.2.0.4 + suse linux 12  故障现象:巡检时发现,数据库已经挂掉。 处理过程: 查看ale...
  • familyrun
  • familyrun
  • 2016-03-03 10:44
  • 693
    个人资料
    • 访问:777783次
    • 积分:15827
    • 等级:
    • 排名:第796名
    • 原创:687篇
    • 转载:95篇
    • 译文:11篇
    • 评论:87条
    博客专栏
    oracle blog
    最新评论