Which solution is correct for these requirements?

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?

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.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Wim J

Wim J

D is sufficient, but B is best practice (to foresee 2 phy standbys in maxprotection mode)

PeraDetlic

PeraDetlic

option [D] doesn’t fulfills requirement No. 4

Wim J

Wim J

Correct, B, agree with the remark of PeraDetlic

JFK

JFK

Agreee on “B”