当前位置:  数据库>oracle

ORA-600 [4194] 说明

    来源: 互联网  发布时间:2017-05-04

    本文导语: 一.  说明 朋友的一个库不能打开,错误信息如下: Errors in filef:appadministratordiagrdbmsorclorcltraceorcl_ora_1200.trc  (incident=89062): ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], [] ORA-00600: 内部错误代码, 参数: [4194]...

一.  说明

朋友的一个库不能打开,错误信息如下:

Errors in filef:appadministratordiagrdbmsorclorcltraceorcl_ora_1200.trc  (incident=89062):

ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []

ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []

Incident details in:f:appadministratordiagrdbmsorclorclincidentincdir_89062orcl_ora_1200_i89062.trc

Trace dumping is performingid=[cdmp_20120730184640]

Errors in file f:appadministratordiagrdbmsorclorcltraceorcl_ora_1200.trc:

ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []

ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []

Mon Jul 30 18:46:41 2012

Errors in filef:appadministratordiagrdbmsorclorcltraceorcl_ora_1200.trc  (incident=90109):

ORA-00603: Oracle server session terminatedby fatal error

ORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []

Incident details in:f:appadministratordiagrdbmsorclorclincidentincdir_90109orcl_ora_1200_i90109.trc

Errors in filef:appadministratordiagrdbmsorclorclincidentincdir_90109orcl_ora_1200_i90109.trc:

ORA-00603: ORACLE server session terminatedby fatal error

ORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []

有关ORA-600[41XX]格式的都是与UNDO 有关。 

二.  MOS 关于ORA-600[4194] 说明

ORA-600 [4194] "Undo Record NumberMismatch While Adding Undo Record" [ID 39283.1]

ERROR:             

  Format: ORA-600 [4194] [a] [b]

 

VERSIONS:          

 versions 6.0 to 10.1

 

DESCRIPTION:

 

  Amismatch has been detected between Redo records and rollback (Undo)   records.

 --这个错误是检测Redo records和rollback(Undo)records不一致。

 

  Weare validating the Undo record number relating to the change being appliedagainst the maximum undo record number recorded in the undo block.

 

  Thiserror is reported when the validation fails.

 

ARGUMENTS:

  Arg[a] Maximum Undo record number in Undo block

       --这里的参数[a] 是undo block中最大的undo record数。

  Arg[b] Undo record number from Redo block

       --参数[b]是Redo block中的undo records。

 

FUNCTIONALITY:     

 Kernel Transaction Undo called from Cache layer

 

IMPACT:            

  PROCESSFAILURE

 POSSIBLE ROLLBACK SEGMENT CORRUPTION

SUGGESTIONS:

 This error may indicate a rollback segment corruption.

 This may require a recovery from a database backup depending on thesituation.

三.解决方法

重建UNDO 表空间。具体操作参考:

Currentonline Redo 和 Undo 损坏的处理方法

相关链接:
Oracle undo 表空间管理
OracleORA-600[4193] 解决方法 说明


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • 出现ORA-01401和ORA-01008错误?
  • Eclipse连接Oracle数据库的ORA-00604 ORA-12705错误
  • oracle ORA-01114、ORA-27067错误解决方法
  • Oracle不能删除表 ORA-00604 ORA-01422 错误
  • 如何得到带有ora的行的下一行
  • solaris10 安装 ora9.2.0.1 时报错 iis7站长之家
  • 如何配置 linux 下 oracle 的 listener .ora 和
  • 浅析如何在tnsnames.ora中配置监听
  • Orcle的package中访问其它Schema的表报错ORA-00942解决方法
  • oracle远程连接服务器出现 ORA-12170 TNS:连接超时 解决办法
  • [Oracle] 浅析令人抓狂的ORA-01555问题
  • 解决报错ora-32035的方法分析
  • aq.executeQuery: ORA-00020: maximum number of processes (59) exceeded
  • Oracle 数据库闪回功能设置出现ORA-19809和ORA-19804错误
  • ORA-00947:Not enough values (没有足够的值)的深入分析
  • solaris10 安装 ora9.2.0.1 时报错
  • 在UNIX下,我的ORA817该怎么样才可以自己启动呀?
  • 基于ORA-12170 TNS 连接超时解决办法详解
  • plsql连接oracle数据库报ora 12154错误解决方法
  • 安装oracle出现error:ora-01031:insufficient privilleges的解决


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,