How to add and drop ASM disks

When a disk is dropped, the disk group is rebalanced by moving all of the file extents from the dropped disk
to other disks in the disk group.

Use below syntax to add and drop disks in a single command:

Login into ASM instance as sysasm:

SQL> alter diskgroup <DG_NAME_1> add disk '<disk path>' <DISK_NAME1>
drop disk <DISK_NAME_TO_BE_DROPPED>;

Multiple disks can be added and dropped and make sure that the size of the disks to be added and dropped should be the same.

Example:

1. Check the candidate disks to be added disk in ASM Diskgroup:

grid@UATDB:~$ sqlplus / as sysasm
 SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 16 11:13:44 2022
 Copyright (c) 1982, 2014, Oracle.  All rights reserved.
  Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
 SQL>
 SQL> set line 400
SQL> select DISK_NUMBER, GROUP_NUMBER, HEADER_STATUS,PATH from v$asm_disk;
 DISK_NUMBER GROUP_NUMBER HEADER_STATU PATH
----------- ------------ ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
          0            0 CANDIDATE    /dev/rdsk/c1d7s6
          1            0 CANDIDATE    /dev/rdsk/c1d10s6
          2            0 CANDIDATE    /dev/rdsk/c1d12s6
          3            0 CANDIDATE    /dev/rdsk/c1d13s6
          4            0 CANDIDATE    /dev/rdsk/c1d11s6
          5            0 CANDIDATE    /dev/rdsk/c1d15s6
          6            0 CANDIDATE    /dev/rdsk/c1d9s6
          0            2 MEMBER       /dev/rdsk/c1d18s6
          1            2 MEMBER       /dev/rdsk/c1d19s6
          3            2 MEMBER       /dev/rdsk/c1d20s6
          2            2 MEMBER       /dev/rdsk/c1d21s6
 DISK_NUMBER GROUP_NUMBER HEADER_STATU PATH
----------- ------------ ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
          3            1 MEMBER       /dev/rdsk/c1d22s6
          4            2 MEMBER       /dev/rdsk/c1d23s6
          5            2 MEMBER       /dev/rdsk/c1d24s6
 14 rows selected.
 --------------------------

2. ADD and Drop disks from and to  ‘DATA’  Disk group:

SQL> alter diskgroup DATA add disk '/dev/rdsk/c1d15s6','/dev/rdsk/c1d11s6','/dev/rdsk/c1d13s6','/dev/rdsk/c1d12s6','/dev/rdsk/c1d7s6','/dev/rdsk/c1d9s6' drop disk DATA_0000,DATA_0001,DATA_0002,DATA_0003,DATA_0004,DATA_0005  rebalance power 10;

3.Check the rebalance status:

SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;
    INST_ID OPERA STAT      POWER      SOFAR   EST_WORK   EST_RATE EST_MINUTES
---------- ----- ---- ---------- ---------- ---------- ---------- -----------
         1 REBAL RUN          10      56121     274196      23946           9
         1 REBAL WAIT         10          0          0          0           0
         1 REBAL WAIT         10
         1 REBAL WAIT         10

4.After finishing the rebalancing the dropped disks status will be changed to ‘Former’:

SQL> set line 400;
SQL> /
 DISK_NUMBER GROUP_NUMBER HEADER_STATU PATH
----------- ------------ ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
          0            0 FORMER       /dev/rdsk/c1d19s6
          1            0 FORMER       /dev/rdsk/c1d24s6
          7            0 FORMER       /dev/rdsk/c1d21s6
          6            0 FORMER       /dev/rdsk/c1d22s6
          5            0 FORMER       /dev/rdsk/c1d18s6
          4            0 FORMER       /dev/rdsk/c1d16s6
          3            0 FORMER       /dev/rdsk/c1d20s6
          2            0 FORMER       /dev/rdsk/c1d23s6
          1            1 MEMBER       /dev/rdsk/c1d10s6
          7            2 MEMBER       /dev/rdsk/c1d11s6
          9            2 MEMBER       /dev/rdsk/c1d12s6
 DISK_NUMBER GROUP_NUMBER HEADER_STATU PATH
----------- ------------ ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
          8            2 MEMBER       /dev/rdsk/c1d13s6
          6            2 MEMBER       /dev/rdsk/c1d15s6
         10            2 MEMBER       /dev/rdsk/c1d7s6
         11            2 MEMBER       /dev/rdsk/c1d9s6
 15 rows selected.
SQL>

5.And the rebalance status will return zero rows:

SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;
 no rows selected
 SQL>

HP Elite Desktop PC Computer | Intel Quad-Core i5 | 8GB Ram | 1TB HDD | 24 Inch LCD Monitor (1080p HDMI), RGB Keyboard + Mouse | Desk Speakers | WiFi + Bluetooth | Windows 10 (Renewed)

(738)

11% Off $156.00 $139.00 (as of 07/07/2024 16:40 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

[INTEL POWERED MULTI-TASKING] - Built with a quad-core Intel i5 processor and 8GB of DDR3 RAM; Perfect as a home office computer, remote learning, or media center [LATEST WIRELESS TECH] - This HP Desktop Computer easily connects to the internet throu... read more

Hiearcool USB C Hub, USB C Multi-Port Adapter for MacBook Pro, 7IN1 USB C to HDMI Hub Dongle Compatible for USB C Laptops and Other Type C Devices (4K HDMI USB3.0 SD/TF Card Reader 100W PD)

(48391)

8% Off $24.99 $22.99 (as of 07/07/2024 16:54 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

UL/SGS Approved Hiearcool USB C Hub: The intelligent USB C Adapter has perfectly combined all the functions you need. USB C to HDMI hub equipped with USB3.0 x2, 4K@30 HDMI, SD/TF Card Adapter, and Up to 100W/20V/5A Type C Power Delivery charging port... read more

Laptop Cleaning Kit Keyboard Cleaner, Keyboard Cleaning Kit Electronics Cleaning Tool for MacBook iPad Phone iPhone Pro, Brush Tool for Tablet, Computer, PC, TV Camera Lens Computer Vacuum Keyboard

(2067)

$16.98 (as of 07/07/2024 17:06 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

DEEP CLEAN YOUR DEVICE The electronics cleaner kit can effectively deep clean all your electronic devices such as mobile phones, tablets, TVs, etc. It comes with retractable large keyboard brush, polishing cleaning cloth X 2, keycap puller, metal pen... read more

PC Gaming Headset Headphone Hook Holder Hanger Mount, Headphones Stand with Adjustable & Rotating Arm Clamp, Under Desk Design, Universal Fit, Built in Cable Clip Organizer EURPMASK

(27367)

$12.99 (as of 07/07/2024 16:54 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

🎧【Clamp-on Headphone Stand】The E-Hold Series headphone holder fits desks from 0.31 inch to 1.57 inch thick, making it a versatile choice for most setups. The spring clamp is a breeze to remove and reattach. No glue, no mess. It blends seamlessly into... read more