1.Please check status on primary

dbaascli dataguard status –details yes

2.Please check status of dataguard in standby

dbaascli dataguard status –details yes

3.Perform Switchover from primary to standby from console

4.Please note primary is standby and standby is now primary

5.Perform switchover from command line to switchover to primary again

Use the password option to supply the SYS user password if you changed it since creating the Data Guard configuration.

dbaascli dataguard switchover

Please restart ords service

[root@MYPRIM-dg02 ~]# /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 27834
INFO: Oracle REST Data Services started with PID 27834

6.You may do failover in case of failure of primary database

dbaascli dataguard failover

Force option can be specified if Dataguard configuration is in warning or error state

Use the force option if the status subcommand shows that the Data Guard configuration is in a warning or error state. Use the password option to supply the SYS user password if you changed it since creating the Data Guard configuration.

Please start ords services

7.You may reinstate the dataguard again to return back normal state

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.

To determine whether the database can be reinstated, use the dataguard status subcommand as described in Checking the Status of the Oracle Data Guard Configuration. A status of ORA-16661: the standby database needs to be reinstated indicates the standby database can be reinstated.

dbaascli dataguard reinstate

8.Please check the dataguard status again

Leave a Reply

Your email address will not be published. Required fields are marked *