Subscribe YouTube Channel For More Live Tutorials
ORA-15073: diskgroup mounted by another instance
Error : While Dropping Diskgroup and its Contents
SQL> drop diskgroup FRA including contents; drop diskgroup FRA including contents * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-15073: diskgroup FRA is mounted by another ASM instance
Solution:
Before dropping diskgroup , Must dismount diskgroup on all other nodes. ( Note: Must be on mounted on Local Node).
If we have rac2 and rac3 remote Nodes , then dismount as follows:
SQL> alter diskgroup FRA dismount; Diskgroup altered.
Now drop the Diskgroup on local node : rac1
SQL> drop diskgroup FRA including contents; Diskgroup dropped.