Buddy Yuan的个人技术博客

在从10.2.0.4的rac,使用的是asm存储方式,再做异机恢复的时候.执行alter database open resetlogs的时候报错.错误如下所示:

Thu Aug 16 10:29:02 2012
Errors in file /oracle/admin/gbps/udump/gbps_ora_790642.trc:
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
ORA-600 signalled during: alter database open resetlogs...

在MOS上查询了一下,Bug 7207932  ORA-600 [KGEADE_IS_0] WHEN RENAMING A FILE FROM ASM TO FS.要解决这个错误需要在单实例的Oracle上打补丁7207932.打完补丁再次运行就没问题了.

p520b:/tmp/7207932>/oracle/product/10.2.0/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/product/10.2.0
Central Inventory : /oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.3
OUI version       : 10.2.0.4.0
OUI location      : /oracle/product/10.2.0/oui
Log file location : /oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-08-16_11-00-01AM.log

Lsinventory Output file location : /oracle/product/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2012-08-16_11-00-01AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2): 

Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0
There are 2 products installed in this Oracle Home.

Interim patches (1) :

Patch  7207932      : applied on Thu Aug 16 10:59:12 GMT+08:00 2012
   Created on 25 Sep 2008, 04:26:24 hrs PST8PDT
   Bugs fixed:
     7207932
p520b:/tmp/7207932>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 16 11:00:30 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 2181038080 bytes
Fixed Size                  2085496 bytes
Variable Size            1258294664 bytes
Database Buffers          905969664 bytes
Redo Buffers               14688256 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.

参考文档:Rman Restore From RAC ASM To Single Instance Non ASM Fails With ORA-00600 [kgeade_is_0] [ID 1146703.1]