Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration –Animals
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
sheep-Logical standby database
cats- Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Sheep?
A.
Cats will be an enabled logical standby database.
B.
Cats will be a disabled logical standby database.
C.
Dogs will be a logical standby database.
D.
Dogs will be a physical standby database.
E.
Sheep will be the primary database.
Explanation:
A switchover is a role reversal between the primary database and one of its standby databases. A switchover
guarantees no data loss and is typically done for planned maintenance of the primary system. During a
switchover, the primary database transitions to a standby role, and the standby database transitions to the
primary role.
https://docs.oracle.com/cd/B28359_01/server.111/b28295/sofo.htm
ACE
ACE
Explanation:
If the switchover transitions a logical standby database to the primary role, then:
– The original primary database will be switched to a logical standby role.
Neither the primary database nor the logical standby database needs to be restarted after the switchover completes.
Other logical standby bystander databases in the broker configuration will remain viable after the switchover.
There is no need to restart any databases.
All physical and snapshot standby databases will be disabled and must be re-created from a copy of the new primary database after a switchover to a logical standby database.
Switchover to a logical standby database is disallowed when the configuration is operating in maximum protection mode.
https://docs.oracle.com/database/121/DGBKR/sofo.htm#DGBKR340
A,C,E