Which three are true about using Flashback database through role transitions in a Data Guard environment? (Choose three.)
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.
-- - flashback to a point in time before switchover or failover
-- - Primary and standby retain current roles
-- - Database roles are flashed back when flashing back through logical switchover or failover
-- - Flashback database can be used to undo a physical database activation
-- Use Flashback Database to revert a database to a point in time before a physical standby database
-- switchover or failover. The database role does not change when flashing back through a physical
-- standby switchover, failover, or activation.
-- In a logical standby database, the FLASHBACK DATABASE command reverts the database to a system
-- change number (SCN) or time stamp before a switchover or failover. For a logical standby database, the
-- database reverts to its original role at the time of the flashback SCN or flashback time.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ScottL
1 year, 3 months agoJorgeZG
1 year, 11 months ago