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
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
--------------- -----------
TEST_DG DISMOUNTED
DG_TEST_DATA MOUNTED
DG_TEST_FRA MOUNTED
DG_TEST_REDO MOUNTED
DG_FORCE MOUNTED
Diskgroup dropped.
Comments
Post a Comment