Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 15

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?

Answer options

• 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.

Correct answer: A, B, E

Explanation

After a switchover to Sheep, Sheep becomes the primary database, making option B correct. Since Dogs remains a logical standby database, it is enabled, which makes option A correct. Cats, originally a physical standby, will still be enabled following the switchover, confirming option E as correct. Options C and D are incorrect because they imply a disabled state that does not occur in this configuration.