问题现象
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL> startup
ORACLE instance started.
Total System Global Area 893386752 bytes
Fixed Size 2088024 bytes
Variable Size 226493352 bytes
Database Buffers 658505728 bytes
Redo Buffers 6299648 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], []
alert日志报的错误为:
Mon Jun 17 10:53:50 2013
ALTER DATABASE OPEN
Mon Jun 17 10:53:50 2013
Beginning crash recovery of 1 threads
Mon Jun 17 10:53:50 2013
Started redo scan
Mon Jun 17 10:53:50 2013
Errors in file /u01/app/oracle/admin/vdb1/udump/vdb1_ora_8240.trc:
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
Mon Jun 17 10:53:51 2013
Aborting crash recovery due to error 600
Mon Jun 17 10:53:51 2013
Errors in file /u01/app/oracle/admin/vdb1/udump/vdb1_ora_8240.trc:
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
问题原因
可能是由于异常关机所致。
问题解决:
SQL> startup
ORACLE instance started.
Total System Global Area 893386752 bytes
Fixed Size 2088024 bytes
Variable Size 226493352 bytes
Database Buffers 658505728 bytes
Redo Buffers 6299648 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], []
SQL> recover database;
Media recovery complete.
SQL> alter database open;
Database altered.