2 Replies Latest reply: Aug 22, 2013 9:26 AM by mseberg RSS

    syn & asyn in DG configuration

    1021203

      What is the difference between syn & asyn in DG configuration you’re using which one explains?

        • 1. Re: syn & asyn in DG configuration
          yasinyazici

          Hi

           

          synchronous=primary database wait to sent completed information to end user until redo to recover write both primary and at least standby database.this mode is required for maximum availability and maximum protection mode.


          asynchronous=primary database sent info to end user if commit is successful whether redo data to recover write to  standby database.

          • 2. Re: syn & asyn in DG configuration
            mseberg

            Hello;

             

            SYNC mode synchronizes the primary with the standby database and all DML on the primary server will NOT be committed until the logs have been successfully transported to the standby servers. The synchronous log transport mode is required for the Maximum Protection and Maximum Availability data protection modes.

             

            ASYNC allows updates (DML) to be committed on the primary server before the log file arrives on the standby servers. The asynchronous log transport mode is required for the Maximum Performance data protection mode.

             

            Please close your old questions to keep the forum clean. You have 14 questions this month all OPEN. With all due respect this is NOT cool.

             

            Best Regards

             

            mseberg