DROP DISKGROUP

To Drop a diskgroup if should be mounted only by the ASM instance
dropping the diskgroup and no other Instance


SQL> drop diskgroup RECOVERY including contents;

Diskgroup dropped.

SQL>


ADD DISK TO DISKGROUP

SQL> alter diskgroup data add disk '/dev/oracleasm/disks/VOL3';

Diskgroup altered.

SQL>


DROP DISK FROM DISKGROUP

SQL> alter diskgroup data drop disk DATA_0000;

Diskgroup altered.

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES
-----------
1 REBAL RUN 1 1 186 1648 586
2



SQL> /

GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES
-----------
1 REBAL RUN 1 1 535 1517 393
2

CHANGE THE REBALANCE POWER

SQL> ALTER DISKGROUP DATA REBALANCE POWER 8;

Diskgroup altered.

SQL> SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES
-----------
1 REBAL RUN 8 0 0 1183 0
0


SQL>