Not sure that this has anything to do with your problem but we were getting the same error message on our primary site when we put a logical standby into production in November=2E We had an Oracle consultant on-site helping us with our implementation and he determined that the error was occurring because we did not have a dedicated network connection between the primary and standby servers=2E The shared network resource did not have available bandwith for the primary to ship the archive log data in the buffer to the standby server=2E In our case this hung up our production database :(=2E We never did do anymore investigation to prove the guy right or wrong because the next day they pulled the plug on the Data Guard project=2E HTH Patty steve noyle <stevenoyle1@yahoo=2Ecom> Sent by: oracle-l-bounce@freelists=2Eorg 2005/01/19 08:38 AM Please respond to stevenoyle1@yahoo=2Ecom To cjpengel=2Edbalert@xs4all=2Enl, "oracle-l@freelists=2Eorg" <oracle-l@freelists=2Eorg> cc Subject Re: standby db - ora16166 LGWR timed out on Network Server 1 due to buffer full condition yes, the standby is pingable and the RFS process and listener are running at the standby=2E OS - solaris 8 the only entry in sqlnet=2Eora on both the primary & standby is NAMES=2EDIRECTORY_PATH=3D (TNSNAMES,HOSTNAME) v$database on primary shows primary,archivelog,read write, maximum performance v$database on standby shows physical standby, archivelog, mounted, maximum performance When I switched log file, the logfile got applied at the standby site almost instantaneously=2E I created a couple of objects on the primary and did verify that they got created on the standby=2E I've been getting this error when there were no activities on the database and yet when I tested loading a table yesterday, no error message=2E Appreciate any insights=2E thanks=2E steve --- Carel-Jan Engel <cjpengel=2Edbalert@xs4all=2Enl> wrote: > 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=2E2=2E0=2E4 standby database and > have > > been getting the following messages every day=2E > > > > Timing out on NetServer 1 > > prod=3D39901,cons=3D37325,threshold=3D2560 > > ORA-16166: LGWR timed out on Network Server 1 due > to > > buffer full condition=2E > > 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=2Etrc: > > 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=2Etrc: > > 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=2E According > to > > metalink, a way to solve the problem is to > increase > > the ASYNC buffer size=2E I've increased it to 20480 > but > > I'm still getting the same error message=2E 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=2E1 - "As a best practice define > your > > remote archive destination as such: > > service=3D<tns alias> LGWR ASYNC=3D20480 reopen=3D15 > > max_failure=3D10 net_timeout=3D30" > > > > > > Thanks=2E > > > > Steve > > > > > > > > __________________________________ > > Do you Yahoo!? > > Take Yahoo! Mail with you! Get it on your mobile > phone=2E > > http://mobile=2Eyahoo=2Ecom/maildemo > > -- > > http://www=2Efreelists=2Eorg/webpage/oracle-l > > > Best regards, > > > > Carel-Jan Engel > > > > =3D=3D=3D > > If you think education is expensive, try ignorance=2E > (Derek Bok) > > =3D=3D=3D > > > > 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 > > > -- > http://www=2Efreelists=2Eorg/webpage/oracle-l > __________________________________ Do you Yahoo!? All your favorites on one personal page ? Try My Yahoo! http://my=2Eyahoo=2Ecom -- http://www=2Efreelists=2Eorg/webpage/oracle-l ---------------------------------------------------------- This e-mail is confidential, intended solely for the use of the recipient(s) to whom it was addressed=2E If you have received it in error, please do not copy or distribute this e-mail=2E We ask that you notify us immediately by replying to the sender and then delete this e-mail=2E E-mail sent or received over the internet may not be secure=2E You should use caution when sending e-mail messages containing private and confidential information or consider other secure means to send the information=2E If you have any questions regarding the authenticity or security of e-mail you have received from Green Shield Canada please do not hesitate to contact us at 1-800-265-5615=2E Please visit us at our website: http://www=2Egreenshield=2Eca ---------------------------------------------------------- Ce message de courriel est confidentiel et s=92adresse uniquement =E0 la personne ou =E0 l=92organisme indiqu=E9(e)=2E Si vous l=92avez re=E7u par erreur, veuillez ne pas copier ni distribuer ce message de courriel=2E Nous vous demandons de nous aviser imm=E9diatement en r=E9pondant =E0 l=92exp=E9diteur, puis en supprimant ce message=2E Les messages envoy=E9s ou re=E7us par courriel pourraient ne pas =EAtre s=E9curis=E9s=2E Vous devriez =EAtre prudent lorsque vous envoyez des messages de courriel contenant des renseignements confidentiels et priv=E9s ou songer =E0 prendre d=92autres moyens s=E9curis=E9s pour envoyer les renseignements=2E Si vous avez des questions concernant l=92authenticit=E9 ou la s=E9curit=E9 d=92un courriel que vous avez re=E7u de Green Shield Canada, n=92h=E9sitez pas =E0 communiquer avec nous au 1-800-265-5615=2E Visitez notre site Web: http://www=2Egreenshield=2Eca -- //www.freelists.org/webpage/oracle-l