ASM - Disk Operations

DROP DISKGROUP

SQL> column HEADER_STATUS format a20
SQL> set pages 100
SQL> col PATH format a25
SQL> SELECT name, header_status, path FROM V$ASM_DISK ;

NAME                           HEADER_STATUS        PATH
------------------------------ -------------------- -------------------------
                               CANDIDATE            /dev/asm-disk8
                               CANDIDATE            /dev/asm-disk6
                               CANDIDATE            /dev/asm-disk7
DATA_0000                      MEMBER               /dev/asm-disk1
DATA2_0000                     MEMBER               /dev/asm-disk4
DATA_0002                      MEMBER               /dev/asm-disk3
DATA2_0001                     MEMBER               /dev/asm-disk5
DATA_0001                      MEMBER               /dev/asm-disk2

DROP DISKGROUP DATA2 INCLUDING CONTENTS;
drop diskgroup DATA2 force including contents;

Rac-Node2

oracle@testdbrac2:/oracle:>grid_env
oracle@testdbrac2:/oracle:>sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 28 10:49:18 2013

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 Real Application Clusters and Automatic Storage Management options

SQL>  select GROUP_NUMBER, NAME, state from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE
------------ ------------------------------ -----------
           1 DATA                           MOUNTED
           2 DATA2                          MOUNTED

SQL> alter diskgroup DATA2 dismount;

Diskgroup altered.

SQL> select GROUP_NUMBER, NAME, state from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE
------------ ------------------------------ -----------
           1 DATA                           MOUNTED
           0 DATA2                          DISMOUNTED