Oracle DBaaS 1z0-160 part 23 :- Dataguard Administration in oracle cloud
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
6.You may do failover in case of failure of primary database
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
About the Author
debasis maity
12+ years of rich experience on Database Administrations and on Infrastructure Solution Architect. AWS Certified Solution Architect and Senior Oracle DBA