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.