【Oracle Asmデータリカバリ】ORA-00600 [kfdAuDealloc2]エラ解析

プロのOracle Databaseの復旧サービスを提供
携帯番号： +86 13764045638 メール：[email protected]

あるユーザーのASMインスタンスがORA-00600 [kfdAuDealloc2]エラになった、具体的なログは以下の通り：

Errors in file /opt/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_arb6_15539.trc:
ORA-00600: internal error code, arguments: [kfdAuDealloc2], [35], [272], [748], [], [], [], [], [], [], [], []
NOTE: stopping process ARB6
ERROR: ORA-600 thrown in ARB2 for group number 1
Errors in file /opt/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_arb2_15523.trc:
ORA-00600: internal error code, arguments: [kfdAuDealloc2], [148], [270], [720], [], [], [], [], [], [], [], []
NOTE: stopping process ARB2
ERROR: ORA-600 thrown in ARB3 for group number 1
Errors in file /opt/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_arb3_15527.trc:
ORA-00600: internal error code, arguments: [kfdAuDealloc2], [196], [271], [0], [], [], [], [], [], [], [], []
NOTE: stopping process ARB3
ERROR: ORA-600 thrown in ARB5 for group number 1
Errors in file /opt/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_arb5_15535.trc:
ORA-00600: internal error code, arguments: [kfdAuDealloc2], [363], [272], [1], [], [], [], [], [], [], [], []
NOTE: stopping process ARB5


Errors in file /u02/oracle/ASM/diag/asm/+asm/+ASM/trace/+ASM_rbal_27162.trc (incident=674120):
ORA-00600: internal error code, arguments: [kfdAuDealloc2], [101], [335], [300], [], [], [], [], [], [], [], []
Incident details in: /u02/oracle/ASM/diag/asm/+asm/+ASM/incident/incdir_674120/+ASM_rbal_27162_i674120.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ERROR: An unrecoverable error has been identified in ASM metadata. The instance will be taken down.
Sun Nov 25 20:51:11 2012
NOTE: AMDU dump of disk group DWHCTL1 created at /u02/oracle/ASM/diag/asm/+asm/+ASM/incident/incdir_674120
NOTE: starting check of diskgroup DWHCTL1
ERROR: file +dwhctl1.330.797592669: F330 PX11 => D0 A7650 => F385 PX135: fnum mismatch
ERROR: file +dwhctl1.330.797592669: F330 PX12 => D0 A7651 => F385 PX136: fnum mismatch

kfdAuDealloc2はKernel Files Disk AU DEALLOCateと意味している。それはASM DISKのAUを回収するために使われている 。このエラになった場合は ASM metadataのallocation tableがロジックデータが一致していないと意味している。

関連するbug :

Bug 5682184 OERI[kfdAuDealloc2] from resize/drop more than 16TB ASM file

Bug 10621169 I/O errors during RAC ASM recovery may drop redo and cause metadata corruptions / ORA-600

BUG 10017130 – ORA-600 [KFDAUDEALLOC2] DURING REBALANCE AFTER ADDING DISKS

このエラになったら、人工的にasm metadataをpatchしてください。