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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24486203/viewspace-2146477/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24486203/viewspace-2146477/