Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 55

Examine the Data Guard configuration:
DGMGRL> show configuration;

Configuration Animals -
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
sheep- (*) Physical standby database
cats- Physical standby database

Fast-Start Failover: ENABLED -
Configuration Status:

SUCCESS -
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

Answer options

• A. The switchover succeeds but Dogs need to be reinstated.
• B. The switchover succeeds but Fast-Start Failover is suspended.
• C. The switchover succeeds and Cats become the new failover target.
• D. The switchover succeeds and Dogs become the new failover target.
• E. It results in an error indicating that a switchover is not allowed.

Correct answer: D

Explanation

When the switchover command is issued to sheep, the operation succeeds and Dogs, being the primary database before the switchover, automatically become the new failover target. The other options incorrectly imply situations that do not apply, such as needing reinstatement or errors occurring when the operation is valid.