Monday, June 24, 2013

ORA-15039: diskgroup not dropped

I had to drop one disk group on a two node RAC cluster and came up with this below error.

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


Well the message tells it all, the same diskgroup is being  mounted on second node, therefore dismount it on node 2 first as below and drop it accordingly


SQL> alter diskgroup DATA_DG dismount;

Diskgroup altered.


Once the diskgroup is dsimounted above on node1, come back on node 2 and run  below

SQL> DROP DISKGROUP DATA_DG;

Diskgroup dropped.


Note: All above commands are executed as a 'grid' user by logging oto sqlplus as sysasm

No comments:

Post a Comment