在處理一則ORA-600 [4194]案例時，參考MOS文檔：Step by step to resolve ORA-600 4194 4193 4197 on database crash (文檔 ID 1428786.1)
1.對于ORA 600[4194]的解釋
2.創建新undo表空間最佳實踐(包含段檢查)
1.對于ORA 600[4194]的解釋：
The following error is occurring in the alert.log right before the database crashes.
ORA-00600: internal error code, arguments: [4194], [#], [#], [], [], [], [], []
This error indicates that a mismatch has been detected between redo records and rollback (undo) records.
ARGUMENTS:
Arg [a] - Maximum Undo record number in Undo block
Arg [b] - Undo record number from Redo block
Since we are adding a new undo record to our undo block, we would expect that the new record number is equal to the maximum record number in the undo block plus one. Before Oracle can add a new undo record to the undo block it validates that this is correct. If this validation fails, then an ORA-600 [4194] will be triggered.
可以看到，此錯誤是因為redo和undo的記錄不匹配。常見于異常斷電等場景。
2.創建新undo表空間最佳實踐(包含段檢查)
Best practice to create a new undo tablespace.his method includes segment check. Create pfile from spfile to editSQL> Create pfile='/tmp/initsid.ora' from spfile; Shutdown the instance set the following parameters in the pfile /tmp/initsid.ora undo_management = manual event = '10513 trace name context forever, level 2' SQL>>startup restrict pfile='/tmp/initsid.ora' SQL>select tablespace_name, status, segment_name from dba_rollback_segs where status != 'OFFLINE';This is critical - we are looking for all undo segments to be offline - System will always be online.If any are 'PARTLY AVAILABLE' or 'NEEDS RECOVERY' - Please open an issue with Oracle Support or update the current SR. There are many options from this moment and Oracle Support Analyst can offer different solutions for the bad undo segments.If all offline then continue to the next step Create new undo tablespace - exampleSQL>create undo tablespace <new undo tablespace> datafile <datafile> size 2000M; Drop old undo tablespaceSQL>drop tablespace <old undo tablespace> including contents and datafiles; SQL>shutdown immediate;SQL>startup nomount; --> Using your Original spfile. Modify the spfile with the new undo tablespace nameSQL> Alter system set undo_tablespace = '<new tablespace created in step 6>' scope=spfile;. SQL>shutdown immediate;. SQL>startup; --> Using spfile
總結
以上所述是小編給大家介紹的Oracle創建新undo表空間最佳實踐(包含段檢查),希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復大家的。在此也非常感謝大家對武林網網站的支持！
如果你覺得本文對你有幫助，歡迎轉載，煩請注明出處，謝謝！
新聞熱點
疑難解答
