Question 7
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?
DGMGRL> convert database cats to physical standby;
DGMGRL> convert database sheep to physical standby;
DGMGRL> convert database sheep to physical standby;
DGMGRL> convert database cats to physical standby;
DGMGRL>edit configuration set protection mode as maxperformance;
DGMGRL> convert database sheep to physical standby;
None, because you can directly failover to a Snapshot Standby Database.
Correct answer: E