ORA-01109 错误

来源：互联网发布：个性头像制作软件编辑：程序博客网时间：2024/06/03 17:20

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> alter database open;

Database altered.

SQL>

SQL> select status from v$instance;

STATUS

------------

OPEN

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ WRITE

最终数据库恢复了

0 0