同事前一阵子搬着台式机出去演示,回来时候,特豪迈地拔电源,装车走人;回来后悲催地发现数据库普通用户登录失败,数据库首先出现ORA-01033:ORACLE initialization or shutdown;然后按照网上指导
在DOS环境下
sqlplus /NOLOG
SQL>connect sys/sys as sysdba
SQL>shutdown normal
SQL>startup mount
SQL>alter database open;
然后 ,数据库服务器出现ORA-00600[kcratr_nab_less_than_odr],不能open数据库
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [1984], [219……
遇到的错误是上面红色部分,不完整,当时没记录,后面的数字好像没什么特殊,按照下面步骤做,一样能完成open。
SQL> ALTER DATABASE OPEN;
ALTER DATABASE OPEN
*
第 1 行出现错误:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [99189],
[43531], [43569], [], [], [], [], [], [], []
2.查看alert日志
Wed Jan 11 13:56:16 2012
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Started redo scan
Completed redo scan
read 54591 KB redo, 0 data blocks need recovery
Errors in file d:\dbdms\diag\rdbms\dbdms\dbdms\trace\dbdms_ora_3108.trc (incident=818557):
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], []
Incident details in: d:\dbdms\diag\rdbms\dbdms\dbdms\incident\incdir_818557\dbdms_ora_3936_i818557.trc
Aborting crash recovery due to error 600
Errors in file d:\dbdms\diag\rdbms\dbdms\dbdms\trace\dbdms_ora_3108.trc:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [99189], [4