Changing the Oracle ASM Disk Group Name

Changing the ASM disk group name from +IMPHAL to +IMPHAL_DG

Monday Morning (between 9-11am ) is definitely not the right time to do any installation.... Ahmmm

One fine Monday morning I did the gird installation and created the disk group name as IMPHAL.As per our customer's standard , any diskgroup name should/must have a suffix of _DG.

From ASM command line or from ASMCA if you try to drop the disk you will get the following error

SQL> select name from v$asm_diskgroup;

NAME

------------------------------

IMPHAL

SYDNEY_DG

MELB_DG

SQL> drop diskgroup IMPHAL including contents;

drop diskgroup IMPHAL including contents

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-15027: active use of diskgroup "IMPHAL" precludes its dismount

To resolve this above problem , use the following

SQL>

SQL> alter diskgroup IMPHAL dismount force;

Diskgroup altered.

SQL> drop diskgroup IMPHAL force including contents;

Diskgroup dropped.

And its gone....

Check the disk group details again

SQL> select name from v$asm_diskgroup;

NAME

------------------------------

SYDNEY_DG

MELB_DG