Re: weird Dataguard

On Aug 21, 10:43 am, <poky..._at_yahoo.fr> wrote:
> Hi,
>
> Environment: Oracle 10.2.0.3 on windows server 2003 with MAA dataguard.
>
> Problem: Only REDO LOG FILE on standby database are written.
>
> It seems that LNS process work fine on primary, but LGWR process does
> not write anything on primary REDO LOG File.
>
> Please, could you tell me where can I investigate ?
>
> Thanks

Please tell us how you are determining the primary redo is not being written. That would indeed be weird. "a transaction will not commit until the redo needed to recover that transaction is written to the local online redo log and to at least one remote standby redo log."

I'm guessing you have a confusion between LNS and LGWR? http://download.oracle.com/docs/cd/B19306_01/server.102/b25159/configbp.htm#CHDJCBEF

Also see bug Bug 5746174 if your db is hanging.

jg

--
@home.com is bogus.
Masters of Spin:  http://www.signonsandiego.com/uniontrib/20080820/news_1b20sdge.html