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.