在RAC ASM文件系统恢复到单机文件系统,open resetlogs 报错:

ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
ORA-600 signalled during: alter database open resetlogs...
Errors in file /u01/app/oracle/admin/orcl/udump/orcl_ora_10861.trc:
ORA-00313: open failed for members of log group 11 of thread 1
ORA-00312: online log 11 thread 1: '+DATA1/orcl/datafile/redo111'
ORA-17503: ksfdopn:2 Failed to open file +DATA1/orcl/datafile/redo111
ORA-15001: diskgroup "DATA1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-00312: online log 11 thread 1: '+DATA1/orcl/onlinelog/redo111'
ORA-17503: ksfdopn:2 Failed to open file +DATA1/orcl/onlinelog/redo111
ORA-15001: diskgroup "DATA1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager

 

在MOS上查询了一下,是一个bug:

To implement a solution for Bug:7207932, please execute any of the below alternative solutions:

  • Upgrade to 11.1

OR

  • Apply patchset 10.2.0.5 in which Bug:7207932 is fixed.

OR

OR

  • A possible workaround is to recreate the controlfile and specifying new filenames in the controlfile. If this does not work, then apply the patch for Bug:7207932.

 

即通过2种方法来实现:

1.打补丁,或者升级。

        1.shutdown database
        2.unzip  p7207932_10204_Linux-x86-64.zip
        3.cd 7207932
        4.$ORACLE_HOME/OPatch/opatch apply

2.重建控制文件,更新里面的路径。

        1.alter database backup controlfile to trace as '/u01/controlfile.log'
        2.recreate controlfile (更新里面redo的路径)