Sunday, November 19, 2023

ExaCC: Scale VM Cluster Exadata Usable Storage

 

- Overview:

  • With multiple VMs per Exadata Infrastructure feature release, you can scale up or down the following resources on VM cluster:
    • Local storage /u02. Scaling memory requires a rolling restart of the cluster nodes to take effect.
    • Memory. Scaling memory requires a rolling restart of the cluster nodes to take effect.
    • OCPU. Scaling OPCU is Online.
    • Exadata storage. Scaling OPCU is Online.
  • The minimum recommended size is 2 TB.
  • Use the following formula to calculate the minimum required ASM storage:
    • For each disk group, for example, DATA, RECO, note the total size and free size by running the "asmcmd lsdg" command on any node of the VM cluster.
    • Calculate the used size as (Total size - Free size) / 3 for each disk group. The /3 is used because the disk groups are triple mirrored.
    • DATA:RECO ratio is:
      • 80:20 if Local Backups option was NOT selected in the user interface.
      • 40:60 if Local Backups option was selected in the user interface.
    • Ensure that the new total size as given in the user interface passes the following conditions:
      • Used size for DATA * 1.15 <= (New Total size * DATA % ).
      • Used size for RECO * 1.15 <= (New Total size * RECO % ).

In this blog, I'll demonstrate the steps to scale up the usable Exadata storage using OCI console.

Steps to Scale Up VM Cluster Exadata Usable Storage 


1. Note the current total size and free size by running "asmcmd lsdg" command on any node of the VM cluster.





2.  Sign in to your OCI tenancy where your Exadata Database Service on Cloud @ Customer system is deployed.

3. Navigate to "Oracle Database" > "Oracle Exadata Database Service on Cloud@Customer" > "Exadata VM Clusters".
















4. Click on your VM cluster name.










5. On VM cluster details home page, click "Scale VM Resources" button.


 
 









































6. On "Scale VM Cluster" screen, under "Configure the Exadata storage" section, specify the usable Exadata storage new size then click "Save Changes" button. The new size will be distributed based on DATA:RECO ratio, which is 80:20 in our example.  























Cluster state will switch to "UPDATING", but all resources will be UP on both nodes.











You can track scaling progress and activities from "Work Requests" page under Resources section in VM cluster details home page.
























Once scaling successfully completes, cluster's state will changed back to "AVAILABLE". Under "Resource allocation" section, Exadata Storage (TB) will show the new total usable storage.





























7. Connect to any of the VM cluster and run "asmcmd lsdg" command to check ASM disk groups new size.





No comments:

Post a Comment

Oracle 23ai: Hybrid Read-Only Mode for Pluggable Databases

  - Overview: Oracle 23ai database introduces a new feature to open Pluggable database in  a new mode called hybrid read-only. Hybrid read-o...