Configure Oracle Database Backup Cloud Service

Oracle started offering Oracle Database Backup Cloud Service for some time now and I believe it’s time for cloud customers to realize that Oracle will be leading cloud provider in coming months. Oracle Database Backup Cloud Service not only provide secure, scalable, on-demand storage solution for backing up Oracle databases to Oracle Cloud but also complements your existing backup strategy by providing an off-site storage location in the public cloud. Oracle Database Backup Cloud Service is highly available backup service which also support RMAN backup encryption and RMAN backup compression. Here are steps to configure and backup your database to Oracle Database Backup Cloud.

First you need to install oracle backup module. You can download backup module using following link

( ), once download and extract module to any directory.  I will be using $ORACLE_HOME/opc directory to install Oracle backup module. Before you can install the module, you should acquire following information.

  1. identityDomain
  2. Cloud User Name
  3. Cloud User Password
  4. Cloud Storage Rest Point

Please change highlighted items based on your environment

$ java -jar opc_install.jar -serviceName storagesvc -identityDomain <identitydomain> -opcId <USERNAME> -opcPass <password> -walletDir /u01/app/oracle/OPC/wallet -libDir /u01/app/oracle/OPC/lib -host <cloud Storage Rest Point>

Oracle Database Cloud Backup Module Install Tool, build 2016-10-07
Oracle Database Cloud Backup Module credentials are valid.
Oracle Database Cloud Backup Module wallet created in directory /u01/app/oracle/product/12.1.0/db_1/opc/wallet.
Oracle Database Cloud Backup Module initialization file /u01/app/oracle/product/12.1.0/db_1/dbs/opctestdb12c1.ora created.
Downloading Oracle Database Cloud Backup Module Software Library from file
Downloaded 26528348 bytes in 10 seconds. Transfer rate was 2652834 bytes/second.
Download complete.

Verify install by checking $ORACLE_HOME/dbs and /u01/app/oracle/OPC/wallet directories and see if opcSID.ora and cwallet.sso have been created respectively. If you were able to find above mentioned files, you can start running backups to Oracle database backup cloud service. Here is the simple script to test to newly configure backup service. Please note that Oracle Database Backup cloud Service only support encrypted backups for security reasons and you have option to use TDE or RMAN encryption. I will be using RMAN encryption option for this blog which also don’t require any licensing.

Lets set encryption on before we run any backups

[oracle@oraclenode1 ~]$ rman target /
Recovery Manager: Release - Production on Sat Feb 11 01:35:36 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.connected to target database: TESTDB12 (DBID=2927258729)


executing command: SET encryption
using target database control file instead of recovery catalog

Now lets run try datafile backup to Oracle Database Backup Cloud Service

RMAN> run
allocate channel ch1 device type sbt parms='SBT_LIBRARY=/u01/app/oracle/OPC/lib/,ENV=(OPC_PFILE=/u01/app/oracle/product/12.1.0/db_1/dbs/opctestdb12c1.ora)';
BACKUP datafile 1;
release channel ch1;
}2> 3> 4> 5> 6>

allocated channel: ch1
channel ch1: SID=71 device type=SBT_TAPE
channel ch1: Oracle Database Backup Service Library VER=

Starting backup at 11-FEB-17
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oradata/TESTDB12C1/datafile/o1_mf_system_d9s6oxr3_.dbf
channel ch1: starting piece 1 at 11-FEB-17
Finished backup at 11-FEB-17