在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
-
Download and apply interim Patch:7207932, if available for your platform and RDBMS release.
To check for conflicting patches, please use the MOS Patch Planner Tool
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的路径)