打开数据库时报ORA-00600

無限追云

环境:
DB:

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

OS:
$ cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 8)

这是一个生产库的克隆环境，作为平时测试使用。我登陆进去的时候，发现数据库处于nomount状态。
oracle@wimngNB_test:~ $ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 7 13:31:29 2012

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

SQL> conn / as sysdba
Connected.
SQL> select status from v$instance;

STATUS
------------
STARTED

SQL> SELECT OPEN_MODE FROM V$DATABASE;
SELECT OPEN_MODE FROM V$DATABASE
                      *
ERROR at line 1:
ORA-01507: database not mounted


SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00214: control file '/orasys/flash_recovery_area/wimng2/control02.ctl'
version 140340 inconsistent with file '/data/oradata/wimng2/control01.ctl'
version 140332


我google之后，做了如下操作:
SQL> alter system set control_files='/orasys/flash_recovery_area/wimng2/control02.ctl' scope=spfile;

System altered.

SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 2042241024 bytes
Fixed Size                  1337548 bytes
Variable Size            1509951284 bytes
Database Buffers          520093696 bytes
Redo Buffers               10858496 bytes
Database mounted.

数据库mount上了，但是open的时候报ORA-00600错误:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[1468], [57304], [57605], [], [], [], [], [], [], []


SQL> select status from v$instance;

STATUS
------------
MOUNTED

Google了下00600错误，我是不是可以做以下操作:
SQL>recover database;
SQL>alter database open;

PS:毕竟是第一次遇到ORA-00600，不敢随便乱动了..

無限追云

这是相应的trace文件

無限追云

谢谢Liu,明天回去后问下测试环境的存储

生产环境是HP 380服务器，5块磁盘做了RAID5

無限追云

Liu,生产环境是HP DL388G7,4块硬盘做的RAID5.

测试环境是虚拟环境，虚拟化出来的。

無限追云

问题解决了。
SQL> recover database until cancel using backup controlfile;
还是报错，后来我参照了惜分飞的方法，重做了controlfile
http://www.xifenfei.com/2347.html

谢谢Liu，谢谢分飞兄