ORA-00600 [4194], [55]處理

shawnloong發表於2017-10-26
今天遇見客戶報故障,資料庫無法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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24486203/viewspace-2146477/,如需轉載,請註明出處,否則將追究法律責任。

相關文章