Welcome 微信登录

首页 / 数据库 / MySQL / ORA-600 [4194] 说明

一．  说明

朋友的一个库不能打开，错误信息如下：Errors in filef:appadministratordiag dbmsorclorcl raceorcl_ora_1200.trc  （incident=89062）:ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []Incident details in:f:appadministratordiag dbmsorclorclincidentincdir_89062orcl_ora_1200_i89062.trcTrace dumping is performingid=[cdmp_20120730184640]Errors in file f:appadministratordiag dbmsorclorcl raceorcl_ora_1200.trc:ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []Mon Jul 30 18:46:41 2012Errors in filef:appadministratordiag dbmsorclorcl raceorcl_ora_1200.trc  （incident=90109）:ORA-00603: Oracle server session terminatedby fatal errorORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []ORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []Incident details in:f:appadministratordiag dbmsorclorclincidentincdir_90109orcl_ora_1200_i90109.trcErrors in filef:appadministratordiag dbmsorclorclincidentincdir_90109orcl_ora_1200_i90109.trc:ORA-00603: ORACLE server session terminatedby fatal errorORA-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 CORRUPTIONSUGGESTIONS: This error may indicate a rollback segment corruption. This may require a recovery from a database backup depending on thesituation.

三．解决方法

重建UNDO 表空间。具体操作参考：Currentonline Redo 和 Undo 损坏的处理方法 http://www.linuxidc.com/Linux/2012-08/66992.htm相关链接：
Oracle undo 表空间管理 http://www.linuxidc.com/Linux/2011-07/38006.htm
OracleORA-600[4193] 解决方法 说明 http://www.linuxidc.com/Linux/2012-08/66993.htmOracle dump undo 说明Oracle ORA-01555 快照过旧 说明相关资讯      Oracle错误代码 
  • Oracle错误代码大全  （02/16/2015 21:31:57）
  • Oracle中登陆时报ORA-28000: the   （03/06/2013 20:06:23）
  • Oracle 11g startup时报ORA-03113  （02/21/2013 17:25:55）
  • Oracle Grid Control OUI-25031错  （03/09/2013 09:01:36）
  • ORA-04091:触发器/函数不能读  （02/25/2013 08:28:13）
  • Oracle错误 ORA-12514 解决方法  （02/18/2013 08:50:10）
本文评论 查看全部评论 （0）
表情： 姓名： 字数