We know that in the database each and every  “Error “has its own reasons. Let’s have look on Error ORA-15073: Diskgroup Mounted By Another Instance. This article explains the cause and action for this error.

Cause: An attempt was made to drop a diskgroup that is still
mounted somewhere in the cluster by another instance.

Action: dismount the diskgroup from all nodes except the one
performing the drop diskgroup command.

 

 

While dropping a diskgroup, an error may come like ORA-15073: diskgroup mounted by another instance.

Problem: 

SQL> drop diskgroup NSMREDOA including contents;
drop diskgroup NSMREDOA including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15073: diskgroup NSMREDOA is mounted by another ASM instance.

Solution:
For rac with multiple node, you have to dismount the diskgroup on all the remote nodes.( excluding the local node)
Suppose for 2 node rac, i have logged to node 2 and dismounted the diskgroup and ran the drop command on node 1.

LOGIN TO NODE2 ( WITH SYSASM)

SQL> alter diskgroup NSMREDOA dismount;

Diskgroup altered.

LOGIN TO NODE 1 ( WITH SYSASM):

SQL> drop diskgroup NSMREDOA including contents;

Diskgroup dropped.

NOTE: If you try to drop the diskgroup on the same node, where you have dismounted, then below error will come.

SQL> drop diskgroup NSMREDOA including contents;
drop diskgroup NSMREDOA including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup “NSMREDOA” does not exist or is not mounted

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.