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

Examine the Data Guard configuration:
DGMGRL> show configuration;

Configuration Animals -

Protection Mode: MaxPerformance -
Databases:
dogs- Primary database
sheep- Physical 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 Protection:
DGMGRL> edit configuration set protection mode as maxprotection:
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
Failed.
What can you conclude based on this error?

Answer options

• A. Cats is a snapshot standby database.
• B. The redo transport mode is set to ASYNC for the standby database Sheep.
• C. The redo transport mode is set to ASYNC for both standby databases.
• D. The redo transport mode is set to ASYNC for the standby database Cats.

Correct answer: B

Explanation

The error indicates that there are no standby databases that can support Maximum Protection mode, which implies that the redo transport mode for the standby database Sheep must be set to ASYNC. This prevents the configuration from fulfilling the requirements for Maximum Protection. The other options do not directly relate to the reason for the error.