Select Page

Three Options for Oracle Cloud Backups

Megan Elphingstone | | August 25, 2017

oraclec cloud migration

The Oracle Cloud offers three options for database backups to businesses that reduce data center costs, increase redundancy and allow for easy storage growth over time. Customers ready to move their database to the cloud will find the easy, automatic backup setup to be simple, and easy to customize.  Customers who want to move quickly to off-site backups should consider the Oracle Cloud Backup Module, which allows on-premises databases to create cloud backups via RMAN.  Lastly, Oracle Storage Cloud services can be used to store copies of backups along with other data.  This blog post will cover the requirements for each type of backup and the pros and cons of each.  For all cloud backups, the advantages include scalability, reliability, and security.

Cloud Backups for a Cloud Database

A backup and recovery plan can be specified with the initial database service creation in the Oracle Cloud:

The easiest way to get up and running is to pre-create a storage container under the storage dashboard > Create Container.  Once the container has been created, it can be specified in the Backup and Recover Configuration listed above.  The default backup setup consists of a daily full backup; archive logs are backed up twice and hour.  The retention period is 30 days. This is a great place to start, and everything can be configured to your business requirements after setup.

Pro: Easy to get started, allows for cloud and local backups – (backups to disk on cloud VM)

Cons: Requires cloud database (only a con if you are not ready to move to cloud)

Requirements: Oracle Cloud licenses for database, backups, storage are required.

Oracle Cloud Backup Module

Image from Oracle White Paper, Oracle Database Cloud Service Best Practice for On-Premise and Cloud Databases.

For databases that remain in your data center (on-premises) options exist for Cloud Backups with the Oracle Database Cloud Backup Module.  Sign up for a trial license, download the binaries and configure RMAN and you can have an offsite backup completed that same day.  Configure RMAN to go to SBT_TAPE, with the library specified and that is all that it takes.  OCBS requires that the backups be encrypted, which adds a layer of security.  The consideration here is that when a restore from the cloud is required, it may be slower than a local onsite backup.  Restores should be tested to make sure the timing complies with any corporate standards to be sure you can meet your recovery time objective.

Pro: Integrated with RMAN, easy to configure

Con: Time to restore

Required: Must be on Oracle version 10.2.0.5 or above. No special licensing is required to use the module to back up to the Oracle Database Backup Service.  The only requirement is to purchase enough storage capacity of Oracle Database Backup Service.

Oracle Cloud Storage Service

Lastly, you can continue with your current backup plans to disk or tape, and then ship compressed backups, along with other data to be stored off site.  Because the Oracle Cloud Storage Service is required for the Oracle Cloud Backup Module, it seems logical to backup straight to the cloud.  But if your time to recovery time objective cannot be met with a cloud backup, then the Oracle Cloud Storage Service option may be a great alternative.  With this, you can create onsite backups and then later ship them to the cloud.  The Oracle Cloud can be used to store a second copy of your backup, for global data sharing, or to store older data with long retention times.

Pro: Scalability, reliability, protection against local data center outages

Con: Time to restore, not integrated with RMAN, requires the extra step of compression and copy after the backup is complete

Required: Oracle Cloud Storage license

Conclusion:

IT research firm Gartner predicts a 1 Trillion-dollar shift in spending from traditional IT to the Cloud by 2020.  Storing databases in the cloud can protect against a data center loss, or storage outage and provide peace of mind for business continuity.

To learn more about Oracle database cloud services please download Datavail’s white paper, Oracle Database Cloud Service Muscles-Up, or contact Datavail today. Datavail can provide your organization with database cloud consulting services and Oracle upgrade support.

Datavail is a specialized IT services company focused on Data Management with solutions in BI/DW, analytics, database administration, custom application development, and enterprise applications. We provide both professional and managed services delivered via our global delivery model, focused on Microsoft, Oracle and other leading technologies.

References:

Oracle Database Backup Service – FAQ (Doc ID 1640149.1)

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/customize-backup-configuration.html#GUID-78848793-B095-47F1-B87E-C4F8DC697824

https://docs.oracle.com/en/cloud/paas/db-backup-cloud/index.html

https://cloud.oracle.com/storage http://www.oracle.com/technetwork/database/features/availability/twp-oracledatabasebackupservice-2183633.pdf

https://go.oracle.com/LP=31008/?elqCampaignId=48574&src1=ad:pas:go:dg:iaas&src2=wwmk160606p00038c0001&SC=sckw=WWMK160606P00038C0001&mkwid=s52I6NwrR|pcrid|103494201379|pkw|+oracle +data +backup +cloud|pmt|b|pdv|c|sckhttps://go.oracle.com/

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS