接上一篇,在搞定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、重新启动数据库