The Maximum Availability mode

The Maximum Availability mode is the data protection mode that has the ability to run as a Maximum Protection or Maximum Performance mode depending on the accessibility of standby databases. In a normal operation where the standby is up and able to receive redo data synchronously, the primary database acts like the Maximum Protection mode and waits for acknowledgment from the standby database to complete transactions. However, the key point of the Maximum Availability mode is the behavior of the primary database when it's not able to receive acknowledgment from any standby database. It waits for a predefined period of time and if the connection cannot be established, the primary database continues its operation as a Maximum Performance mode database. The number of seconds that the primary waits before marking a standby inaccessible is defined with the NET_TIMEOUT attribute of the LOG_ARCHIVE_DEST_n parameter. The default value of this parameter is 30 seconds...