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

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:

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 Sheep? (Choose three.)

Answer options

• A. Cats will be in the disabled state and must be manually reinstated.
• B. Cats will be in the disabled state and must be manually re-created.
• C. Dogs will be in the disabled state and must be manually re-created.
• D. Dogs will be in the disabled state and must be manually reinstated.
• E. The configuration will be in Maximum Performance mode.
• F. The configuration will be in Maximum Availability mode.

Correct answer: A, D, E

Explanation

After a failover to the logical standby database 'Sheep', the primary database 'Dogs' will be disabled and needs to be reinstated, so option A and D are correct. The configuration will switch to Maximum Performance mode since the Fast-Start Failover is disabled, making option E correct. Options B and C are incorrect as they misrepresent the state and requirement for the databases.