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

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?

Answer options

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

Correct answer: B, C, E

Explanation

After the switchover, Sheep becomes the logical standby database, which is enabled for use, so option B is correct. Cats remains a disabled physical standby database that can still be manually enabled, validating option C. Since the switchover was to Dogs, it assumes the role of the primary database, making option E true as well. Options A and D are incorrect because they misrepresent the statuses of Sheep and Cats.