Skip navigation

I explained in the first post From Disaster to Recovery part I the importance of having a DR site set up for your IT infrastructure and for your business overall.

 

Here are three examples of architectures that could lead to a DR solution set in place would be:

 

     1. Using Database Backup as a Service

 

 

 

 

This is effective when all your database backups are done using Database Backup Cloud Service and all the backups from production environment go on the Cloud Storage. This allows you to restore your databases both in the on-premise servers or/and on the Cloud Services like Database Cloud Service or Exadata Cloud Service.

 

     2. Using Data Guard or Active Data Guard.

 

 

 

If backing up the databases on the cloud storage is not enough you could chose for an Active Data Guard replication between the sites.

The Active Data Guard Replication could be implemented using the Maximum Availability Architecture giving you also data consistency and protection.

This way the standby database would be in read-only mode and could also be used for reporting, queries or sandbox creation.

 

     

     3. Full Stack Disaster Recovery

 

 

 

  • Database
    • Use Database Backup Service to send on-premise database backups to Oracle Cloud using RMAN
    • Restore the database in the cloud from the backup
  • Application
    • Use JAVA / REST calls to copy on-premise application data to Storage Cloud Service
    • You can also use OSC Appliance for the copy
    • Restore the data into the compute cloud from the object storage

 

The solutions and the architectures may vary also according to each company’s restrictions, SLAs or prerequisites. Using Database Cloud service as a standby-site for disaster recovery would prove to be both efficient and cost effective.

 

**The views expressed in this post are my own and do not necessarily reflect the views of Oracle.

Although the picture below seems extremely funny, in theory screaming for help is the last thing that we should do when disaster happens. But the theory is not reality!

 

 

We would expect that Disaster Recovery plans are just an extra measure for natural disasters. So we build our datacenters deep in the ground, Earth-quake free zones, and different geographic arias. But I saw some dazzling numbers that contradicted me:

 

It is rather difficult to keep your entire business alive when a junior electric engineer misunderstands which cable is the most important power cord for the datacenter and disconnects it. And this is just the simplest example that you can’t predict all the downtimes.

A disaster recovery solution should cover at least these aspects:

    • Avoid Single Point of Failure
    • Prevent Data Loss
    • Reduce Downtime Cost & Revenue Impact for Planned & Unplanned Outages
    • Disaster and Data Protection for Compliance & Regulatory Purposes

 

Depending on the tools and architecture used a Disaster Recovery plan can lead to a complex and expensive implementations that will make you question twice: why should we do it.

 

It is just a matter of choosing the right tools.

A low cost, simple and low risk solution for Oracle databases would be using Data Guard to Oracle Cloud environment.

The combo would easily cover:

  • Primary / DR synchronisation

Using Data Guard it would assure the synchronization on different MAA best practices.

 

  • On-Demand elasticity after migration to the DR site

Using the Database Cloud Service offers you the elasticity needed to fit your database in the cloud.

 

  • High investment in Hardware and Software & DR site operational aspects

DR requires High investments in new Hardware, Software licenses and additional staff to operate the site... Using Oracle Database Cloud Service would drastically reduce these costs.

 

  • Data inconsistency or corruption

Data corruption can happen if remote storage mirroring solutions are used to replicate database files instead of using Oracle Data Guard of Golden Gate.

 

From Disaster to Recovery it’s just a matter of choosing the proper tools, software and the right partners. In my next post I will detail 3 Disaster Recovery architectures using Database Cloud Backup Service, Data Guard, and obviously the Oracle Public Cloud environment.

 

**The views expressed in this post are my own and do not necessarily reflect the views of Oracle.