Database - RAC/Scalability (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center