1 Reply Latest reply: Apr 17, 2013 2:34 AM by Sunny kichloo RSS

    LGWR SYNC & LGWR ASYNC

    1003541
      Hello all,

      I am new in using Oracle Data Guard and I apologize in advance for my trivial questions.

      With LGWR SYNC, there is dependency between LGWR & LNS. LGWR waits for confirmation from the LNS.
      With LGWR ASYNC, there is no dependency between LGWR & LNS. LGWR does not wait for confirmation from LNS.

      Am i correct?


      Does LNS read Redo records from Redolog Buffer or Redolog File when LGWR SYNC and ASYNC is being used?

      Regards
        • 1. Re: LGWR SYNC & LGWR ASYNC
          Sunny kichloo
          With LGWR SYNC, there is dependency between LGWR & LNS. LGWR waits for confirmation from the LNS. 
          Yes.
          With LGWR ASYNC, there is no dependency between LGWR & LNS. LGWR does not wait for confirmation from LNS.
          Yes.


          Does LNS read Redo records from Redolog Buffer or Redolog File when LGWR SYNC and ASYNC is being used? 
          From log buffer.

          http://www.bash-dba.com/2012/10/oracle-data-guard-synchronous-vs.html