Re: standby db - ora16166 LGWR timed out on Network Server 1 due to buffer full condition
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Jan 2005 01:40:35 +0100
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
> --
> //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
