This discussion is archived
1 Reply Latest reply: Apr 17, 2013 12:34 AM by Sunny kichloo RSS

LGWR SYNC & LGWR ASYNC

1003541 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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

Legend

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