standby db - ora16166 LGWR timed out on Network Server 1 due to buffer full condition
- From: steve noyle <stevenoyle1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 18 Jan 2005 10:39:32 -0800 (PST)
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
Other related posts:
