This content has been marked as final. Show 2 replies
1) You CAN get data loss with maximum availability, if your standby fails and then your primary continues and then your primary fails. In this scenario you will have data loss. Maximum protection guarantees no data loss but will of course shut down your primary to maintain no data loss. It is recommended to have at least two standby databases with maximum protection.
2) What do you mean by "maintain consistency"?
Without commit transaction, will data loss not happen in Max Availability Mode?Transfer of transactions will be delayed till the Standby restarts and completes a catchup. Thus there will be a "lag". There will be data (transaction) loss if the primary goes down before the standby completes a catchup.
How archive logs maintain consistency in this mode?The standby attempts to catch up with the primary when it comes up again.
Hemant K Chitale