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

Did your standby use standby redologs? did it run in archivelog mode?

On Tue, 18 Jan 2005 10:39:32 -0800 (PST) steve noyle <stevenoyle1_at_yahoo.com> 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

-- 
Kamus <kamusis_at_gmail.com>

那么多1G的邮箱，我能用来干什么:-)
A Oracle8i & 9i Certified DBA from China

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