Re: Best practice for Dataguard in 10g?

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
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
>
> --
> Don Seiler
> http://seilerwerks.wordpress.com
> ultimate: http://www.mufc.us
>  --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: