Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> standby db - ora16166 LGWR timed out on Network Server 1 due to buffer full condition
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 18 2005 - 23:19:28 CST
![]() |
![]() |