When you want to delete an ASM diskgroup, you might encounter the following error:
ORA-15027: active use of diskgroup “DATA” precludes its dismount
Getting rid of ASM diskgroup
So, I was doing some tests with Oracle ASM, but somehow I could not remove my ASM disk group.
SQL> drop diskgroup data including contents; drop diskgroup data including contents * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-15027: active use of diskgroup "DATA" precludes its dismount
Strange, I just created this, but I could not delete it. No database was using it!?
SQL> select * from v$asm_client; no rows selected
Forcing
WARNING: ALL DATA WILL BE LOST! MAKE SURE YOU HAVE BACKUPS!
Luckally one is able to force this all…
SQL> alter diskgroup data dismount force; SQL> drop diskgroup data force including contents; Diskgroup dropped.
Gone!
Thanks, you saved my day
Thanks Ian, your post helped me look in right direction.
I had somewhat similar situation today, the DATA disk group held the spfile due to which it did not allow me to drop the disk group. I could drop the disk group after I deleted the spfile from there.
SQL> drop diskgroup data;
drop diskgroup data
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15053: diskgroup “DATA” contains existing files
SQL> show parameter pfile
NAME TYPE VALUE
———————————— ———– ——————————
spfile string +DATA/asm/asmparameterfile/reg
istry.253.826304061
SQL> create pfile from spfile;
File created.
SQL> shutdown immediate
ASM diskgroups volume disabled
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup pfile=’/orabin/oracle/11.2.0.3/grid/dbs/init+ASM.ora’
ASM instance started
Total System Global Area 284008448 bytes
Fixed Size 2158616 bytes
Variable Size 256684008 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> alter diskgroup data mount;
Diskgroup altered.
SQL> drop diskgroup data;
Diskgroup dropped.
Thanks.
Amol,
Good to hear you solved your problem with a little help of this post :)
Cheers, Ian.
I just did this, new server, created diskgroup as NORMAL, didn’t realize til down with the GRID install.
this fixed it, you can’t use ASMCA you have to force it.