9.8.1 Resizing the Virtual Space

When V$ASM_DISKGROUP.FREE_MB or V$ASM_DISK.FREE_MB is running low, you need to increase the virtual address space.

1. To increase the size of the virtual space:
   1. Run the following command on the cells, specifying all the grid disks for the SPARSE disk group:

      CellCLI> alter griddisk SPARSE_CD_00_CELL01,SPARSE_CD_01_CELL01,....,SPARSE_CD_11_CELL01 virtualSize=newSize
      

      For example, on the first cell:

      CellCLI> alter griddisk SPARSE_CD_00_CELL01,SPARSE_CD_01_CELL01,SPARSE_CD_02_
      CELL01,SPARSE_CD_03_CELL01,SPARSE_CD_04_CELL01,SPARSE_CD_05_CELL01,SPARSE_CD_
      06_CELL01,SPARSE_CD_07_CELL01,SPARSE_CD_08_CELL01,SPARSE_CD_09_CELL01,SPARSE_
      CD_10_CELL01,SPARSE_CD_11_CELL01 virtualSize=12000G
      
      GridDisk SPARSE_CD_00_CELL01 successfully altered
      GridDisk SPARSE_CD_01_CELL01 successfully altered
      ...
      

      For example, on the next cell:

      CellCLI> alter griddisk SPARSE_CD_00_CELL02,SPARSE_CD_01_CELL02,SPARSE_CD_02_
      CELL02,SPARSE_CD_03_CELL02,SPARSE_CD_04_CELL02,SPARSE_CD_05_CELL02,SPARSE_CD_
      06_CELL02,SPARSE_CD_07_CELL02,SPARSE_CD_08_CELL02,SPARSE_CD_09_CELL02,SPARSE_
      CD_10_CELL02,SPARSE_CD_11_CELL02 virtualSize=12000G
      
      GridDisk SPARSE_CD_00_CELL02 successfully altered
      GridDisk SPARSE_CD_01_CELL02 successfully altered
      ...
      

      Note:

      You must change the size of the grid disks on all cells before making any changes in Oracle ASM.
   2. On an ASM instance, resize the disk group to this new size:

      SQL> alter diskgroup SPARSE resize all size newSize;

      For example:

      SQL> alter diskgroup SPARSE resize all size 12000G;

2. To decrease the size of the virtual space:
   1. On an ASM instance, resize the disk group to this new size:

      SQL> alter diskgroup SPARSE resize all size newSize;
      

      For example:

      SQL> alter diskgroup SPARSE resize all size 8000G;

   2. Run the following command on the cells, specifying all the grid disks for the SPARSE disk group:

      CellCLI> alter griddisk SPARSE_CD_00_CELL01,SPARSE_CD_01_CELL01,....,SPARSE_CD_11_CELL01 virtualSize=newSize
      

      For example, on the first cell:

      CellCLI> alter griddisk SPARSE_CD_00_CELL01,SPARSE_CD_01_CELL01,SPARSE_CD_02_
      CELL01,SPARSE_CD_03_CELL01,SPARSE_CD_04_CELL01,SPARSE_CD_05_CELL01,SPARSE_CD_
      06_CELL01,SPARSE_CD_07_CELL01,SPARSE_CD_08_CELL01,SPARSE_CD_09_CELL01,SPARSE_
      CD_10_CELL01,SPARSE_CD_11_CELL01 virtualSize=8000G
      
      GridDisk SPARSE_CD_00_CELL01 successfully altered
      GridDisk SPARSE_CD_01_CELL01 successfully altered
      ...
      

      For example, on the next cell:

      CellCLI> alter griddisk SPARSE_CD_00_CELL02,SPARSE_CD_01_CELL02,SPARSE_CD_02_
      CELL02,SPARSE_CD_03_CELL02,SPARSE_CD_04_CELL02,SPARSE_CD_05_CELL02,SPARSE_CD_
      06_CELL02,SPARSE_CD_07_CELL02,SPARSE_CD_08_CELL02,SPARSE_CD_09_CELL02,SPARSE_
      CD_10_CELL02,SPARSE_CD_11_CELL02 virtualSize=8000G
      
      GridDisk SPARSE_CD_00_CELL02 successfully altered
      GridDisk SPARSE_CD_01_CELL02 successfully altered
      ...