@OracleIMC Partner Resources & Training: Discover your Modernization options + Reach new potential through Innovation

Migrate On-premise DB to database Cloud service using Cloud DB backup module

Hany Mohamed
EMEA Cloud Transformation Consultant

Are you considering migrating your Oracle Database to Oracle Database on the Cloud? Are you planning to backup your Oracle Database to the Cloud?

The Oracle Database Cloud DB backup module, allows you to upload and integrate your On-premise recovery manager with Oracle Database Backup Cloud service. It is fully compatible with your On-premise DB recovery manager (RMAN) and can be the most secure - optimized  approach to upload your DB data files automatically to Oracle Cloud Database.

Oracle Database Backup Cloud service can by itself provide a secure, scalable and most importantly reliable on-demand object storage solution for backing up you ever-growing Oracle Databases to Oracle Cloud .

With Oracle Database Cloud DB backup module  you can perform local back ups to the Oracle Database Backup Cloud Service or trial subscription of Oracle Storage Cloud Service. Install oracle database cloud backup module and configure your recovery manager (RMAN) to send the database backup piece to the cloud storage . 

Let's take a quick look on how to install oracle database cloud backup module and configure your recovery manager (RMAN) to send the database backup piece to the cloud storage. See bellow the necessary steps and configuration for On-premise Recovery Manager (RMAN) .

Step 1 - Download the cloud backup Module .

  • Verify your Cloud account and make sure of the replication Policy enabled for your Assigned Storage Classic service .
  • Create storage container : go to Open Service Console /Create Container / choose Storage Class Standard .

Step 2 - Install the cloud backup Module .

  • Run java -jar opc_install.jar -host 'RestEndPoint URL -- example https://identifty Domain .cloudoracle.com/v1/??/??' -opcId '<opc-username>' -opcPass '<opc-passwd>' -walletDir $ORACLE_HOME/dbs/opc_wallet -libDir $ORACLE_HOME/lib –container '<Storage Container Name from step 1>'.
  • Configuration file "opcorcl.ora” and Wallet directory “opc_wallet” will be created by the installation process and place these in  $ORACLE_HOME/dbs.
  • It also automatically downloads a library file “libopc.so” that RMAN uses to communicate with the Oracle Database Backup Service and places that in $ORACLE_HOME/lib. You specified both these locations in the syntax of the install command

Step 3 - Set the database archive-log mode .

Let's now see how to configure On-premise Recovery manager - RMAN to support Oracle Cloud backups. Here is a simple setup of the RMAN parameters .

  • Connect to rman target /
  • Run the following command in RMAN to setup the required parameters " run { configure retention policy to recovery window of 30 days; configure channel device type 'sbt_tape' MAXPIECESIZE 2 G FORMAT 'onPremBackup3_%d_%U' PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=$ORACLE_HOME/dbhome_1/dbs/opccdb1.ora)'; configure compression algorithm 'MEDIUM'; } " .

And now we are ready to start backing up our Database to Cloud DB backup service

Step 1 - Set backup encryption for On-premise recovery manager .

  • for security reasons backing up DB to Cloud backup service requires encryption to be used and we have got two options here (1- Transparent Data Encryption . 2- Password Encryption ) .
  • Example for password encryption " set ENCRYPTION ON INDETIFIED BY 'xxxxx' ONLY ; "

Step 2 - backup On-premise Database to Oracle Data storage .

  • Database backup piece should be completed based on DB size and Connectivity bandwidth .
  • you will be able to find Database backup piece in the user defined storage container in your Cloud account .

Now you have your local Database backup on cloud, but you can also use Oracle Database Cloud Service creation wizard to perform an instantiate from backup operation and create a cloud Database CS instance from your RMAN Backup piece of your on-premise DB.

Before you know it, your database is effectively available as a Database on Cloud for you to use. Make sure to also check out Oracle Database Backup Cloud Service documentation. See the white paper for more details about the service.
For FAQ, refer to the MOS Note 








Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.