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?
After a switchover to Sheep, which is currently a logical standby database, several changes will occur in the Data Guard configuration. Firstly, Sheep will become the new primary database. As a result, Dogs, the current primary database, will transition to a new role and become a logical standby database. During this process, Dogs will be temporarily disabled and will need to be re-enabled in its new role. Lastly, Cats, being a physical standby database, will become disabled and will require a re-creation from the new primary database Sheep before it can be re-enabled.
Correct ABC
Dog will be a logical standby enable Cat will be a standy logical disable After a switch over a logical, the primary take logical standby role and the others will be disabled.
DGMGRL> show configuration; Configuration - DRSolution Protection Mode: MaxPerformance Members: boston - Primary database london - Physical standby database london2 - Logical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 29 seconds ago) DGMGRL> switchover to london2; Performing switchover NOW, please wait... Switchover succeeded, new primary is "london2" DGMGRL> show configuration; Configuration - DRSolution Protection Mode: MaxPerformance Members: london2 - Primary database boston - Logical standby database london - Physical standby database (disabled) ORA-16795: the standby database needs to be re-created Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 54 seconds ago)
Answer: A, B and E
C is wrong. Whereas a switchover to a logical standby database will invalidate and disable all of the physical and snapshot standby databases in the configuration. You will then need to reenable the physical standby databases from a backup of the new primary database before you can reenable them. https://docs.oracle.com/cd/B28359_01/server.111/b28295/sofo.htm#BCGIEFCF