Deploying Business Continuity Database in Oracle Cloud

Introduction

Zaheer Syed (APPSDBAWORKSHOP)
4 min readMay 10, 2019

Oracle Database provides business continuity for its databases using Oracle Data Guard Technology. If there is disaster due to natural cause or human error then your application availability is at great risk. In order to avoid such situations organization will maintain another replica site to continue the business operations. But maintaining the replica means you need to maintain almost similar or little less resources on your Disaster recovery site. In a traditional method you need to maintain two site with enough network bandwidth between your sites to keep up the replication. The overall price for maintain both sites will be definitely huge amount.

Oracle Database offers business continuity service for its databases using the Oracle Database cloud Service. We can have our Disaster recover database ready in just few clicks

Lets proceed and see how simple it is to configure oracle Data Guard on oracle Cloud.

Step-1: Login to Oracle Cloud console

Oracle Cloud Dashboard

Step-2: Open Service Console

Step-3: Create Service

Here you should click on Create Service

Here we are selecting the deployment of single Instance with Data guard Standby configuration.

Step -4 : Provide Database configuration details

Step -5 : Validate Service configuration before deployment

Service Creation in progress

Service has been created successfully. Here we can see there are two servers in the configuration. One is primary and second is DR.

Confirmation screen about the service creation.

Step -6: Connecting to primary and Standby Servers using SSH

Provide the public IP address

Connecting the DR node:

Step-7: Connecting to Database and verifying the Database roles

Step-8: verify the replication between both nodes

Here we can see both databases are in synch.

Conclusion:

The overall experience of deploying data guard is amazing, its just few click and your business continuity Database is up and running. You need not have to call and open tickets/Service requests with infrastructure and network teams. The main benefit is you need not have to run and afford cost of two sites, eventually this will save lot of electricity, network link and many other considerable things.

About Author:

Syed Zaheer is an Oracle ACE and currently working as a Senior Oracle Application Specialist. He has a decade of experience in the implementation and management of Oracle E-Business suite, Oracle HA Stack, Oracle Fusion Middleware & Oracle Databases. He has extensive experience in working with Oracle Enterprise Linux and Oracle Solaris. He is an Apress author of “Practical Oracle E-Business suite — An Implementation & management Guide”.He is an active member of Oracle technology forums and Oracle awarded him the status of “GURU” for his contributions.He is also an active member of the Toad World community. He has published many articles on OTN & Toadworld community network. He is Oracle certified in Operating Systems, Application, Databases, Engineered systems and Middle ware.

Zaheer has been part of 30+ successful E-Business suite Implementations/Upgrades/Migrations from version 11i to version R12.2.x.
He has domain knowledge in diversified business verticals including financials, FMCG,manufacturing, and consulting. He is an active blogger since 2008 and has published 100+ unique articles on his blog (http://appsdbaworkshop.com) He was a speaker multiple international Oracle conferences — MEOUG, OUGF and TROUG.

--

--