ORA-600 [4194] 说明

2014-11-24 18:45:09 · 作者: · 浏览: 0

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


Errors in filef:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_1200.trc (incident=89062):


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


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


Incident details in:f:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_89062\orcl_ora_1200_i89062.trc


Trace dumping is performingid=[cdmp_20120730184640]


Errors in file f:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_1200.trc:


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


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


Mon Jul 30 18:46:41 2012


Errors in filef:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_1200.trc (incident=90109):


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


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


Incident details in:f:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_90109\orcl_ora_1200_i90109.trc


Errors in filef:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_90109\orcl_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 有关。


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 recordsrollbackUndorecords不一致。



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 表空间。具体操作参考: