Examine the Data Guard configuration after an accidental switchover to Sheep:
DGMGRL> show configuration;
Configuration –Animals
Protection Mode: MaxAvailability
Databases:
sheep- Primary database
dogs- Logical standby database
cats- Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Dogs?
A.
Sheep will be a disabled logical standby database.
B.
Sheep will be an enabled logical standby database.
C.
Cats will be a disabled physical standby database that can be manually enabled.
D.
Cats will be an enabled physical standby database.
E.
Dogs will be the primary database.
B,C,E
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.
B,C,E are correct answers from my point o view.
B,C,E