Removing Disk from a ASM diskgroup

Posted: November 22, 2013 in ASM

Steps to remove a disk from a ASM diskgroup

So we have the following disks and the plan is to remove VOLE

SQL> select group_number, name, TOTAL_MB, FREE_MB from V$asm_disk_stat;

GROUP_NUMBER NAME TOTAL_MB FREE_MB
------------ ------------------------------ ---------- ----------
0 1019 0
1 VOLA 1019 842
1 VOLB 1019 841
1 VOLC 1019 841
2 VOLD 1019 792
1 VOLE 1019 841

Drop the disk from the Disk group

SQL> alter diskgroup DATADG drop disk 'VOLE';

Diskgroup altered.

Check the re-balance status

SQL> select sysdate, GROUP_NUMBER, OPERATION, STATE, POWER, ACTUAL, SOFAR, EST_WORK
2 EST_RATE, EST_MINUTES from v$asm_operation;

SYSDATE GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_RATE
--------- ------------ ----- ---- ---------- ---------- ---------- ----------
EST_MINUTES
-----------
12-SEP-08 1 REBAL RUN 1 1 1 193
3

Now the disk is not assigned to a disk group

SQL> select group_number, name, TOTAL_MB, FREE_MB from V$asm_disk_stat;

GROUP_NUMBER NAME TOTAL_MB FREE_MB
------------ ------------------------------ ---------- ----------
0 1019 0
1 VOLA 1019 783
1 VOLB 1019 783
1 VOLC 1019 782
2 VOLD 1019 792

Check the disk status now VOLE should be listed as FORMER and is ready to be re-used

SQL> select PATH, HEADER_STATUS, MODE_STATUS, STATE from v$asm_disk;
PATH HEADER_STATU MODE_ST STATE
-----------
ORCL:VOLE FORMER ONLINE NORMAL
ORCL:VOLF PROVISIONED ONLINE NORMAL
ORCL:VOLA MEMBER ONLINE NORMAL
ORCL:VOLB MEMBER ONLINE NORMAL
ORCL:VOLC MEMBER ONLINE NORMAL
ORCL:VOLD MEMBER ONLINE NORMAL
6 rows selected.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s