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;
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
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:-
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