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

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution? (Choose three.)

Answer options

• A. Ensure that no ROWID data types are contained in the primary database.
• B. Ensure that flashback is enabled on the primary database.
• C. Ensure that supplemental logging is enabled on the primary database.
• D. Do not perform any nologging operations on the primary.
• E. Ensure that no BFILE LOB data types are contained in the primary database.

Correct answer: B, E

Explanation

Answer B is correct because flashback must be enabled for a logical standby database to revert to a consistent state during recovery. Answer E is also correct as BFILE LOB data types are not supported in logical standby databases. The other options, A, C, and D, are not prerequisites for setting up a logical standby database.