Infrastructure at your Service

Olivier Toussaint

How to manage your containers in Oracle Storage Cloud Service ?

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

Process_to_connection

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).

Process_to_connection_Crea_allt

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 :

Storage_quota

In Cloud, we can monitor storage capacity of your Oracle Database Backup Service.

billing

Step 2 – Connection in your Oracle Public Cloud

Process_to_connection

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 :

summary

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.

Capture20

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.

Rman_backup

The backup has been correctly performed with RMAN command. So we will see if we have our backup pieces in your container.

Backup_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 :

Show_all

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.

Config_cloud

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.

Conclusion

Easy to use, simple to set up, just try it !

5 Comments

  • Ganesh says:

    Hello,

    Thanks for this post.

    Do you have any idea how to restore those backups which are in cloud storage to other instance?

    Thanks in advance,
    Ganesh Arelly

    • Olivier Toussaint says:

      Thanks a lot for your asking and sorry for my delay in response.

      As we cannot access directly on backup piece files from local server, the only manner is to install the backup/restore API.

      We can restore a database from an Oracle Cloud to On_Premise,so you have to use on your local site the Oracle Database Cloud Backup Module software.

      The link : http://www.oracle.com/technetwork/database/availability/oracle-cloud-backup-2162729.html

      It exists another solution to restore a database from an Oracle Cloud to On_Premise, it’s to use Rman with a duplicate command like your local Rman.

      Currently, whether you to decide to restore a database from Oracle Cloud to Oracle Cloud, needn’t install the backup / restore API because your backups are stocked in your storage backup space.

      Thanks & Regards
      Olivier Toussaint

      • nazeer says:

        Hi,

        i have configured the RMAN on-premise and able to store the RMAN backup in oracle cloud container, can you please suggest the steps to restore a database from an Oracle Cloud to On_Premise, with RMAN duplicate command.

        Thanks,
        Nazeer

        • Olivier Toussaint says:

          Hi Nazeer,

          To restore the database from oracle Cloud to On-premises using duplicate from backup, you could use the following steps :

          1 – Configure sbt_library On-Premise database
          2 – Create TNS access entries both databases
          3 – From On-Premise connect to auxiliary
          4 – From On-Premise connect to target with convert if necessary
          5 – Set decryption identified by ”
          6 – Run duplicate with location in a Oracle Cloud and until time

          Best Regards

          • nazeer says:

            Hi Olivier Toussaint,
            Thanks a lot, we tried as you suggested and successfully duplicated the database with your support..

            Thanks,
            Nazeer

Leave a Reply

Olivier Toussaint
Olivier Toussaint

Consultant