- 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 :
SQL> drop diskgroup DATA including contents; drop diskgroup DATA including contents * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-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)
SQL> alter diskgroup DATA dismount; Diskgroup altered.
LOGIN TO NODE 1 ( WITH SYSASM):
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.
SQL> drop diskgroup DATA including contents; drop diskgroup DATA including contents * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-15001: diskgroup “DATA” does not exist or is not mounted