This discussion is archived
2 Replies Latest reply: Aug 22, 2013 7:26 AM by mseberg RSS

syn & asyn in DG configuration

182114cd-8c1f-486e-82dd-e9b1a0717aed Newbie
Currently Being Moderated

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

  • 1. Re: syn & asyn in DG configuration
    yasinyazici Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points