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.
