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

  • From: Leyi Zhang <kamusis@xxxxxxxxx>
  • To: stevenoyle1@xxxxxxxxx
  • Date: Wed, 19 Jan 2005 10:57:58 +0800

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@xxxxxxxxx> 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

-- 
Kamus <kamusis@xxxxxxxxx>

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

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

Other related posts: