With HADR, you can choose different levels of protection for potential data loss by specifying one of the following four synchronization modes:
- SYNC: This mode (synchronous) provides the greatest protection against transaction loss. This option, however, results in the longest transaction response time among the four modes. In this mode, log writes are considered successful only when logs have been written to log files on the primary database and when the primary database has received acknowledgement from the standby database that the logs have also been written to log files on the standby database. The log data is guaranteed to be stored at both sites.
- NEARSYNC: While this mode (near synchronous) has a shorter ...