Oracle Cloud Storage Service provides secure, scalable and consistent data from any environment.
To get a higher flexibility for your backups, I suggest to use a CloudBerry application in Oracle Public Cloud.
This application can be used on Cloud Backup and Recovery in PaaS and IaaS infrastructures.
We are going to use it for our DbaaS in PaaS infrastructure.
However, a user-friendly third party tool can also be used as CloudBerry Explorer for OpenStack as managing Storage Containers.
Before starting with CloudBerry it is necessary to subscribe to a trial access or to buy a billing frequency hourly or monthly. In both cases, we have the same functionalities.
Let’s go !
Follow all steps to subscribe your free trial access in the PaaS / DbaaS category on https://cloud.oracle.com/home.
Once your account is registered, you will receive an e-mail from Oracle with subscription details.
This e-mail contains a lot of services, but we will only use the Oracle Backup Service. We can notice that our Backup Service has a data region (UK) and a link to associated documentation (same for other services).
Oracle Database Backup Service
Data Region: UK001
Get Started: http://docs.oracle.com/cloud/latest/dbbackup_gs/index.html
In the next steps, we will have a look on different types of Backup Services. The access to the Backup Services is linked to your account.
You need :
– Your email address
– Your password
– Your Identity Domain
Start with CloudBerry by downloading and installing the following link : http://www.cloudberrylab.com and install it.
Step 1 – Creating an Oracle connection
File > New Oracle Account
The account location depends on where you have subscribed your Datacenter. This account is notified when you receive your confirmation e-mail. Note that your storage space is linked with your identity domain and that all services, which depend on your subscription, will be stored in this area.
Once the connection is established we are going to create a container for the backup storage area (process below).
This page shows other containers as well as our “SandBox” container we just created. The “_apaas” belongs to an Application Container Cloud I created as a service on my Oracle Public Cloud.
We will use our SandBox container to create our Oracle Backup Service. There are 2 kinds of containers, “Standard & Archive”.
Standard : Containers are similar to a directory structure but with a key distinction: unlike directories, containers cannot be nested.
By default, all containers are of the standard storage class (as opposed to the archive storage class).
Archive : You can use Archive containers to store data that won’t be accessed for a while or that will be accessed infrequently.
For example :
In Cloud, we can monitor storage capacity of your Oracle Database Backup Service.
Step 2 – Connection in your Oracle Public Cloud
Once the connection to your Oracle Public Cloud is established, we shall create a new database with a Backup storage area. I am not going to describe all steps to create a database in a Cloud, but rather some steps to backup the storage and a summary before we create it.
Step 3 – Creating Cloud Database with Backup and Recovery configuration
Here is the summary of out DBaaS creation :
As you will notice in the backup destination section, we have chosen a backup location option for the database in your service and, depending on your choice, provided information regarding the Oracle Storage Cloud service container where cloud backups have to be stored.
Backup Destination: we are going to store our backup in a Cloud or/in a local storage.
For configuration, remember your :
Cloud Storage Container : <store service name>-<identity domain name>/<container name>
Step 4 – Backup Tests
First, we shall execute a backup of the database with RMAN command, then we will be able to check the results.
The backup has been correctly performed with RMAN command. So we will see if we have our backup pieces in your container.
As shown in the picture above, we find the backups in our “SandBox” container.
Step 5 – How to check my backup parameters ?
When you perform a “Show All” command in RMAN you can check how your channel is configured for backups. There you should have a library parameter set up in RMAN as follow :
We can notice that there are “SBT_TAPE” channels for the device with its library (libopc.so) and the configuration which is limited to maxsize of 2 Go.
We see a parameter file called opcSDBX.or which contains the settings to access the backup cloud service Container. Then you can check it and open it with a text editor.
Here we find our parameters entered previously when we created our access in the Oracle Cloud backup. We can observe one important thing: we use a wallet to secure backups and recovery in Cloud.
Easy to use, simple to set up, just try it !