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

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