Re: standby db - ora16166 LGWR timed out on Network Server 1 due to buffer full condition

From: steve noyle <stevenoyle1_at_yahoo.com>
Date: Wed, 19 Jan 2005 05:38:50 -0800 (PST)
Message-ID: <20050119133850.59095.qmail@web51007.mail.yahoo.com>

yes, the standby is pingable and the RFS process and listener are running at the standby.

OS - solaris 8

the only entry in sqlnet.ora on both the primary & standby is
NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME) v$database on primary shows primary,archivelog,read write, maximum performance

v$database on standby shows physical standby, archivelog, mounted, maximum performance

When I switched log file, the logfile got applied at the standby site almost instantaneously. I created a couple of objects on the primary and did verify that they got created on the standby.

I've been getting this error when there were no activities on the database and yet when I tested loading a table yesterday, no error message.

Appreciate any insights.

thanks.

steve

• Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:

> Some counterquestions to start with:
> OS? Version? SQL*Net settings? Listener running on
> standby? Standby
> pingable? Is the RFS process at the standby running?
> When you perform a
> logswitch, what happens? Will any logfile arrive at
> the standby?
> what does V$DATABASE show you?
>
>
> On Tue, 2005-01-18 at 19:39, steve noyle wrote:
>
> > hi,
> > I've just set up a 9.2.0.4 standby database and
> have
> > been getting the following messages every day.
> >
> > Timing out on NetServer 1
> > prod=39901,cons=37325,threshold=2560
> > ORA-16166: LGWR timed out on Network Server 1 due
> to
> > buffer full condition.
> > No action is required since the log file
> > transfer will be attempted via ARCH
> > Sun Jan 16 02:34:14 2005
> > Errors in file
> >
>

/u01/app/oracle/admin/test01/bdump/test01_lgwr_12800.trc:
> > ORA-16166: LGWR network server failed to send
> remote
> > message
> > LGWR: I/O error 16166 archiving log 3 to 'ddb03ps'
> > Sun Jan 16 02:34:14 2005
> > Errors in file
> >
>

/u01/app/oracle/admin/test01/bdump/test01_lgwr_12800.trc:
> > ORA-16166: LGWR network server failed to send
> remote
> > message
> >
> >
> > The source database is a test database and there
> are
> > no workload generated on the database. According
> to
> > metalink, a way to solve the problem is to
> increase
> > the ASYNC buffer size. I've increased it to 20480
> but
> > I'm still getting the same error message. Also, I
> do
> > not understand why would my buffer be full when I
> have
> > absolutely nothing running on the source? Does
> anyone
> > has any clue what is going on or how can I
> > troubleshoot the problem?
> >
> > >From Note:247129.1 - "As a best practice define
> your
> > remote archive destination as such:
> > service=<tns alias> LGWR ASYNC=20480 reopen=15
> > max_failure=10 net_timeout=30"
> >
> >
> > Thanks.
> >
> > Steve
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Take Yahoo! Mail with you! Get it on your mobile
> phone.
> > http://mobile.yahoo.com/maildemo
> > --
> > http://www.freelists.org/webpage/oracle-l
>
>
> Best regards,
>
>
>
> Carel-Jan Engel
>
>
>
> ===
>
> If you think education is expensive, try ignorance.
> (Derek Bok)
>
> ===
>
>
>
> Upcoming appearances:
>
>
> * Jan 27, 2005: London, UKOUG Unix SIG: Data
> Guard Best Practices
>
> * Feb 9-10, 2005: Denver, RMOUG Training Days:
> Data Guard
> Performance Issues
>
> * Mar 6-10, 2005: Dallas, Hotsos Symposium:
> Data Guard Performance
> Issues
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
                

---

Do you Yahoo!?
All your favorites on one personal page – Try My Yahoo! http://my.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 19 2005 - 08:41:31 CST