Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-16166: LGWR timed out on Network Server 0 due to buffer full condition.

gl32546848Apr 24 2008 — edited Apr 25 2008
oracle : 9.2.0.6.0
os : x86_64 GNU/Linux
error :ORA-16166: LGWR timed out on Network Server 0 due to buffer full condition. in alert log

SGA :Total System Global Area 790071680 bytes
Fixed Size 743808 bytes
Variable Size 385875968 bytes
Database Buffers 402653184 bytes
Redo Buffers 798720 bytes

OPERATIONS : primary Dataguard is running
SQL> show parameter log_archive_dest_2

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=DR_AXPPR01 LGWR ASYNC=
40960

Recovery is normal, when full export is running on this weekly once (aprox) it is happening .

Pl. advice what can be done to fix this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2008
Added on Apr 24 2008
2 comments
1,527 views