Re: Best practice for Dataguard in 10g?
Date: Mon, 31 Aug 2009 11:48:46 -0500
Message-ID: <94e86aed0908310948k6adf2872v9024bfef60cd3b6c_at_mail.gmail.com>
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_at_iinet.net.au> 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_at_iinet.net.au
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Don Seiler http://seilerwerks.wordpress.com ultimate: http://www.mufc.us -- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 31 2009 - 11:48:46 CDT