We are on 10.2.0.4.0 and using LGWR. Never have issues. SERVICE=ups1 LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ups1 On Mon, Aug 31, 2009 at 11:48 AM, Don Seiler <don@xxxxxxxxx> wrote: > We have a client that uses LGWR shipping (but not real time apply). > It works fine for us, but we did hit one bug earlier this month: Bug > 5181800. The standby server got hung for other reasons and basically > stopped responding, and the LNS process on the primary caused > controlfile enqueue problems that eventually crashed the primary. We > had to defer logging to that standby until it was back up. > > FYI. Metalnik says it's fixed on 10.2.0.3 and 11g. One-off patch > available for 10.2.0.2 (which we were on at the time). > > Don. > > On Mon, Aug 31, 2009 at 3:03 AM, Nuno Souto<dbvision@xxxxxxxxxxxx> wrote: > > Jack van Zanen wrote,on my timestamp of 31/08/2009 1:55 PM: > > > >> we are running quite happily with arch log shipping. Can not comment on > >> lgwr shipping as I have not tried that yet. > >> but .... > >> I don't work with Data Warehouses very much but don't they have a lot > on > >> non logged operations normally? Dataguard does not like these. > >> enabling logging may be a performance hit. > >> just some extra thoughts > >> > > > > Thanks Jack. Already on the extra logging (for > > other reasons) and the system copes quite well, so it > > is not a concern. Sending all that extra data via > > network connection is, though. Hence the question. > > More concerned with best way to proceed than actually > > if it can be done: I know it can. Just need to decide > > if I should proceed with LGWR "a-la" 11g or go with ARCH > > "a-la" 10g. > > > > -- > > Cheers > > Nuno Souto > > in sunny Sydney, Australia > > dbvision@xxxxxxxxxxxx > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > > > > -- > Don Seiler > http://seilerwerks.wordpress.com > ultimate: http://www.mufc.us > -- > //www.freelists.org/webpage/oracle-l > > >