当前位置: 代码迷 >> Ruby/Rails >> 简略记录一次ORA-00600: internal error code, arguments: [4194]
  详细解决方案

简略记录一次ORA-00600: internal error code, arguments: [4194]

热度:293   发布时间:2016-04-29 02:23:04.0
简单记录一次ORA-00600: internal error code, arguments: [4194]

接上一篇,在搞定SCN问题后,又遇到ORA-600[4194]/[4193]报错。

故障现象:

OPEN数据库时报错:ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], []


4193:表示undo和redo不一致(Arg [a] Undo record seq number,Arg [b] Redo record seq number );
4194:表示也是undo和redo不一致(Arg [a] Maximum Undo record number in Undo block,Arg [b] Undo record number from Redo block)


故障解决:

1、修改参数
undo_management= MANUAL
undo_tablespace= SYSTEM
2、OPEN数据库,删除当前undo空间,重建新的undo空间
3、修改参数
undo_management= AUTO
undo_tablespace= UNDOTBS1
4、重新启动数据库


  相关解决方案