9i Dataguard - LGWR writes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 9i Dataguard - LGWR writes

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    I am about to delve into the manual for Dataguard and from the outset I want to know basically (and high level) if the LGWR after a commit can propagate to the DR database?

    I know that a pitfall in 8i was that only the archived logs got applied at the remote site after a logswitch, meaning commited data in-between switches were lost after primary node failure.



  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    a commit is not a log switch so I doubt it pretty much it gets propagated.

    imagine a busy system with many commits if we propagate change after each commit this would be crazy

    your requirement sounds more like syncronous replication?

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    There are four modes of redo propagation from primary to standby in 9i. And yes, two of them support sinchronous writes of redo changes both to active (local) redo logs as well as to the stanby's redo log files.

    And BTW, writes to redo logs do not occur only when you perform commit.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width