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

Which three are true about using Flashback database through role transitions in a Data Guard environment? (Choose three.)

Answer options

• A. Flashback database may not be used to undo a physical standby database activation.
• B. Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.
• C. Logical standby database role are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.
• D. Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.
• E. Logical standby databases retain their current role when you flash back through to a point in time the switchover occurred which caused this database to become a logical standby.

Correct answer: B, C, D

Explanation

Option B is correct because physical standby databases do retain their role when flashed back before a reinstate. Option C is accurate as logical standby databases revert to their original roles when flashed back to a time before the switchover. Option D is also correct since physical standby databases maintain their roles when the flashback occurs before the switchover, but options A and E contain inaccuracies regarding the behavior of Flashback in these contexts.