How to configure max avail mode in Dataguard?
We are implementing Dataguard, and we have set the log_archive_dest_2 to ...LGWR SYNC AFFIRM, which is the setting for Maximum Availabilty, but this is also the setting for Maximum Protection. When we set these parameters, and we have a network problem, the Primary database will hang, we have to set the log_archive_dest_2 back to ...LGWR ASYNC AFFIRM, for the database to clear. I am sure maximum availablity mode should revert to Maximum performance mode, if we get network problems. Why is the primary database hanging? When I check the protection_level on v$database, it says 'Maximum performance. Do I need to set the database to maximum availability? and if so, do I change the protection level on the standby or primary database. Thanks.