Saturday, 19 March 2016

Drop last active Diskgroup in Oracle 11g ASM

This document will describe how to drop the last active Diskgroup in Oracle 11g ASM.
In my testing virtual box i installed standalone Grid 11g with ASM on Oracle Linux 6.4
i simulated the scenario to drop the last active disk group.

First tried to drop the last active diskgroup, Oracle thrown  the error like below.

SQL> drop diskgroup data including contents;
drop diskgroup data including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15027: active use of diskgroup "DATA" precludes its dismount


Solution:- dismount the active diskdroup with force.

SQL> alter diskgroup data dismount force;

Diskgroup altered.

Drop the dismounted diskdroup using force.

SQL> drop diskgroup data force including contents;

Diskgroup dropped.

Verify  the diskgroups.

SQL> select * from V$ASM_DISKGROUP;

no rows selected

No comments:

Post a Comment