For Cloud DBaaS instance, Oracle Cloud Service provision a VM and required file systems. Here is the file systems and other database related information.

Capture3

  • /u01 – Local file system – Oracle software binaries, DIAGNOSTIC_DEST
  • /u02 – Cloud Storage – Database Files, Change tracking file
  • /u03 – Cloud Storage – Fast Recovery Area, backup files, control file copy
  • /u04 – Cloud Storage – Redo log files, Temporary files

Storage Changes for DBaaS deployment

Add new Storage Volume:

Default file systems can be increased by using the menu item “Scale Up / Down Service”.

Capture4

In the above screen (Scale up / down Service), you can choose the first option of “Create New Storage Volume”. Specify a size in GB and click the confirm (Yes, Scale Up/Down Service) button.

Capture4

Check new volume from Oracle Compute Cloud Service> storage button.

Capture4

New volume is mounted on DBaaS instance.

Capture5

Increase Default File Systems:

You can easily expand the storage and CPU/Memory capacity. Select the database service and on resources side, select “scale up/Down” option, add extend the storage( select option from datafile/backups etc). CPU/Memory capacity can be increased by bigger compute shape.

cap2

Note: The scaling operation begins. The deployment is in Maintenance status and unavailable while the scaling operation is in progress. So scale operation will cause outage to the service. Click here for more information.

Compute Cloud – Add New Storage Volume

Choose Oracle Compute Cloud Service and click on the “Create Storage Volume” button.

Capture4.PNG

Provide name, size and storage type and Description.

Capture5

Check the storage volume, will take time to become online.

Choose the instance from compute service and add storage volume. Storage is attached to the DBaaS host.Capture5New Volume is added but not visible to the DBaaS instance server. Check the volume with fdisk command and create partitions. Then mount the stoarge volume.

New volume added as below.Capture5

Note: If the database deployment to which you attach this temporary storage is restarted or is stopped and then started, the storage volume becomes detached from the compute node and you must re-attach it.

Compute Cloud – Delete Storage Volume

Un-mount the storage from instance and then from cloud compute> instance> detach storage volume from instance.

Capture5

To delete the volume, go to Oracle Compute Cloud service> storage> volume> delete.

Containers:

A container is a storage compartment that provides a way to organize the data stored in Oracle Cloud Infrastructure Object Storage Classic. Containers can be created with web console and REST API.

Web Console: Go to cloud account> My Services page >storage classic and then Choose “Create Container”. Give name to the container and select type.

Capture

For regular backups and file storage needs, choose Standard. For archive backups, choose Archive Storage Service is ideally suited for infrequently accessed large-scale data sets. Now container is created and you can upload the objects or can be used as cloud db backups.

REST API:
1) Requesting an Authentication Token by running the following cURL command.
Replace with actual password.

curl -v -s -X GET -H “X-Storage-User: Storage-identity:email_id@gmail.com” -H “X-Storage-Pass: password” https://identity.storage.oraclecloud.com/auth/v1.0

Note : X-Storage-Url and X-Auth-Token value for next step. Tip: identity is same as cloud accoount name. it took me a while to find out identity as it’s not clearly specified in new oracle cloud setup.

2) From the output of the command you just ran, note the following:
The value of the X-Storage-Url header.This value is the REST endpoint URL of the service. You’ll use this URL in the next step to create the container.
The value of the X-Auth-Token header.

This value is the authentication token, which you’ll use in the next step to create the container. Note that the authentication token expires after 30 minutes, after which you should request a fresh token.

Capture3

3) Creating Your First Container.
Run the following cURL command:

curl -v -s -X PUT -H “X-Auth-Token: AUTH_tk85388cfc91ece053145e3ff386e96552” https://storage.us2.oraclecloud.com/v1/Storage-myIdentityDomain/cloudbkup02

Note: When you run this command
– Replace the value of the X-Auth-Token header with the authentication token that you obtained earlier.
– Change https://storage.us2.oraclecloud.com/v1/Storage-myIdentityDomain to the X-Storage-Url header value that you noted while getting an authentication token.
– And name of the container that you want to create.

Capture3

4) Verifying That Your Container Was Created.
Run the following cURL command:

curl -v -s -X GET -H “X-Auth-Token: AUTH_tk85388cfc91ece053145e3ff386e96552” https://storage.us2.oraclecloud.com/v1/Storage-myIdentityDomain/loudbkup02

If the request is completed successfully, it returns the HTTP/1.1 204 No Content response. This response indicates that there are no objects yet in your new container.

Mandy!!!

Reference:

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/add-temporary-storage.html
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/scale.html
https://docs.oracle.com/en/cloud/iaas/storage-cloud/cssto/creating-containers.html

Leave a Reply