backup – DBA's recipes

I had to configure a oracle cloud backup module recently and I’d like to make a quick tutorial helping you to not face the same problems I did.

First of all, you’ve to make that you have the java installed, at least in the version 1.7.

You can check your version with the command java -version – or install it with the command (as root)

# yum install java-1.7.0-openjdk-devel

Now download the Oracle Database Cloud Backup Module here.

The installation is made as follows:

I got the value of host parameter in the follow path:

Access the this URL: https://myservices.us2.oraclecloud.com/mycloud/a468401/faces/dashboard.jspx (I’ve received this link when my account was set up, I guess this can change)

Left menu

Services > Storage Classic

Account tab

The value is in the ‘Rest Endpoint’ box

Now you can run a backup of your database to the cloud.

run
{
allocate CHANNEL c1 DEVICE TYPE sbt PARMS=’SBT_LIBRARY=libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/opcProd.ora)’;
BACKUP CURRENT CONTROLFILE;
}

If you want to configure the default parameters of rman to backup directly to the you can use this:

CONFIGURE CHANNEL DEVICE TYPE SBT PARMS=’SBT_LIBRARY=libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/opcProd.ora)’;

CONFIGURE CHANNEL DEVICE TYPE sbt
PARMS=’SBT_LIBRARY=/mediavendor/lib/libobk.so ENV=(NSR_SERVER=tape_svr,NSR_CLIENT=oracleclnt,NSR_GROUP=ora_tapes)’
FORMAT “BACKUP_%U”;

Obs.: Backups must be encrypted before they can be sent to Oracle Database Backup Cloud Service. If you don’t use TDE, you can use Password encryption with the following command before de backup itself:

SET ENCRYPTION ON IDENTIFIED BY ‘my_pswd’ ONLY;

This is just my first tutorial, and I know it’s very simple, but I hope it help you;