Step 1 ,查看日志 准确定位问题 发现如下日志信息:
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Started redo scan
Errors in file d:\oracle11g\administrator\diag\rdbms\local\orcl\trace\local_ora_2136.trc (incident=626739):
ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr], [], [], [], [], [], [], []
Incident details in: d:\oracle11g\administrator\diag\rdbms\orcl\local\incident\incdir_626739\local_ora_2136_i626739.trc
Aborting crash recovery due to error 600
Step 2 ,可以baidu
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL> recover database;
Media recovery complete.
SQL>
SQL>
SQL> alter database open;
Database altered.
SQL>
SQL>
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
最终数据库恢复了