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

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
You wish to perform a failover to Sheep.
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?

Answer options

• A. DGMGRL> convert database cats to physical standby;
• B. DGMGRL> convert database sheep to physical standby;
• C. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;
• D. DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;
• E. None, because you can directly failover to a Snapshot Standby Database.

Correct answer: C

Explanation

The correct answer is C because converting the Snapshot standby database 'sheep' to a physical standby is necessary before a failover can occur. Options A, B, and D involve incorrect or incomplete commands, while option E is incorrect as you cannot directly failover to a Snapshot Standby Database without conversion.