Add Disks to Existing ASM Disk Group
In this blog I will show how to add new disks to an existing ASM Disk group. This also contains the steps to perform the migration from existing to the new storage system.
In order to add the disk to the ASM disk group, you will first need to configure these disk using the operating system commands. I have provided the steps to configure the disks on AIX system in my blog "Configure Oracle ASM Disks on AIX"
Adding New Disks to DATA Disk Group (Storage Migration for DATA Disk Group)
Login to your ASM instance
$ sqlplus / as sysasm
If the name of the new disk is in different format from the existing disk, the modify the asm_diskstring parameter to identify the new disks. In my below example /dev/ora_data* is the format of the existing disks and /dev/new_disk* is the naming format of the newly configured disks. You should not modify this parameter unless the naming format changes.
SQL> alter system set asm_diskstring = '/dev/ora_data*','/dev/new_disk*';
Issue the below statement to identify that the new disks are listed as status "Provisioned"
SQL> select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK;
DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE PATH
--------------------- -------------- ----------------------- -------------- ------------ ---------------------------
3 CACHED MEMBER ONLINE NORMAL /dev/ora-data3
1 CACHED MEMBER ONLINE NORMAL /dev/ora-data4
2 CLOSED PROVISIONED ONLINE NORMAL /dev/new_disk1
4 CLOSED PROVISIONED ONLINE NORMAL /dev/new_disk2
Use the below command to add the new disks to the disk group. You can adjust the value of rebalance power ( based on the load on the server. Data will be distributed equally between all the disks which are part of the disk group.
SQL> alter diskgroup DATA_DG add disk '/dev/new_disk1','/dev/new_disk2'
rebalance power 1;
Wait until the rebalance operation completes. You can use the below statement to check the progress of rebalance operation.
SQL> select * from v$asm_operation;
SQL>
select * from gv$asm_operation;
In case you want to remove the old disk disks, for example in the activities like storage migration, where you are moving from old to new faster storage systems, you can use below command to remove the old disks from the disk group.
SQL> alter diskgroup DATA_DG drop disk DATA_DG_0003,DATA_DG_0004 rebalance power 1;
Rebalance operation will occur again to re-distribute the data to the remaining disks which are still the member of the disk group.
Comments
Post a Comment