Drop Unmounted Diskgroup

<<Back to Oracle Main Page

How to Drop Unmounted Diskgroup

You can drop an unmounted diskgroup from ASM with force option. You will encounter error if you will not specify force and including keywords

SQL>drop diskgroup TEST_DG force INCLUDING contents;

SQL> drop diskgroup TEST_DG ;
drop diskgroup TEST_DG
*
ERROR at line 1:
ORA-15039: diskgroup not dropped

ORA-15001: diskgroup "TEST_DG" does not exist or is not mounted

SQL> select name ,state from v$asm_diskgroup;

NAME            STATE
--------------- -----------
TEST_DG         DISMOUNTED
DG_TEST_DATA    MOUNTED
DG_TEST_FRA     MOUNTED
DG_TEST_REDO    MOUNTED
DG_FORCE        MOUNTED

SQL> drop diskgroup TEST_DG force INCLUDING contents;
Diskgroup dropped.