Oracle 18c-Performing a Data Guard Switchover using dbaascli Utility

       Oracle 18c-Performing a Data Guard Switchover using dbaascli Utility 

Description:- 

  • In this article we are going to perform oracle 18c dataguard Switchover step by steps using dbaascli utility
  • we can Perform the Switchover Operation using  Or dbaascli utility Or DBCS (Oracle Database Cloud Service Console)

Check this link how to create oracle database 18c dataguard

  • Oracle 18c-Configure Data Guard On Oracle Cloud Service Here
  • Creating an Oracle 18c Database Cloud Service Instance Here

Let’s start the Demo:-
Both Primary and Standby database already configured
Check the link Oracle 18c-Configure Data Guard On Oracle Cloud Service Here 

Step1:-Open the Oracle Database Cloud Service consoleOracle 18c-Configure Data Guard Details

Step2:-Before Switchover check the database level.                                                                                      Primary Side

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Standby Side

Overview Picture

Step3:-Login in to any one of server

Step4:-Check the Dataguard Status Using dbaascli Command                                                                          dbaascli dataguard status

Step5:-Check the Dataguard configuration status

Step6:-Start the swithover using dbaascli Command

dbaascli dataguard switchover

Swithover completed successfully using dbaascli utility

Step7:-Restart the ORDS services.

[oracle@chennai-dg01 ~]$ /etc/init.d/ords restart
INFO: Stopping Oracle REST Data Services…
INFO: Oracle REST Data Services stopped
INFO: Starting Oracle REST Data Services…
INFO: Oracle REST Data Services bound to ports 8181,8080 25619
INFO: Oracle REST Data Services started with PID 25619

Step8:-Post checks after a switchoverPrimary Side

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;Standby Side

Reference:-

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/data-guard-switchover-using-dbaascli.html

Catch Me On:- Hariprasath Rajaram

LinkedIn:    https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:   https://www.facebook.com/HariPrasathdba
FB Group:   https://www.facebook.com/groups/894402327369506/
FB Page:      https://www.facebook.com/dbahariprasath/?
Twitter:       https://twitter.com/hariprasathdba

 

 

Oracle 18c-Performing a Data Guard Switchover using DBCS Console

         Performing a Data Guard Switchover using DBCS Console

Description:- 

  • In this article we are going to perform oracle 18c dataguard Switchover step by steps using  DBCS (Oracle Database Cloud Service Console)
  • we can Perform the Switchover Operation using DBCS (Oracle Database Cloud Service Console) Or dbaascli utility

Check this link how to create oracle database 18c  dataguard

  • Oracle 18c-Configure Data Guard On Oracle Cloud Service Here
  • Creating an Oracle 18c Database Cloud Service Instance Here

Let’s start the Demo:-
Both Primary and Standby database already configured
Check the link Oracle 18c-Configure Data Guard On Oracle Cloud Service Here

Step1:-Open the Oracle Database Cloud Service console

Oracle 18c-Configure Data Guard DetailsStep2:-Before Swithover check the database level.

Primary Side 

Standby Side

Overview Picture

Step3:-From the menu we need select the Switchover button, and then confirm the action.Step4:-Switchover operation is started using DBCS Console and databases in Maintenance mode

Step5:-Swithover Successfully Completed using DBCS Console.

Step6:-After Swithover check the database level.                                                                                                select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Primary Side

Standby Side

Reference:-
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/data-guard-switchover.html

  • Oracle 18c-Configure Data Guard On Oracle Cloud Service Here
  • Creating an Oracle 18c Database Cloud Service Instance Here

Catch Me On:- Hariprasath Rajaram

LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter:  https://twitter.com/hariprasathdba