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

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!

Tagged , . Bookmark the permalink.

4 Responses to ORA-15027: active use of diskgroup “DATA” precludes its dismount

  1. Tamas Foldi says:

    Thanks, you saved my day

  2. Amol says:

    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.

  3. Alex says:

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *