Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration –Animals
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
cats- Physical standby database
sheep- Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Sheep?
A.
Dogs will be an enabled logical standby database.
B.
Sheep will be the primary database.
C.
Cats will be a disabled physical standby database.
D.
Dogs will be a disabled logical standby database.
E.
Cats will be an enabled physical standby 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
Correct Ans: A, B, C
Cats is a Physical standby database and the switchover is done to the Logical Standby. Anytime switchover to Logical standby database; physical and snapshot standby databases will be disabled by broker. However, if you switchover to physical standby then logical standby will be intact (enabled) and will automatically receive logs from the new primary database.
If the switchover transitions a logical standby database to the primary role:
– 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
B,C,D as stated below in the official document for oracle so what do you think?:
If there are physical or snapshot standby databases in the configuration and the switchover occurs to a logical standby database, you need to re-create those databases from a copy of the new primary database and then reenable those databases, as described in Reenabling Disabled Databases After a Role Change.
https://docs.oracle.com/database/121/DGBKR/sofo.htm#DGBKR3404
Example: Validate the Logical Standby Database
Validate the logical standby database, as follows:
DGMGRL> VALIDATE DATABASE ‘West_Sales’;
Database Role: Logical standby database
Primary Database: North_Sales
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Warning: Physical and snapshot standby databases will
be disabled if a role change is performed to this database
https://docs.oracle.com/database/121/DGBKR/cli.htm#DGBKR-GUID-486321F6-8816-4966-8813-EB5514A38FF2
Sorry correct answers are A,B,C
A,B,C