ORA-15027: active use of diskgroup precludes its dismount

ORA-15027: active use of diskgroup “DG_DATA” precludes its dismount

Getting below error when dropping ASM diskgroup;

ORA-15027: active use of diskgroup “DG_DATA” precludes its dismount

Cause:  Diskgroup is having active datafiles.

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 “DG_DATA” precludes its dismount

SQL> select * from v$asm_client;

SQL> show parameter spfile

spfile string +DG_DATA/asm/asmparameterfile/registry.265.854015545

SQL> drop diskgroup dg_data;

drop diskgroup data

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-15053: diskgroup “DG_DATA” contains existing files

Solution:

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate

ASM diskgroups volume disabled

ASM diskgroups dismounted

ASM instance shutdown

SQL> startup pfile=’/u01/bkp/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 dg_data mount;

Diskgroup altered.

SQL> drop diskgroup dg_data including contents;

Diskgroup dropped.