最新国产好看的视频,伊人天堂AV在线,国产Aaaaaa视频,蜜臀视频在线观看一区,人妻av色图,密臀久久久精品影片,青青视频免费观看毛片,久草在线观看视,国产三级精品色情在线

Oracle創(chuàng)建新undo表空間最佳實(shí)踐(包含段檢查)

 更新時(shí)間:2019年04月18日 09:56:02   作者:AlfredZhao  
這篇文章主要介紹了Oracle創(chuàng)建新undo表空間最佳實(shí)踐(包含段檢查),非常不錯(cuò),具有一定的參考借鑒價(jià)值,需要的朋友可以參考下

在處理一則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的記錄不匹配。常見(jiàn)于異常斷電等場(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)文章

最新評(píng)論

华池县| 微山县| 甘肃省| 稷山县| 南陵县| 永昌县| 万宁市| 怀来县| 抚远县| 通许县| 仁怀市| 开封县| 翁源县| 柳江县| 理塘县| 汉川市| 平武县| 宜宾市| 永胜县| 遂宁市| 庐江县| 白河县| 永德县| 旌德县| 天长市| 汪清县| 南丹县| 焦作市| 福建省| 奉节县| 镇平县| 四平市| 盐亭县| 阿图什市| 普兰店市| 荔波县| 汝城县| 奉化市| 民权县| 红原县| 长兴县|