プロのOracle Databaseの復旧サービスを提供
携帯番号： +86 13764045638 メール：service@parnassusdata.com
あるユーザーの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してください。
Comment