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

Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload
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.
Which two are true regarding the DelayMins Database Property for the standby database?

Answer options

• A. It can only be enabled for a configuration in Maximum Performance mode.
• B. It allows user errors on the primary to be recovered by using the physical standby database.
• C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
• D. It can only be enabled for a configuration in Maximum Availability mode.
• E. It allows logical corruptions on the primary to be recovered by using the physical standby database.
• F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

Correct answer: B, F

Explanation

Option B is correct because the DelayMins property allows for recovery from user errors on the primary database using the standby database. Option F is also correct as it specifies a delay in shipping redo. The other options are incorrect because they either misstate the requirements for enabling DelayMins or misinterpret its functionality.