Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled.
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors:
ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded.
Which two would you recommend to avoid this error?
To avoid the ORA-03172 error, it's essential to address the potential lag and latency in the Data Guard environment. Increasing the network bandwidth between the primary and standby databases helps ensure that redo data is transmitted more quickly, reducing the lag. Additionally, increasing the number of standby redo log files on the primary database can help in managing the redo data more efficiently, further minimizing the delay between the primary and standby databases.
I think the solution to the problem should not modify the design of the dataguard. In that case the correct answer should be BE
Answer: B y E
Network between PrY an STBY optimize the time of syncro In the same way, if STBY REDO LOGS are not enough