Oracle創(chuàng)建新undo表空間最佳實(shí)踐(包含段檢查)
在處理一則ORA-600 [4194]案例時(shí),參考MOS文檔:Step by step to resolve ORA-600 4194 4193 4197 on database crash (文檔 ID 1428786.1)
1.對(duì)于ORA 600[4194]的解釋
2.創(chuàng)建新undo表空間最佳實(shí)踐(包含段檢查)
1.對(duì)于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.
可以看到,此錯(cuò)誤是因?yàn)閞edo和undo的記錄不匹配。常見于異常斷電等場(chǎng)景。
2.創(chuàng)建新undo表空間最佳實(shí)踐(包含段檢查)
Best practice to create a new undo tablespace. his method includes segment check. Create pfile from spfile to edit SQL> 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 - example SQL>create undo tablespace <new undo tablespace> datafile <datafile> size 2000M; Drop old undo tablespace SQL>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 name SQL> Alter system set undo_tablespace = '<new tablespace created in step 6>' scope=spfile; . SQL>shutdown immediate; . SQL>startup; --> Using spfile
總結(jié)
以上所述是小編給大家介紹的Oracle創(chuàng)建新undo表空間最佳實(shí)踐(包含段檢查),希望對(duì)大家有所幫助,如果大家有任何疑問請(qǐng)給我留言,小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持!
如果你覺得本文對(duì)你有幫助,歡迎轉(zhuǎn)載,煩請(qǐng)注明出處,謝謝!
相關(guān)文章
WINDOWS下使用DOS命令行連接oracle數(shù)據(jù)庫(kù)
本文講述了通過windows下的DOS命令連接oracle數(shù)據(jù)庫(kù)并進(jìn)行簡(jiǎn)單操作的方法2018-03-03Oracle中trunc()函數(shù)實(shí)例詳解
trunc函數(shù)用法用于截取時(shí)間或者數(shù)值,返回指定的值,下面這篇文章主要給大家介紹了關(guān)于Oracle中trunc()函數(shù)詳解的相關(guān)資料,文中通過實(shí)例代碼介紹的非常詳細(xì),需要的朋友可以參考下2023-01-01Oracle 分析函數(shù)RANK(),ROW_NUMBER(),LAG()等的使用方法
Oracle分析函數(shù)RANK(),ROW_NUMBER(),LAG()等的使用方法,需要的朋友可以參考下。2009-11-11Oracle 通過impdp導(dǎo)入報(bào)ORA-39002 ORA-39165錯(cuò)誤的解決方案
這篇文章主要介紹了Oracle 通過impdp導(dǎo)入報(bào)ORA-39002 ORA-39165錯(cuò)誤,本文給大家分享原因分析及解決方案,需要的朋友可以參考下2023-09-09Oracle 大小寫轉(zhuǎn)換函數(shù)實(shí)例詳解
這篇文章主要介紹了Oracle 大小寫轉(zhuǎn)換函數(shù)實(shí)例詳解的相關(guān)資料,需要的朋友可以參考下2017-06-06Oracle利用errorstack追蹤tomcat報(bào)錯(cuò)ORA-00903 無效表名的問題
這篇文章主要介紹了Oracle利用errorstack追蹤tomcat報(bào)錯(cuò)ORA-00903 無效表名,本文給大家介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值,需要的朋友可以參考下2020-06-06Oracle三種循環(huán)(For、While、Loop)實(shí)現(xiàn)九九乘法表
這篇文章主要為大家詳細(xì)介紹了Oracle三種循環(huán)For、While、Loop實(shí)現(xiàn)九九乘法表,具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2017-03-03Linux系統(tǒng)(X64)安裝Oracle11g完整安裝圖文教程另附基本操作
因項(xiàng)目需求,需要在64位linux系統(tǒng)中安裝Oracle 11g,在網(wǎng)上查了很多內(nèi)容,結(jié)合自己的實(shí)際經(jīng)驗(yàn),終于安裝成功,記錄下來,分享給有需要的同志們,不謝哈!^_^2014-08-08Oracle BULK COLLECT批量取數(shù)據(jù)解決方法
在oracle使用中為了提高取數(shù)據(jù)效率,本文將詳細(xì)介紹Oracle BULK COLLECT批量取數(shù)據(jù),需要了解跟多的朋友可以參考下2012-11-11