ORA-01109 错误

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

最终数据库恢复了