How to drop ASM Disks without a Diskgroup name
Hello DBAs,
I have 2 ASM that is not associated with a Diskgroup, how can I drop the ASM Disks?
SQL> select name, total_mb,free_mb, state from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB STATE
------------------------------ ---------- ---------- ---------------------------------
BIZT2_ARC_DG1 511996 511856 MOUNTED
BIZT2_DG1 1048572 637704 MOUNTED
DEV1_DATA1 511998 84058 MOUNTED
SQL>
SQL> select NAME, TOTAL_MB, FREE_MB, PATH, STATE, MOUNT_DATE from v$asm_disk order by 1;
NAME TOTAL_MB FREE_MB PATH STATE MOUNT_DATE
------------------------------ ---------- ---------- ---------------------------------------- ------------------------ -------------------
BIZP1_ARC_DG1_0000 511996 511856 /dev/emcpowerj1 NORMAL 09/09/2021 10:49:06
BIZP1_DG1_0000 1048572 637704 /dev/emcpoweri1 NORMAL 09/09/2021 10:50:36
DEV1_DATA1_0000 511998 84058 /dev/emcpowerb1 NORMAL 02/25/2021 10:08:28