At the last part of this article we performed Switchover, Failover & Reinstate Operations on Oracle Data Guard using the DBCS Console.
You can read it here:
Now in this this article we will show the necessary steps to perform Switchover, Failover & Reinstate Operations using the dbaascli Utility
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 using the dbaascli utility
You can use the dataguard switchover subcommand of the dbaascli utility to perform a switchover to the standby database in your Oracle Data Guard configuration.
To perform a switchover by using the dataguard switchover subcommand:
- Connect to the compute node in the Oracle Data Guard configuration that will host the new primary database as the opc user.
|Using username “opc”.
Authenticating with public key “rsa-key-20170425”
Passphrase for key “rsa-key-20170425”:
2. Start a root-user command shell and then switch to the oracle user.
|[opc@DATAGUARD-dg01 ~]$ sudo su – oracle
3. Initiate the switchover to the standby database
|[oracle@DATAGUARD-dg01 ~]$ dbaascli dataguard switchover
DBAAS CLI version 1.0.0
Executing command dataguard switchover
Performing switchover NOW, please wait…
New primary database “ORCL_02” is opening…
Operation requires startup of instance “ORCL” on database “ORCL_01”
Starting instance “ORCL”…
ORACLE instance started.
Switchover succeeded, new primary is “ORCL_02”
SUCCESS : Switchover to Standby operation completed successfully
4. Restart the ORDS server
|[root@DATAGUARD-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 8080,8181 854
INFO: Oracle REST Data Services started with PID 854
5. Check the status of standby database
|[oracle@DATAGUARD-dg01 ~]$ dbaascli dataguard status
DBAAS CLI version 1.0.0
Executing command dataguard status
SUCCESS : Dataguard is up and running
Configuration – fsc
Protection Mode: MaxPerformance
ORCL_02 – Primary database
ORCL_01 – Physical standby database
FastStartFailoverThreshold = ’30’
OperationTimeout = ‘120’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
Fast-Start Failover: DISABLED
If you want to read rest to the article, go across this link : Switchover,Failover and Reinstate in Database Cloud with dbaascli