ORA-00600: 内部错误代码问题处理

   很久没有开启自己电脑的数据库啦!电脑又时常非法关闭,断电等问题.然而今天想开启,居然报ORA-00600: 内部错误代码问题处理.

C:\Documents and Settings\litb>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 6月 22 20:14:51 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/oracle as sysdba;
已连接。
SQL> startup
ORA-01081: 无法启动已在运行的 ORACLE - 请首先关闭它
SQL> shutdown immediate
ORA-01109: 数据库未打开

已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  285212672 bytes
Fixed Size                  1248576 bytes
Variable Size              92275392 bytes
Database Buffers          188743680 bytes
Redo Buffers                2945024 bytes
数据库装载完毕。
ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr], [], [], [], [], [], [], []

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

数据库日志中显示:

Wed Jun 22 20:15:28 2011
Aborting crash recovery due to error 600
Wed Jun 22 20:15:28 2011
Errors in file e:\oracle\product\10.2.0\admin\ora10g\udump\ora10g_ora_3528.trc:
ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr], [], [], [], [], [], [], []

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

ora10g_ora_3528.trc中:

KCBS: disable_kcbsbpd is 0
KCBS: bufcnt = 2480, nb_kcbsds = 2480
KCBS: fbufcnt = 580
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 124
KCBS: nbseg[1] is 124
KCBS: nbseg[2] is 124
KCBS: nbseg[3] is 124
KCBS: nbseg[4] is 124
KCBS: nbseg[5] is 124
KCBS: nbseg[6] is 124
KCBS: nbseg[7] is 124
KCBS: nbseg[8] is 124
KCBS: nbseg[9] is 124
KCBS: nbseg[10] is 124
KCBS: nbseg[11] is 124
KCBS: nbseg[12] is 124
KCBS: nbseg[13] is 124
KCBS: nbseg[14] is 124
KCBS: nbseg[15] is 124
KCBS: nbseg[16] is 124
KCBS: nbseg[17] is 124
KCBS: nbseg[18] is 124
KCBS: nbseg[19] is 124
KCBS: Act cnt = 1395
KSOLS: Begin dumping all object level stats elements
KSOLS: Done dumping all elements. Exiting.
Dump event group for SESSION
Dump event group for SYSTEM
ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr], [], [], [], [], [], [], []
*** 2011-06-22 20:28:06.542
*** 2011-06-22 20:28:06.542 60680 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
*** 2011-06-22 20:28:07.654 60680 kcrr.c
ARCH: Archival disabled due to shutdown: 1089

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

处理方式:

SQL> shutdown immediate
ORA-01109: 数据库未打开

已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。

Total System Global Area  285212672 bytes
Fixed Size                  1248576 bytes
Variable Size              92275392 bytes
Database Buffers          188743680 bytes
Redo Buffers                2945024 bytes
数据库装载完毕。
SQL> recover database;
完成介质恢复。
SQL> alter database open;

数据库已更改。

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20948385/viewspace-700512/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20948385/viewspace-700512/