{"id":23259,"date":"2023-03-14T17:55:36","date_gmt":"2023-03-14T16:55:36","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=23259"},"modified":"2023-06-12T10:07:47","modified_gmt":"2023-06-12T08:07:47","slug":"oracle-database-backup-cloud-service","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-database-backup-cloud-service\/","title":{"rendered":"Oracle Database Backup Cloud Service"},"content":{"rendered":"\n

In a previous blog<\/a> I demonstrated how to migrate an Oracle database from AWS to Oracle OCI using Data Guard. But what if you want to migrate to the Oracle Cloud, but don\u2019t have a direct connection between the Cloud Providers, neither of the database servers are available in the public internet or you are using Oracle Standard Edition where Data Guard isn\u2019t available?<\/p>\n\n\n\n

You could backup the database to disk, copy the files by hand to a temporary location, copy from the temporary location to the Oracle Cloud and then restore the database.<\/p>\n\n\n\n

Or you could use the Oracle Database Backup Cloud Service to simplify the process. This service allows us to perform RMAN backup \/ restore directly to an Object Store (Bucket) in the Oracle Cloud Infrastructure. And, there\u2019s nothing stopping us from restoring the backups to a different Cloud provider.<\/p>\n\n\n\n

In this blog I\u2019ll demonstrate how to backup a database running on AWS to the Oracle Database Backup Cloud Service and then restore the database to a instance running in the Oracle Cloud Infrastructure. This method will also work for migrating on-premise databases to a cloud provider.<\/p>\n\n\n\n

Environment<\/h2>\n\n\n\n
Original Database – AWS<\/strong><\/td>\ufeff<\/td><\/tr>
Server<\/td>cda-aws-test<\/td><\/tr>
Operating System<\/td>Red Hat Enterprise Linux release 8.5<\/td><\/tr>
Database Version<\/td>19.17.0.0.0<\/td><\/tr>
Database Name<\/td>CDB01<\/td><\/tr>
Target – Oracle Cloud Infrastructure<\/strong><\/td>\ufeff<\/td><\/tr>
Server<\/td>cda-oci-test<\/td><\/tr>
Operating System<\/td>Oracle Linux Server release 8.6<\/td><\/tr>
Database Version<\/td>19.17.0.0.0<\/td><\/tr>
Database Name<\/td>CDB01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Prerequisites & Parameters<\/h2>\n\n\n\n

To setup the Oracle Database Cloud Backup Module for OCI you need to collect the following information about your Oracle OCI environment:<\/p>\n\n\n\n

Parameter Description<\/strong><\/td>Parameter<\/strong><\/td>Examples used below<\/strong><\/td><\/tr>
Endpoint of the OCI Object store
(Region dependant)<\/td>		-host<\/td>https:\/\/objectstorage.eu-zurich-1<\/strong>.oraclecloud.com<\/td><\/tr>
Private Key file of your API Key<\/td>-pvtKeyFile<\/td>\/u01\/app\/oracle\/admin\/secrets\/id_oiam.pem<\/td><\/tr>
Public Fingerprint of your API Key<\/td>-pubFingerPrint<\/td>b5:xx:xx:xx:5f<\/td><\/tr>
Your Tenancy OCID<\/td>-tOCID<\/td>ocid1.tenancy.oc1..xxxxxxxxxxxx
<\/td><\/tr>
User OCID<\/td>-uOCID<\/td>ocid1.user.oc1..xxxxxxxxxxxx<\/td><\/tr>
Compartment OCID for the bucket<\/td>-cOCID<\/td>ocid1.compartment.oc1..xxxxxxxxxxx<\/td><\/tr>
Bucket name<\/td>-bucket <\/td>orabackup<\/td><\/tr>
Folder where the wallet will be saved<\/td>-walletDir<\/td>\/u01\/app\/oracle\/admin\/wallet<\/td><\/tr>
Where to save the libopc.so library<\/td>-libDir<\/td>$ORACLE_HOME\/lib<\/td><\/tr>
Where to save the configuration to<\/td>-configfile<\/td>\/u01\/app\/oracle\/admin\/ocibackup\/ocibackup.conf<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

The OCIDs have been masked & shortened for readability and you can find your information in the Oracle OCI console.<\/p>\n\n\n\n

Both servers will have to have been granted access through the firewall to the Oracle Object Store, in my example this is https:\/\/objectstorage.eu-zurich-1.oraclecloud.com. You can also configure the backup module to use a HTTP proxy if required.<\/p>\n\n\n\n

Install the Oracle Database Cloud Backup Module for OCI<\/h2>\n\n\n\n

This java module performs the following tasks:<\/p>\n\n\n\n