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: 

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)

LOGIN TO NODE 1 ( WITH SYSASM):

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