Dropping diskgroup resulting in ORA-15039: diskgroup not dropped, ORA-15073: diskgroup IPDBFBKP is mounted by another ASM instance

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    Dropping diskgroup resulting in ORA-15039: diskgroup not dropped, ORA-15073: diskgroup IPDBFBKP is mounted by another ASM instance

Symptoms:

SQL> DROP DISKGROUP IPDBFBKP INCLUDING CONTENTS;
DROP DISKGROUP IPDBFBKP INCLUDING CONTENTS
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15073: diskgroup IPDBFBKP is mounted by another ASM instance


SQL> ALTER DISKGROUP IPDBFBKP DISMOUNT;

Diskgroup altered.

SQL> DROP DISKGROUP IPDBFBKP INCLUDING CONTENTS;
DROP DISKGROUP IPDBFBKP INCLUDING CONTENTS
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "IPDBFBKP" does not exist or is not mounted


SQL> ALTER DISKGROUP IPDBFBKP mount;

Diskgroup altered.

Solution:

Diskgroup was mounted on other nodes, dismount it then drop it

References:

Get Oracle Certifications for all Exams
Free Online Exams.com