By Joel Pérez ( Oracle ACED )& Kamran Agayev A. ( Oracle ACED )
In this guide, I will show you how to create a primary and standby database in the cloud. Login to your cloud account, switch to the Oracle Database Cloud Service page and create a new service. Select “Oracle Database Cloud Service” as a subscription type and click Next.
Select a database release and click Next.
Select “Enterprise Edition – Extreme Performance” as a Software Edition and click Next
Provide the service name, SSH public key and select “Standby Database with Data Guard” option, select “High Availability” and click Next
Review the configuration settings and click Create to create a primary and a standby database
After a few minutes the primary and standby database will be created successfully
Click on the service name (srvdg) to open the home page of both databases
Now open two different Putty executables and connect to the both machines
Connect to the both databases and check the DB_UNIQUE_NAME parameter. PRODDB_01 is set to the primary database, PRODDB_02 for the standby database. Also check LOG_ARCHIVE_DEST_2 parameter on the primary database. As you see, archived log files are shipped to the standby database using PRODDB_02
Now let’s test the functionality of the standby database. First of all, open an alert.log file of the standby database, switch the log file on the primary database and check if the log file is applied
Now perform a switchover
Switch the log file and see if it is applied to the new standby database
It worked. Now switch back
As you see, it’s very easy to create a database with its own standby database in the cloud!
We hope this article can be helpful for you and see us on next article.
About the Authors
Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialized in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries in 5 continents and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish & OTN Portuguese. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA(Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China and more. Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004 and as one of the biggest professional achievement in his career he was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Chief Technologist in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China www.Enmotech.com
Kamran Agayev A. is an Oracle Certified Master, Oracle Clusterware Certified Expert and RAC Implement Specialist, Oracle Certified Professional (9i,10g,11g) and Oracle ACE Director working as a DBA team head at AzerCell Telecom LLC. He's author of the books Oracle Backup and Recovery: Expert secrets for using RMAN and Data Pump and Oracle Certified Master 11G Exam Guide. He runs a popular blog kamranagayev.com where he shares his experience and contributes fairly regularly to newsgroups, forums, and user group meetings and events around the world. He is a frequent speaker and presented in many countries, most recently at the USA, Japan, Thailand, China, India, Argentina, Uruguay, Panama, Costa Rica, Mexico, Guatemala, Finland and Turkey He is President of Azerbaijan Oracle User Group (AzerOUG) and delivers a class about Oracle Database Administration at Qafqaz University.