Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 52

Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

Answer options

• A. They are required on a logical standby for real-time apply.
• B. They are required only for synchronous redo transport.
• C. Only standby databases can write redo to them.
• D. It is recommended to have them on the primary database.
• E. They are required on a physical standby for real-time apply.
• F. The LGWR process writes to them on a standby database.

Correct answer: A, D, E

Explanation

The correct statements A, D, and E highlight the necessity of standby redo logs for real-time apply on logical and physical standbys, as well as the recommendation for their presence on primary databases. Option B is incorrect because standby redo logs are not limited to synchronous redo transport, and option C is wrong since primary databases can also generate redo logs, albeit not to standby redo logs directly.