- 07 Dec, 2023
- 0 Comments
- 50 Secs Read
ORA-15073: Diskgroup Mounted By Another Instance
While dropping a diskgroup, error may come like ORA-15073: diskgroup mounted by another instance.
Problem :
1 2 3 4 5 6 | SQL> drop diskgroup DATA including contents;drop diskgroup DATA including contents*ERROR at line 1:ORA-15039: diskgroup not droppedORA-15073: diskgroup DATA is mounted by another ASM instance |
Solution:
In RAC , you have to dismount the diskgroup on all the remote nodes.( except 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)
1 2 3 | SQL> alter diskgroup DATA dismount;Diskgroup altered. |
LOGIN TO NODE 1 ( WITH SYSASM):
1 2 3 | SQL> drop diskgroup DATA 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.
1 2 3 4 5 6 | SQL> drop diskgroup DATA including contents;drop diskgroup DATA including contents*ERROR at line 1:ORA-15039: diskgroup not droppedORA-15001: diskgroup “DATA” does not exist or is not mounted |