Re: Automation: DG Broker

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Neil Chandler <neil_chandler@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 22 Aug 2019 14:27:09 -0400

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.

Other related posts: