You may also refer the MOS (Doc ID 2176737.1)
- Objective is to add 3000 GB more diskspace to the already existing ASM Diskgroup.
- Storage Configuration is 12 disks/cell * 3 cells/storage servers
- Current ASM Diskgroup Total_MB is 9216000
- Current Griddisk size is 250G each
Therefore Target Griddisk size would be 500G each, That is to add additional 250GB*12 Disks * 3 Storage servers
ASM Diskgroup size before extending the disks:
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files
Name
MOUNTED HIGH N 512 512 4096 4194304 9216000 1435572 512000 307857 0 N
DATA19/
ASMCMD>
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DATA19 9216000 1435572
SQL>
On the Storage Cell server query the griddisk size pertaining to the diskgroup supposed to be extended, in My case ASM diskgroup name is DATA19
[root@scxxxxxxx01 ~]# cellcli -e "list griddisk where name like 'DATA19.*' attributes name, size"
DATA19_CD_00_scxxxxxxx01 250G
DATA19_CD_01_scxxxxxxx01 250G
DATA19_CD_02_scxxxxxxx01 250G
DATA19_CD_03_scxxxxxxx01 250G
DATA19_CD_04_scxxxxxxx01 250G
DATA19_CD_05_scxxxxxxx01 250G
DATA19_CD_06_scxxxxxxx01 250G
DATA19_CD_07_scxxxxxxx01 250G
DATA19_CD_08_scxxxxxxx01 250G
DATA19_CD_09_scxxxxxxx01 250G
DATA19_CD_10_scxxxxxxx01 250G
DATA19_CD_11_scxxxxxxx01 250G
[root@scxxxxxxx01 ~]#
Resize the griddisks on all storage cells as follows: (output is trimmed to reduce the screenspace)
On storage cell 1:
[root@scxxxxxxx01 ~]# cellcli -e alter griddisk DATA19_CD_00_scxxxxxxx01,DATA19_CD_01_scxxxxxxx01,DATA19_CD_02_scxxxxxxx01,DATA19_CD_03_scxxxxxxx01,DATA19_CD_04_scxxxxxxx01,DATA19_CD_05_scxxxxxxx01,DATA19_CD_06_scxxxxxxx01,DATA19_CD_07_scxxxxxxx01,DATA19_CD_08_scxxxxxxx01,DATA19_CD_09_scxxxxxxx01,DATA19_CD_10_scxxxxxxx01,DATA19_CD_11_scxxxxxxx01 size=500G;
GridDisk DATA19_CD_00_scxxxxxxx01 successfully altered
.
.
GridDisk DATA19_CD_11_scxxxxxxx01 successfully altered
[root@scxxxxxxx01 ~]#Repeat the above resize on all storage cells
On storage cell 2:
root@scxxxxxxx02 ~]# cellcli -e alter griddisk DATA19_CD_00_scxxxxxxx02,DATA19_CD_01_scxxxxxxx02,DATA19_CD_02_scxxxxxxx02,DATA19_CD_03_scxxxxxxx02,DATA19_CD_04_scxxxxxxx02,DATA19_CD_05_scxxxxxxx02,DATA19_CD_06_scxxxxxxx02,DATA19_CD_07_scxxxxxxx02,DATA19_CD_08_scxxxxxxx02,DATA19_CD_09_scxxxxxxx02,DATA19_CD_10_scxxxxxxx02,DATA19_CD_11_scxxxxxxx02 size=500G;
GridDisk DATA19_CD_00_scxxxxxxx02 successfully altered
.
.
GridDisk DATA19_CD_11_scxxxxxxx02 successfully altered
[root@scxxxxxxx02 ~]#
On storage cell 3:
[root@scxxxxxxx03 ~]# cellcli -e alter griddisk DATA19_CD_00_scxxxxxxx03,DATA19_CD_01_scxxxxxxx03,DATA19_CD_02_scxxxxxxx03,DATA19_CD_03_scxxxxxxx03,DATA19_CD_04_scxxxxxxx03,DATA19_CD_05_scxxxxxxx03,DATA19_CD_06_scxxxxxxx03,DATA19_CD_07_scxxxxxxx03,DATA19_CD_08_scxxxxxxx03,DATA19_CD_09_scxxxxxxx03,DATA19_CD_10_scxxxxxxx03,DATA19_CD_11_scxxxxxxx03 size=500G;
GridDisk DATA19_CD_00_scxxxxxxx03 successfully altered
.
.
GridDisk DATA19_CD_11_scxxxxxxx03 successfully altered
[root@scxxxxxxx03 ~]#Check the alertlog and ensure there are no warning/errors, in my case the location is /opt/oracle/cell/log/diag/asm/cell/<Cellserver_hostname>/trace
2019-03-11T09:19:20.478091+03:00
Griddisk DATA19_CD_00_scxxxxxxx01 (guid: a44946cb-b3c9-4962-95fc-ca02bb84ef88) size, successfully altered
2019-03-11T09:19:20.755676+03:00
Griddisk DATA19_CD_01_scxxxxxxx01 (guid: 62133888-6bd3-4202-aee7-c5d12b025281) size, successfully altered
2019-03-11T09:19:20.980395+03:00
Griddisk DATA19_CD_02_scxxxxxxx01 (guid: 2ae4c930-c329-487d-a8eb-6b00de71e5b9) size, successfully altered
2019-03-11T09:19:21.193198+03:00
Griddisk DATA19_CD_03_scxxxxxxx01 (guid: 882201df-92b3-401d-8078-4323f4c90e0c) size, successfully altered
2019-03-11T09:19:21.414314+03:00
Griddisk DATA19_CD_04_scxxxxxxx01 (guid: 815fb80a-78ac-4744-a625-b8f3225da33a) size, successfully altered
2019-03-11T09:19:21.601234+03:00
Griddisk DATA19_CD_05_scxxxxxxx01 (guid: fca67088-71a2-4280-8610-5147e615dd10) size, successfully altered
2019-03-11T09:19:21.838495+03:00
Griddisk DATA19_CD_06_scxxxxxxx01 (guid: ef357611-94c6-41b6-a604-16779d385f53) size, successfully altered
2019-03-11T09:19:22.079630+03:00
Griddisk DATA19_CD_07_scxxxxxxx01 (guid: 999b5113-3749-49c6-8604-766b0acb825a) size, successfully altered
2019-03-11T09:19:22.286507+03:00
Griddisk DATA19_CD_08_scxxxxxxx01 (guid: 470ade23-4180-4099-bc4f-67319e53d1af) size, successfully altered
2019-03-11T09:19:22.449122+03:00
Griddisk DATA19_CD_09_scxxxxxxx01 (guid: 6c639a1e-a204-4f0b-9a8c-971cee37f35a) size, successfully altered
2019-03-11T09:19:22.648035+03:00
Griddisk DATA19_CD_10_scxxxxxxx01 (guid: 3a4cf228-cdd3-4f97-883e-b8a2b75a6ddc) size, successfully altered
2019-03-11T09:19:22.839986+03:00
Griddisk DATA19_CD_11_scxxxxxxx01 (guid: cd5c04f1-a3fc-4158-9088-537ad610d75a) size, successfully alteredNow Login to the ASM instance using sysasm and Alter the diskgroup to resize the DATA19 ASM diskgroup
SQL> alter diskgroup DATA19 resize all rebalance power 16;
Diskgroup altered.
SQL> Confirm the ASM diskgroup size is increased as expected:
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DATA19 18432000 10651572
SQL>
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED HIGH N 512 512 4096 4194304 18432000 10651572 1024000 3209190 0 N DATA19/
Mudasir Hakak Sr. Database Consultant 