在从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]
Post a Comment