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:
- On the DB Systems list page, select the DB system that you want to work with. If you need help finding the list page or the DB system, see List the DB Systems.
- On the DB system details page, select Scale storage up.
-
In the Scale storage up panel, provide the following details to select from available storage:
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.- The Storage management software and Storage performance sections display the values you had selected while provisioning and cannot be changed.
- Available data storage (GB): Select the amount of Block Storage in GB to allocate to the DB system. Available storage can be scaled up or down as needed after provisioning your DB system.
- 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.
Tip:
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. - Total storage (GB): Read-only. Displays the total amount of storage that will be used by the DB system, including storage required by the DB system software. The size of the backup determines the minimum value for available storage.
- Expected theoretical max IOPS for data storage: (Read-only) This field displays the maximum theoretical IOPS that is achievable for the storage you have selected.
- Select Update.
Note:
To change the number of OCPUs for the DB system, see Change the Shape of a DB System.Related Topics