Exam 1z0-066 All QuestionsBrowse all questions from this exam
Go to Exam
Question 75

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?

    Correct Answer: C

    The error ORA-16627 indicates that the Data Guard configuration does not support the Maximum Protection mode because there are no standby databases that operate in SYNC redo transport mode. Given that Cats is a snapshot standby database and therefore cannot be used for Maximum Protection mode, it implies that the primary database only has Sheep as the physical standby, necessitating it to be in SYNC mode. However, the error suggests that no standby database is in SYNC mode. This means that Sheep is most likely set to ASYNC mode. Hence, it is reasonable to conclude that the redo transport mode is set to ASYNC for both standby databases, preventing the switch to Maximum Protection mode.

Discussion
RockficsOption: B

In the state of Snapshot Standby can't be used for Maximum Protection, so the other standby have to be SYNC. For Maximum Protection with the requirement of Snapshot Standby must exist 2 minimum 1 standby for SYNC and other for Snapshot

JESUSBBOption: B

Answer: B