Your expertise is requested for these customer requirements:
1. The Data Guard environment must be in maximum protection mode.
2. Reports must be offloaded to a physical standby database.
3. There must be no lag between the primary and standby databases that affect the reports produced.
4. The primary database must be resilient in case of a single network failure.
Which solution is correct for these requirements?
A.
two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
B.
two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
C.
one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
D.
one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
E.
two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCH|VE_DEST_n attnbutes SYNC NOAFFIRM to minimize the performance impact on the primary.
D is sufficient, but B is best practice (to foresee 2 phy standbys in maxprotection mode)
option [D] doesn’t fulfills requirement No. 4
Correct, B, agree with the remark of PeraDetlic
Agreee on “B”
B