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

Examine the Data Guard configuration:
DGMGRL > show configuration:

Configuration Animals -
Protection Mode: MaxAvailability
Databases:
cats- Primary database
dogs-Physical standby database
sheep-Logical standby database

Fast-Start Failover: DISABLED -
Configuration Status:

SUCCESS -
Which three will be true after a switchover to Dogs?

Answer options

• A. Sheep will be an enabled logical standby database.
• B. Cats will be an enabled physical standby database.
• C. Dogs will be the primary database.
• D. Sheep will be a disabled logical standby database.
• E. Cats will be a disabled physical standby database.

Correct answer: A, B, C

Explanation

After a switchover to Dogs, Dogs becomes the primary database, thus confirming option C as correct. Since Cats is still configured as a primary database before the switchover, it will not become a physical standby (option B is incorrect). Option A is correct as Sheep will remain enabled as the logical standby database. Options D and E are incorrect as they suggest Sheep and Cats are disabled, which is not the case post-switchover.