【Oracle】ORA-00600: [kfgFinalize_2]，

【Oracle】ORA-00600: [kfgFinalize_2]，

環境：

OS：OEL5.6

RAC：10.2.0.1.0

[root@rac2 ~]# crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora....B1.inst application    ONLINE    ONLINE    rac1        

ora....B2.inst application    ONLINE    OFFLINE               

ora.RACDB.db   application    ONLINE    ONLINE    rac2        

ora....SM1.asm application    ONLINE    ONLINE    rac1        

ora....C1.lsnr application    ONLINE    ONLINE    rac1        

ora.rac1.gsd   application    ONLINE    ONLINE    rac1        

ora.rac1.ons   application    ONLINE    ONLINE    rac1        

ora.rac1.vip   application    ONLINE    ONLINE    rac1        

ora....SM2.asm application    ONLINE    ONLINE    rac2        

ora....C2.lsnr application    ONLINE    ONLINE    rac2        

ora.rac2.gsd   application    ONLINE    ONLINE    rac2        

ora.rac2.ons   application    ONLINE    ONLINE    rac2        

ora.rac2.vip   application    ONLINE    ONLINE    rac2 

rac的第二個節點執行個體無法啟動

嘗試手動啟動

[oracle@rac2 ~]$ export ORACLE_SID=RACDB2

[oracle@rac2 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 21 14:34:44 2014

 

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

 

Connected to an idle instance.

 

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATA/RACDB/spfileRACDB.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATA/RACDB/spfileRACDB.ora

ORA-15056: additional error message

ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/racdb/spfileracdb.ora

ORA-17503: ksfdopn:2 Failed to open file +DATA/racdb/spfileracdb.ora

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-06512: at line 4

顯示diskgroup沒有mount

那麼去ASM下查看diskgroup的狀態，並嘗試mount

[oracle@rac2 ~]$ export ORACLE_SID=+ASM2

[oracle@rac2 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 21 14:41:59 2014

 

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

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

 

 

SQL> desc v$asm_diskgroup;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 GROUP_NUMBER                                       NUMBER

 NAME                                               VARCHAR2(30)

 SECTOR_SIZE                                        NUMBER

 BLOCK_SIZE                                         NUMBER

 ALLOCATION_UNIT_SIZE                               NUMBER

 STATE                                              VARCHAR2(11)

 TYPE                                               VARCHAR2(6)

 TOTAL_MB                                           NUMBER

 FREE_MB                                            NUMBER

 REQUIRED_MIRROR_FREE_MB                            NUMBER

 USABLE_FILE_MB                                     NUMBER

 OFFLINE_DISKS                                      NUMBER

 UNBALANCED                                         VARCHAR2(1)

 COMPATIBILITY                                      VARCHAR2(60)

 DATABASE_COMPATIBILITY                             VARCHAR2(60)

 

SQL> select NAME,STATE from v$asm_diskgroup;

 

NAME                           STATE

------------------------------ -----------

FRA                            DISMOUNTED

DATA                           DISMOUNTED

 

SQL> alter diskgroup DATA mount;

alter diskgroup DATA mount

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kfgFinalize_2], [], [], [], [], [],

[], []

報了ORA-600: [kfgFinalize_2]

上網查證之後：

ASM異常崩潰後，可能會導致ASM執行個體第一次重啟出現異常，報ORA-600: [kfgFinalize_2]

最終的解決方案就是停止所有節點上的ASM，重啟即可。

ORA-00600 解 ；是ORACLE 專家表現的時了

[kccpb_sanity_check_2] indicates that the seq# of the last read block is
higher than the seq# of the control file header block. This is indication of
the lost write of the header block during commit of the previous cf
transaction.

因該是資料庫損壞了，導致塊內的SEQ#不正確。建議在有備份的情況下還原資料，否則的話需要專家做資料修複。 如果不是生產庫的話，建議重建
 
對於Oracle ORA-00600 錯誤碼解析

ORA-600[4137] transaction id不匹配，問題可能存在與復原段中或者對象本身存在訛誤 While backing out an undo record (i.e. at the time of rollback) we found a transaction id mis-match indicating either a corruption in the rollback segment or corruption in an object which the rollback segment is trying to apply undo records on.
This would indicate a corrupted rollback segment. Undo/Redo

DESCRIPTION:

While backing out an undo record (i.e. at the time of rollback) we found a
transaction id mis-match indicating either a corruption in the rollback
segment or corruption in an object which the rollback segment is trying to
apply undo records on.

這個需要patch undo來修複

如果自己搞不定可以找詩檀軟體專業ORACLE資料庫修複團隊成員幫您恢複!

詩檀軟體專業資料庫修複團隊