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?
To meet the requirements, two standby databases are recommended to ensure the primary database's resilience in case of a single network failure. At least one of the standby databases should be a physical standby with Real-Time Query enabled, ensuring reports are generated without lag (STANDBY_MAX_DATA_DELAY set to zero). Using synchronous transport (SYNC) aligns with the need for no lag between the primary and standby. Additionally, synchronous transport aligns with maximum protection mode, ensuring zero data loss if a failure occurs.
Answer D. With one standby with REAL-TIME Query in Maximum Availability (SYNC ) is possible to keep NO DATA LOST without affect primary in network failure and attend reports offload updated like Primary with STANDBY_MAX_DATA_DELAY=0
Answer: B
I am confused as the parameter STANDBY_MAX_DATA_DELAY session specific..........