Error : ORA-00600:[KFDARELOCSET10] DURING ASM REBALANCE

Error : ORA-00600:[KFDARELOCSET10] DURING ASM REBALANCE 

Cause :

Rebalance operation can be initiated because of disk being added or manual rebalance.

Cause of the crash is observed to be the UNPROTECTED files created in the diskgroup.

Issue is verified in UNPUBLISHED Bug 12319359 - SOL-X64-SC:HIT ASM ORA-00600:[KFDARELOCSET10], [3], [256], [3], [1], [1], [65535]

 

Solution :



The use of UNPROTECTED files is not recommended in production environments.


If the file that is causing the issue is a tempfile, we can drop it first and then start the rebalance to avoid the error.

SQL> select group_number,file_number,blocks,bytes,space,redundancy,striped,REDUNDANCY_LOWERED,MODIFICATION_DATE 
from v$asm_file where group_number=1 and file_number=290;

SQL> select * from v$asm_alias where group_number=1 and file_number=290;
-- change the group_number and file_number based on the arguments of the ORA-600 error.

SQL> alter tablespace TEMP drop tempfile <file_name>

  • February 22, 2019 | 18 views
  • Comments