ORA-00600 [4194], [55]處理
今天遇見客戶報故障,資料庫無法open,啟動資料庫的時候報一下錯誤,可以open但是過不了多久直接abort
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3708.trc (incident=54164):
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600 [4194]這種錯誤一般是由於回滾段異常導致
我們可以直接遮蔽回滾段
sqlplus / as sysdba
startup nomount;
create pfile='d:\pfile.ora' from spfile;
增加如下引數
undo_management='MANUAL'
_corrupted_rollback_segments='_SYSSMU1$','_SYSSMU2$','_SYSSMU3$','_SYSSMU4$','_SYSSMU5$','_SYSSMU6$','_SYSSMU7$','_SYSSMU8$','_SYSSMU9$','_SYSSMU10$
sqlplus / as sysdba
startup nomount pfile='d:\pfile.ora';
alter database mount;
alter database open;
create undotbs undotbs2 datafile 'd:\oracle\oradata\undotbs201.dbf' size 4G autoextend on next 20M maxsize 8G;
shutdown immediate;
去除以下引數
undo_management='MANUAL'
_corrupted_rollback_segments='_SYSSMU1$','_SYSSMU2$','_SYSSMU3$','_SYSSMU4$','_SYSSMU5$','_SYSSMU6$','_SYSSMU7$','_SYSSMU8$','_SYSSMU9$','_SYSSMU10$
修改pfile.ora
修改引數
undo_tablespace=undotbs2
啟動資料庫
startup nomount pfile='d:\pfile.ora';
alter database mount;
alter database open;
匯出資料
expdp directory=dumpdir dumfile=kshk20171022.dmp schemas=ksnk
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3708.trc (incident=54164):
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []
ORA-00600 [4194]這種錯誤一般是由於回滾段異常導致
我們可以直接遮蔽回滾段
sqlplus / as sysdba
startup nomount;
create pfile='d:\pfile.ora' from spfile;
增加如下引數
undo_management='MANUAL'
_corrupted_rollback_segments='_SYSSMU1$','_SYSSMU2$','_SYSSMU3$','_SYSSMU4$','_SYSSMU5$','_SYSSMU6$','_SYSSMU7$','_SYSSMU8$','_SYSSMU9$','_SYSSMU10$
sqlplus / as sysdba
startup nomount pfile='d:\pfile.ora';
alter database mount;
alter database open;
create undotbs undotbs2 datafile 'd:\oracle\oradata\undotbs201.dbf' size 4G autoextend on next 20M maxsize 8G;
shutdown immediate;
去除以下引數
undo_management='MANUAL'
_corrupted_rollback_segments='_SYSSMU1$','_SYSSMU2$','_SYSSMU3$','_SYSSMU4$','_SYSSMU5$','_SYSSMU6$','_SYSSMU7$','_SYSSMU8$','_SYSSMU9$','_SYSSMU10$
修改pfile.ora
修改引數
undo_tablespace=undotbs2
啟動資料庫
startup nomount pfile='d:\pfile.ora';
alter database mount;
alter database open;
匯出資料
expdp directory=dumpdir dumfile=kshk20171022.dmp schemas=ksnk
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24486203/viewspace-2146477/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00600: internal error code, arguments: [4194] 錯誤處理Error
- ORA-00600: internal error code, arguments: [4194]Error
- ora-00600:internal error code,arguments:[4194],[7],[2],[],[]Error
- oracle斷電重啟之ORA-00600[4194]Oracle
- ORA-00600: internal error code, arguments: [4194], [4], [31]Error
- ORA-00600: internal error code, arguments: [4194], [30], [30], [],Error
- 模擬一則ORA-600 [4194][][]故障並處理
- ORA-00600 Error的通用處理Error
- ORA-00600 [25027]問題處理
- ORACLE-00600 4194 斷電undo損壞處理過程Oracle
- 遭遇 ORA-00600: internal error code, arguments: [4194] ORA-1552Error
- While Solving ORA-00600 [4194]/[4193] Errors [ID 281429.1]WhileError
- ORA-00600 [krcpop_badfile]錯誤處理
- ORA-00600 [13013], [5001]故障處理
- ORA-00600: [kcratr_nab_less_than_odr]處理
- 簡單記錄一次ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600 [4194]/[4193] Errors Without Using Unsupported parameter-281429.1Error
- 系統crash掉導致ORA-00600的處理
- ora-00600 3020 問題分析處理
- ORA-00600 [kcrfr_update_nab_2]處理過程CRF
- ORA-00600:[keltnfy-ldmInit], [46]報錯處理
- ora-00600 [ktspgetmyb-1]問題的處理
- ORA-27090,ORA-00600: internal error code, arguments: [4194],的解決方法Error
- 【故障-ORACLE】ORA-00600: [qesmmCValStat4], [3], [1] 故障處理Oracle
- 【故障處理】偶遇ORA-00600: [keltnfy-ldmInit][46], [1], []
- 記一次無歸檔恢復ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: [kccpb_sanity_check_2]報錯處理一則
- 處理Oracle記憶體洩露 ORA-00600 [729] [space leak]Oracle記憶體洩露
- ORA-00600: [kcratr1_lastbwr]錯誤的處理辦法AST
- ORA-00600: internal error code, arguments: [15709], [29], [1]-故障處理Error
- ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]錯誤處理ErrorAST
- ORA-27090及ORA-00600: internal error code, arguments: [4194], [18], [4]的解決方法Error
- 伺服器時間異常造成ORA-00600 [2252]的故障處理伺服器
- 某省電信行業公司資料庫ORA-00600 [15160]處理行業資料庫
- 記一次ORA-00600: internal error code, arguments: [kdtdelrow-2]的處理Error
- ORA-00600:內部錯誤程式碼,引數:[qertbFetchByRowID],[],[],[],[],[],[],[]分析與處理
- 蘋果企業簽名—5G iPhone驍龍X55基帶+A14處理器?蘋果iPhone
- 多對一處理 和一對多處理的處理