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

Examine the Data Guard configuration:
DGMGRL> show configuration:

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

Fast-Start Failover: DISABLED -
Configuration Status:

ORA-01034: ORACLE not available -
ORA-16625: cannot reach database "dogs"
DGM-17017: unable to determine configuration status
Which three will be true after a successful failover to Cats?

Answer options

• A. Sheep will be in the disabled state.
• B. Sheep will be in the enabled state.
• C. Dogs will be in the disabled state and has to be manually reinstated.
• D. The configuration will be in Maximum Performance mode.
• E. The configuration will be in Maximum Availability mode.

Correct answer: B, C, D

Explanation

After a successful failover to Cats, Sheep will be in the enabled state (B) as it transitions to a new role. Dogs will not be available and will be in the disabled state, requiring manual reinstatement (C). The configuration will shift to Maximum Performance mode (D) because the primary database is no longer available, thus changing the protection mode.