Which three are required in order to use Real-Time Query without lagging behind the primary?
A.
There must be standby redo logs on the standby database.
B.
There must be standby redo logs on the primary database.
C.
The primary must ship redo asynchronously.
D.
COMPATIBLE must be set to 11.1.0 or higher.
E.
Real-Time apply must be enabled on the standby.
Explanation:
D: The COMPATIBLE database initialization parameter must be set to 11.0 or higher to use the real-time query
feature of the Oracle Active Data Guard option.
E: The apply lag control and Redo Apply synchronization mechanisms require that the client be connected and
issuing queries to a physical standby database that is in real-time query mode.
Incorrect Answers:
C: The standby database must receive redo data via the SYNC transport.
https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ps.htm#SBYDB00707
A,D,E
⁃ The COMPATIBLE database initialization parameter must be set to 11.0 or higher to use the real-time query feature of the Oracle Active Data Guard option.
– When using the Oracle Data Guard broker, it is not necessary to stop Redo Apply and restart Redo Apply when enabling real-time query.
⁃ Real-time query is not the same as real- time apply.
⁃ Real-time apply allows the recovery mechanisms to read from the standby redo logs at the same time that redo is being written to the standby redo logs. In the normal physical standby mode of operation, the database is only at the mount mode and would not allow any queries against user tables, even though real- time apply is enabled. Real-time query with –
Oracle Active Data Guard extends real-time apply by allowing the database to be opened and queries performed against it.
A,D,E