校园春色亚洲色图_亚洲视频分类_中文字幕精品一区二区精品_麻豆一区区三区四区产品精品蜜桃

主頁 > 知識庫 > Oracle創建新undo表空間最佳實踐(包含段檢查)

Oracle創建新undo表空間最佳實踐(包含段檢查)

熱門標簽:濟南地圖標注公司 圖像地圖標注 南寧人工智能電銷機器人費用 海南400電話哪里辦理 400電話是不是免費申請 安陽外呼系統免費 呼倫貝爾智能手機地圖標注 分布式呼叫中心 貴陽電話外呼系統哪家好

在處理一則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 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

總結

以上所述是小編給大家介紹的Oracle創建新undo表空間最佳實踐(包含段檢查),希望對大家有所幫助,如果大家有任何疑問請給我留言,小編會及時回復大家的。在此也非常感謝大家對腳本之家網站的支持!
如果你覺得本文對你有幫助,歡迎轉載,煩請注明出處,謝謝!

您可能感興趣的文章:
  • Oracle 區塊鏈表創建過程詳解
  • Oracle多表查詢中間表的創建實例教程
  • Oracle數據庫scott用戶創建view視圖權限的操作方法
  • Navicat Premium中Oracle創建主鍵自增的方法
  • Navicat for oracle創建數據庫的方法
  • Oracle數據庫創建存儲過程的示例詳解
  • 通過PLSQL Developer創建Database link,DBMS_Job,Procedure,實現Oracle跨庫傳輸數據的方法(推薦)
  • oracle創建dblink方法示例
  • Oracle 給rac創建單實例dg并做主從切換功能
  • Oracle創建設置查詢權限用戶的方法
  • 使用sqlplus命令行工具為oracle創建用戶和表空間
  • Oracle創建只讀賬號的詳細步驟

標簽:遼源 合肥 涼山 郴州 許昌 焦作 南充 滁州

巨人網絡通訊聲明:本文標題《Oracle創建新undo表空間最佳實踐(包含段檢查)》,本文關鍵詞  Oracle,創,建新,undo,表,空間,;如發現本文內容存在版權問題,煩請提供相關信息告之我們,我們將及時溝通與處理。本站內容系統采集于網絡,涉及言論、版權與本站無關。
  • 相關文章
  • 下面列出與本文章《Oracle創建新undo表空間最佳實踐(包含段檢查)》相關的同類信息!
  • 本頁收集關于Oracle創建新undo表空間最佳實踐(包含段檢查)的相關信息資訊供網民參考!
  • 推薦文章
    主站蜘蛛池模板: 荆门市| 贵溪市| 内丘县| 唐河县| 吉林市| 长武县| 聂荣县| 县级市| 安图县| 珠海市| 巧家县| 庄浪县| 余姚市| 湘潭县| 林芝县| 榆树市| 都昌县| 东海县| 洪泽县| 镇坪县| 红河县| 龙里县| 五原县| 金山区| 呼和浩特市| 土默特左旗| 青冈县| 岫岩| 广饶县| 隆尧县| 重庆市| 石河子市| 灵宝市| 嘉义市| 扎赉特旗| 昆山市| 文成县| 西盟| 吴旗县| 略阳县| 孟津县|