2.3.3.5 Increase the Size of the Oracle ASM Disks

You can increase the size used by the Oracle ASM disks after increasing the space allocated to the associated grid disks.

This task is a continuation of an example where space in the RECOC1 disk group is being reallocated to the DATAC1 disk group.

You must have completed the task of resizing the grid disks before you can resize the corresponding Oracle ASM disk group.

1. Increase the Oracle ASM disks for DATAC1 disk group to the new size of the grid disks on the storage cells.

   SQL> ALTER DISKGROUP datac1 RESIZE ALL;

   This command resizes the Oracle ASM disks to match the size of the grid disks.

   Note:

   If the specified disk group has quorum disks configured within the disk group, then the ALTER DISKGROUP ... RESIZE ALL command could fail with error ORA-15277. Quorum disks are configured if the requirements specified in Oracle Exadata Database Machine Maintenance Guide are met.

   As a workaround, for regular storage server failure groups (FAILGROUP_TYPE=REGULAR, not QUORUM), you can specify the failure group names explicitly in the SQL command, for example:

   SQL> ALTER DISKGROUP datac1 RESIZE DISKS IN FAILGROUP exacell01, exacell02, exacell03;

2. Wait for the rebalance operation to finish.

   SQL> set lines 250 pages 1000 
   SQL> col error_code form a10 
   SQL> SELECT dg.name, o.* FROM gv$asm_operation o, v$asm_diskgroup dg 
        WHERE o.group_number = dg.group_number;

   Do not continue to the next step until the query returns zero rows for the disk group that was altered.

3. Verify that the new sizes for the Oracle ASM disks and disk group is at the desired sizes.

   SQL> SELECT name, total_mb, free_mb, total_mb - free_mb used_mb, 
        ROUND(100*free_mb/total_mb,2) pct_free
        FROM v$asm_diskgroup
        ORDER BY 1;
   
   NAME                             TOTAL_MB    FREE_MB    USED_MB   PCT_FREE
   ------------------------------ ---------- ---------- ---------- ----------
   DATAC1                          116304384   57439796   58864588      49.39
   RECOC1                           47488896   34542516   12946380      72.74
   
   SQL>  SELECT dg.name, d.total_mb, d.os_mb, COUNT(1) num_disks
         FROM  v$asm_diskgroup dg, v$asm_disk d
         WHERE dg.group_number = d.group_number
         GROUP BY dg.name, d.total_mb, d.os_mb;
    
   NAME                             TOTAL_MB      OS_MB  NUM_DISKS
   ------------------------------ ---------- ---------- ----------
   DATAC1                             692288     692288        168
   RECOC1                             282672     282672        168
   
   

   The results of the queries show that the RECOC1 and DATAC1 disk groups and disk have been resized.