ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []

今天有一台好久没有启动的数据库需要启动一下，结果在open的时候失败了，ORA-00600.

SQL> startup

ORACLE instance started.

Total System Global Area 1577058304 bytes

Fixed Size 2084264 bytes

Variable Size 1040187992 bytes

Database Buffers 520093696 bytes

Redo Buffers 14692352 bytes

Database mounted.

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []

出现这个问题的原因是oracle不能执行实例恢复，只有手工完成介质恢复后才可以打开。

如果在错误信息中，出现别的，例如ORA-372错误，则需要根据情况使用其他的方法处理。

SQL> select open_mode from v$database;

 

OPEN_MODE

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

MOUNTED

 

SQL> recover database;

Media recovery complete.

SQL> alter database open;

 

Database altered.

至此，数据库成功OPEN。

 

 

 

 

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

ORA-00600:[Kcratr1_lastbwr] During Database Startup after a Crash [ID 393984.1]

转到底部

---

修改时间:2012-7-11 类型:PROBLEM 状态:PUBLISHED 优先级:3

注释 (0)

In this Document

Symptoms

 

Changes

 

Cause

 

Solution

 

References

---

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.1 to 11.1.0.6 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 13-Sep-2010***

Symptoms

After a disk failure that caused the database to crash, the instance fails to start up with ORA-00600: arguments: [kcratr1_lastbwr].

The alert log file shows the following entries :

Completed: ALTER DATABASE MOUNT
Tue Sep 19 09:43:03 2006
ALTER DATABASE OPEN
Block change tracking file is current.
Tue Sep 19 09:43:04 2006
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Tue Sep 19 09:43:04 2006
Started redo scan
Tue Sep 19 09:43:05 2006
Errors in file gns80_ora_9936.trc:
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []
Tue Sep 19 09:43:06 2006
Aborting crash recovery due to error 600

 

 

 

 

Changes

There was a disk problem that caused the database to crash.

Cause

Oracle is unable to perform instance recover but it works when is invoked manually.

Solution

Mount the database and issue a recover statement

SQL> startup mount;

SQL> recover database;

SQL> alter database open;

 

References

@ BUG:5382522 - FINIXUD: DB IS DOWN