How to change Failgroup Of an ASM Disk

 

Changing Failgroup Of an ASM Disk

In many situations its required to alter the failgroup of a disk in an ASM diskgroup, for example while adding the disk you did typo while typing the failgroup name and you realized only after the disk is added to wrong failgroup.

There is no other way but only drop and add the disk to right failgroup. Steps are here

Step1: Identify the disks in wrong failgroup.

set line 200
col name format a20
col path format a40
select path,failgroup,mount_status,mode_status,header_status,state from v$asm_disk where GROUP_NUMBER=1 order by failgroup, path;

Step2: Drop the disks (identified disks) in wrong failgroup

ALTER DISKGROUP DATA DROP DISK  DC1_DISK11 REBALANCE POWER 20;

Step3: Wait for Rebalance Operation to complete

select GROUP_NUMBER,OPERATION,STATE,EST_WORK,EST_MINUTES from gv$asm_operation;

Step4: Add the disk in correct failgroup

ALTER DISKGROUP DATA ADD FAILGROUP DC01 DISK 'ORCL:DC01_DISK11' NAME DC01_DISK11 SIZE 10240 M rebalance power 20;

Step5: Wait for Rebalance Operation to complete

select GROUP_NUMBER,OPERATION,STATE,EST_WORK,EST_MINUTES from gv$asm_operation;

Step6: Verify the disk is in correct failgroup

set line 200

col name format a20
col path format a40
select path,failgroup,mount_status,mode_status,header_status,state from v$asm_disk where GROUP_NUMBER=1 order by failgroup, path;