By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

 

Before reading this article, we advise you to read this one:

#1 Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )

 

And as a Cloud Topic related you can read here as well one of our hotest articles:

 

In this this article we will show the necessary steps to perform Switchover, Failover & Reinstate Operations with the DBCS Console.

 

Performing a Switchover Operation

A switchover operation enables the primary database to switch roles with its standby database. There is no data loss during a switchover. After a switchover, each database continues to participate in the Oracle Data Guard configuration in its new role. A switchover is typically used to reduce primary database downtime during planned outages, such as operating system or hardware upgrades, or rolling upgrades of the Oracle database software and patch sets.

 

Steps to Perform a Switchover Operation

 

  1. Open the Oracle Database Cloud Service console.

7.JPG

Figure 7: service console

 

   2. In the list of deployments, click the name of the database deployment you want to perform the switchover on. The Oracle Database Cloud Service Overview page is displayed.

8.JPG

Figure 8: service overview

 

   3. To ensure the Overview page reflects the current role of each database, click the Refresh Configuration icon.

9.jpg

Figure 9: Refresh Configuration

 

  4. From the  menu for one of the database deployment’s compute nodes, select Switchover, and then confirm the action.

10.JPG

Figure 10: perform switchover

 

   5. The deployment has a status of Maintenance in the Oracle Database Cloud Service console until the switchover is complete.

11.JPG

Figure 11: maintenance status

 

   6. Refresh the page occasionally. Database Role will be updated to reflect the new role for each database.

12.JPG

Figure 12: Database Role Changed

 

Performing a Manual Failover Operation

A failover operation changes a standby database to the primary role in response to a primary database failure. If the primary database was not operating in either maximum protection mode or maximum availability mode before the failure, some data loss may occur. If Flashback Database is enabled on the primary database, it can be reinstated as a standby for the new primary database once the reason for the failure is corrected. A failover is typically used only when the primary database becomes unavailable, and there is no possibility of restoring it to service within a reasonable period of time.

 

Steps to Perform a Failover Operation

 

    1. Open the Oracle Database Cloud Service console.

13.JPG

Figure 13: DBCS console

 

    2. In the list of deployments, click the name of the database deployment you want to perform the failover on. The Oracle Database Cloud Service Overview page is displayed.

14.JPG

Figure 14: service overview

 

   3. To ensure the Overview page reflects the current role of each database, click the Refresh Configuration icon.

15.jpg

Figure 15: Refresh Configuration

 

  4. From the  menu for one of the database deployment’s compute nodes, select Failover, and then confirm the action.

16.JPG

Figure 16: perform failover

 

   5. The deployment has a status of Maintenance in the Oracle Database Cloud Service console until the failover is complete.

17.JPG

Figure 17: maintenance status

 

   6. Refresh the page occasionally. Database Role will be updated to reflect the new role for each database.

18.JPG

Figure 18: Failover completed

 

Performing a Reinstating a Failed Primary Database

After performing a failover to the standby database, you may be able to restore your original disaster-recovery solution by reinstating the failed primary database. You can use the Data Guard broker's reinstate capability to make the failed primary database a viable standby database for the new primary.

 

Steps to Perform a Reinstating a Failed Primary Database

 

      1. Open the Oracle Database Cloud Service console.

19.JPG

Figure 19: service console

 

      2. In the list of deployments, click the name of the database deployment you want to perform the reinstate on. The Oracle Database Cloud Service Overview page is displayed.

20.JPG

Figure 20: service overview

 

      3. To ensure the Overview page reflects the current role of each database, click the Refresh Configuration icon.

21.jpg

Figure 21: Refresh Configuration

 

      4. From the  menu for one of the database deployment’s compute nodes, select Reinstate, and then confirm the action.

22.JPG

Figure 22: perform reinstate

 

      5. The deployment has a status of Maintenance in the Oracle Database Cloud Service console until the failover is complete.

23.JPG

Figure 23: maintenance status

 

      6. Refresh the page occasionally. Database Role will be updated to reflect the new role for each database.

24.JPG

Figure 24: Reinstate completed

 

Conclusion

So, now you know that it is very easy to perform Switchover, Failover & Reinstate Operations with Console. The next and last part of this article, we will see the necessary steps to perform Switchover, Failover & Reinstate Operations with dbaascli utility.

If you want to be updated with remarkable articles and information about Oracle Database Cloud, Join our network, we will be please to have you there:

Joel Pérez: www.linkedin.com/in/acedjoelperez

Skant Gupta: www.linkedin.com/in/skantali/

 

Author Bios:

 

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, specialised 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 and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . 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. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.com