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ì)大家有所幫助,如果大家有任何疑問(wèn)請(qǐng)給我留言,小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持!
如果你覺(jué)得本文對(duì)你有幫助,歡迎轉(zhuǎn)載,煩請(qǐng)注明出處,謝謝!
相關(guān)文章
Oracle 11g安裝錯(cuò)誤提示未找到wfmlrsvcapp.ear的解決方法
這篇文章主要為大家詳細(xì)介紹了Oracle 11g安裝錯(cuò)誤提示未找到wfmlrsvcapp.ear的解決方法,具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2017-04-04
Oracle ASM數(shù)據(jù)庫(kù)故障數(shù)據(jù)恢復(fù)解決方案
這篇文章主要介紹了Oracle ASM數(shù)據(jù)庫(kù)故障數(shù)據(jù)恢復(fù)解決方案,需要的朋友可以參考下2017-04-04
關(guān)于oracle中clob字段查詢慢的問(wèn)題及解決方法
最近在用oracle的過(guò)程中用到了對(duì)blob字段模糊查詢的問(wèn)題。接下來(lái)通過(guò)本文給大家分享關(guān)于oracle中clob字段查詢慢的問(wèn)題及解決方法,需要的的朋友參考下吧2017-02-02
Oracle數(shù)據(jù)庫(kù)表空間滿了的問(wèn)題處理方法
在Oracle數(shù)據(jù)庫(kù)管理中,表空間是一個(gè)重要的概念,用于存儲(chǔ)數(shù)據(jù)庫(kù)對(duì)象和數(shù)據(jù),當(dāng)表空間滿了時(shí),可能會(huì)導(dǎo)致數(shù)據(jù)庫(kù)的運(yùn)行受到影響,本文將介紹如何診斷和處理 Oracle 數(shù)據(jù)庫(kù)中表空間滿的問(wèn)題,并給出相應(yīng)的 SQL 命令,需要的朋友可以參考下2024-03-03
oracle遠(yuǎn)程連接服務(wù)器出現(xiàn) ORA-12170 TNS:連接超時(shí) 解決辦法
oracle遠(yuǎn)程連接服務(wù)器出現(xiàn) ORA-12170 TNS:連接超時(shí) 解決辦法,需要的朋友可以參考一下2013-03-03
對(duì)比Oracle臨時(shí)表和SQL Server臨時(shí)表的不同點(diǎn)
這篇文章主要介紹了Oracle數(shù)據(jù)庫(kù)建立臨時(shí)表的相關(guān)知識(shí)以及和SQL Server臨時(shí)表的不同點(diǎn)的對(duì)比,希望能夠?qū)δ兴鶐椭?/div> 2015-09-09
Oracle中分組查詢group by用法規(guī)則詳解
這篇文章主要介紹了Oracle中分組查詢group by用法規(guī)則詳解,文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2020-07-07
Oracle基礎(chǔ)多條sql執(zhí)行在中間的語(yǔ)句出現(xiàn)錯(cuò)誤時(shí)的控制方式
今天小編就為大家分享一篇關(guān)于Oracle基礎(chǔ)多條sql執(zhí)行在中間的語(yǔ)句出現(xiàn)錯(cuò)誤時(shí)的控制方式,小編覺(jué)得內(nèi)容挺不錯(cuò)的,現(xiàn)在分享給大家,具有很好的參考價(jià)值,需要的朋友一起跟隨小編來(lái)看看吧2018-12-12最新評(píng)論

