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

Examine the Data Guard configuration:
DGMGRL > show configuration;

Configuration-Animals -

Protection Mode: MaxPerformance -
Databases:
dogs-Primary database
sheep-Snapshot standby database
cats-Snapshot standby database

Fast-Start Failover: DISABLED -
Configuration Status:

SUCCESS -
You receive an error while attempting to raise the protection mode to Maximum Availability:
DGMGDRL> edit configuration set protection mode as maxavailability;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
Failed.
Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability.

Answer options

• A. DGMGRL> convert database sheep to physical standby;
• B. DGMGRL> convert database cats to physical standby;
• C. DGMGRL> edit database dogs set property LogXptMode= fastsync;
• D. DGMGRL> edit database sheep set property LogXptMode= fastsync;
• E. DGMGRL> edit database cats set property LogXptMode= sync;

Correct answer: B, E

Explanation

Converting the 'cats' database to a physical standby (option B) would provide a valid standby database to support Maximum Availability mode. Additionally, setting the LogXptMode to sync for the 'cats' database (option E) ensures that it is ready for Maximum Availability, while the other options either do not provide a valid standby or are not relevant to the protection mode requirements.