Flashback was not even mentioned in the original post and was not a
consideration. Most of the production databases, which are the only
databases that need to be protected by DG configurations, do not have
flashback turned on. It is reasonable to assume that flashback is not
turned on in production, for performance reasons. It is also possible to
reactivate the standby using snapshot disk copies, however we cannot
assume that either. Simply put, flashback is not a part of this discussion.
On 8/22/19 2:20 PM, Neil Chandler wrote:
You appear to be confusing capability with performance.
You posted a throw-away comment that it wasn't possible: "After a fail-over you have to rebuild because fail-over does resetlogs.". That is incorrect. You do not have to rebuild if you have flashback switched on. You've been able to do this since Oracle 11.