簡單記錄一次ORA-00600: internal error code, arguments: [4194]

還不算暈發表於2014-07-04

接上一篇,在搞定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、重新啟動資料庫


相關文章