Hello,
I installed an ASM instance and created a DATA diskgroup using the Oracle installer. I would like to drop the diskgroup and re-create it using partitions instead of disk devices in order to use ASMLib.
I have not found a way to get rid of the DATA diskgroup yet. How do I get rid of it?
[+ASM@asm]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 3 20:12:05 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
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
I used the following for data_0000 - data_0005, thinking it would be a good idea to drop each disk before dropping the diskgroup - which worked, although I had to use force for data_0000;
SQL> alter diskgroup data drop disk data_0006;
... etc...
SQL> alter diskgroup data drop disk data_0000 force;
It all looks a bit weired now:
SQL> select name, header_status, path from v$asm_disk;
MEMBER /dev/sda
_DROPPED_0000_DATA UNKNOWN
DATA_0001 MEMBER /dev/sdb
DATA_0002 MEMBER /dev/sdc
DATA_0003 MEMBER /dev/sdd
DATA_0004 MEMBER /dev/sde
DATA_0005 MEMBER /dev/sdf
SQL> alter diskgroup data dismount force;
Diskgroup altered.
SQL> alter diskgroup data mount;
Diskgroup altered.
SQL>