Examine the Data Guard configuration:
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.
Question 66
Nope.
There are should be some differences (in Logical vs. Physical) as the answers are different.
Here are description
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?
That seems to be Question 80 Question, which seems a bit different (in Logical vs. Physical) here
And I think correct answers are
A,B,C
http://docs.oracle.com/database/121/DGBKR/sofo.htm#DGBKR335
If the switchover transitions a physical standby database to the primary role, then:
The original primary database will be switched to a physical standby role.
Bystander standbys will receive redo from the new primary database.
The original primary database will be restarted as a part of the switchover operation. Note that the new primary database does not need to be restarted.
Standby databases not involved in the switchover (known as bystander standby databases) continue operating in the state they were in before the switchover occurred and will automatically begin applying redo data received from the new primary database.
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.
IF
cats- Physical standby database
(else, responses won’t make any sense) then
A, B, C
why C –> Cats will be a disabled physical standby database.
Better I will go with E
The documentation clearly says
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.
A and B are correct. There is no third correct option