Scale the DB System

This article provides the details and procedure to scale up the storage for a DB system.

If a DB system requires more block storage, you can increase the storage at any time.

Limitations

If you are scaling either data storage or recovery area storage from a value less than 10,240 GB (10 TB) to a value exceeding 10,240 GB, perform the scaling in two operations. First, scale the system to 10,240 GB. After this first scaling operation is complete and the system is in the "available" state, perform a second scaling operation, specifying your target storage value above 10,240 GB. Attempting to scale from a value less than 10,240 GB to a value higher than 10,240 GB in a single operation can lead to a failure of the scaling operation.

Procedure

Perform the following steps to scale up the storage for a DB system using the OCI Console:

  1. From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
  2. Select your Compartment. A list of DB systems is displayed.
  3. On the DB systems list page, select the DB system that you want to manage. The DB system details page is displayed.
  4. On the DB system details page, select Scale storage up.
  5. In the Scale storage up panel, scale your storage as needed:

    Note:

    The Available storage (GB) value you specify during provisioning determines the maximum total storage available through scaling. The total storage available for each choice is detailed in Storage Scaling Considerations for Databases Using Fast Provisioning.
  6. The Storage management software and Storage performance sections display the values you had selected while provisioning and cannot be changed.
  7. Available data storage (GB): Select the amount of BlockStorage in GB to allocate to the DB system. Available storage can be scaled up as needed after provisioning your DB system.
  8. Recovery area storage (GB): Select the amount of storage required for recovery log data (RECO storage). The recovery area storage is determined based on the storage selected.
  9. Total storage (GB): Read only. Displays the total amount of storage that will be used by the DB system, including storage required by Oracle's DB system software. The size of the backup determines the minimum value for available storage.
  10. Expected theoretical max IOPS for data storage: Displays the maximum theoretical IOPS that is achievable for storage you have selected.

    Note:

    Oracle recommends keeping recovery storage at 20% of total storage or higher. Oracle charges for the total storage used, including data storage, recovery storage, and storage required for the system software.
  11. Select Update.

Note:

To change the number of OCPUs for the DB system, see Change the Shape of a DB System.