ORA-15039: diskgroup not dropped

You would get this error when you try to drop an ASM diskgroup that is mounted by an another ASM instance as well e.g. in case of Oracle RAC database clusters, ASM diskgroup shared/mounted by all cluster nodes in oracle RAC configuration.

ASMCMD> dropdg EBS_DATA

ORA-15039: diskgroup not dropped

ORA-15073: diskgroup EBS_DATA is mounted by another ASM instance (DBD ERROR: OCIStmtExecute)

ASMCMD>

Let's verify what all instances have mounted this EBS_DATA diskgroup with following command.

SQL> select inst_id, name, state from gv$asm_diskgroup;

   INST_ID NAME                           STATE
---------- ------------------------------ -----------
         2 VOTEDATA                       MOUNTED
         2 ORCL_DATA                      MOUNTED
         2 ORCL_FRA                       MOUNTED
         2 EBS_DATA                       MOUNTED
         1 VOTEDATA                       MOUNTED
         1 ORCL_DATA                      MOUNTED
         1 ORCL_FRA                       MOUNTED
         1 EBS_DATA                       MOUNTED

8 rows selected.

In above output, you can see that EBS_DATA diskgroup has been mounted by INST_ID=1 and INST_ID=2. 

Now let's go to node 2 and dismount the EBS_DATA diskgroup by logging to ASM instance as "SYSASM"

SQL> alter diskgroup ebs_data dismount;

Diskgroup altered.


SQL>

ASMCMD> lsdg

State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576   1024000    92279                0           92279              0             N  ORCL_DATA/
MOUNTED  EXTERN  N         512   4096  1048576    307200   307101                0          307101              0             N  ORCL_FRA/
MOUNTED  NORMAL  N         512   4096  1048576   1024000  1023705           256000          383852              0             N  EBS_DATA/
MOUNTED  HIGH    N         512   4096  1048576     51200    49944            20480            9821              0             Y  VOTEDATA/

Now try to drop the diskgroup, and it works.

ASMCMD> dropdg ebs_data

ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576   1024000    92279                0           92279              0             N  ORCL_DATA/
MOUNTED  EXTERN  N         512   4096  1048576    307200   307101                0          307101              0             N  ORCL_FRA/
MOUNTED  HIGH    N         512   4096  1048576     51200    49944            20480            9821              0             Y  VOTEDATA/
ASMCMD>

Hope it helps, subscribe to this blog to stay updated on latest Oracle Technologies and new articles.

Twitter : @rajsoft8899
Linkedin : https://www.linkedin.com/in/raj-kumar-kushwaha-5a289219/