Deleting DISK from DISKGROUP

Lets see how we can delete an ASM disk in DISKGROUP.
Currently, we have 3 disks in DATA diskgroup.











I want to drop disk1 from DATA diskgroup.

SQL> alter diskgroup data drop disk 'D:\ASMDISKS\DISK1';
alter diskgroup data drop disk 'D:\ASMDISKS\DISK1'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "D:\ASMDISKS\DISK1" does not exist in diskgroup "DATA"











SOLUTION : ONE has to use the name that has been designated in ASM, not as we have given it as disk1.

SQL> select path,name from v$asm_disk where group_number=1;









Here, Disk1 name is DATA_0000. Alter diskgroup data drop disk DATA_0000 will work;






DISK 1 deleted.
Lets check whether DISK1 deleted or not.
select path,name from v$asm_disk where group_number=1;







The DISK1 is no more in DATA diskgroup.