Follow the below steps to drop the ASM Diskgroup.
1. Check the ASM diskgroup.
2. Drop ASM diskgroup.
3. Check the disk dropped from from ASM Diskgroup
1. Check the ASM Diskgroup
$sqlplus / as sysasm
set lines 999;
col diskgroup for a15
col diskname for a15
col path for a35
select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status
from v$asm_disk b, v$asm_diskgroup a
where a.group_number (+) =b.group_number
order by b.group_number,b.name;
2. Drop ASM diskgroup.
$sqlplus / as sysasm
SQL> DROP DISKGROUP ORA_DATA INCLUDING CONTENTS;
3. Check the disk dropped from from ASM Diskgroup
$sqlplus / as sysasm
set lines 999;
col diskgroup for a15
col diskname for a15
col path for a35
select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status
from v$asm_disk b, v$asm_diskgroup a
where a.group_number (+) =b.group_number
order by b.group_number,b.name;
