首页 > 代码库 > 简单记录一次ORA-00600: internal error code, arguments: [4194]

简单记录一次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、重新启动数据库