Advantages and disadvantages of performing failback with controlled transition

There are both advantages and disadvantages to this method of failback processing.

The advantages are as follows:

  • Downtime in the event of a failure is minimized.
  • You maintain complete control over when and how the transition of both databases is performed.
  • In the event of a primary transition failure, you can still use the secondary database for production activity.
  • In the event of a secondary transition failure, you can use the primary database for production activity.

The disadvantages are as follows:

  • You must perform additional steps to complete failback.
  • You must have access to both the primary and secondary machines.
  • Multiple database shutdowns are required.
  • You must restart both databases after they successfully transition.