今天有一台好久没有启动的数据库需要启动一下,结果在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 |
In this Document
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***
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
There was a disk problem that caused the database to crash.
Oracle is unable to perform instance recover but it works when is invoked manually.
Mount the database and issue a recover statement
SQL> startup mount;
SQL> recover database;
SQL> alter database open;
@ BUG:5382522 - FINIXUD: DB IS DOWN