ORA-16198: LGWR received timedout error from KSR
ORA-16198 意味著主庫上的LOG_ARCHIVE_DEST_2的NET_TIMEOUT設置的太小，導致LNS不能在設置的時間內將日志傳輸到備庫。
解決方法是提高NET_TIMEOUT的值到15-20 秒，
SQL>ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 SERVICE=xyz_STANDBY LGWR SYNC DB_UNIQUE_NAME=xyz_STANDBY NET_TIMEOUT=30 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)；
但是查看數據庫中的NET_TIMEOUT 值的設置。
09:33:47 ops$admin@rac1>select DEST_NAME,NET_TIMEOUT FROM V$ARCHIVE_DEST;
DEST_NAME ? ? ? ? ? ? ? ? NET_TIMEOUT
------------------------- -----------
LOG_ARCHIVE_DEST_1 ? ? ? ? ? ? ? ? ?0
LOG_ARCHIVE_DEST_2 ? ? ? ? ? ? ? ? 30
LOG_ARCHIVE_DEST_3 ? ? ? ? ? ? ? ? 30
NET_TIMEOUT 為30 秒。查看metalink ：
Note: If NET_TIMEOUT attribute has already been set to 30, and you still get ORA-16198, that means LNS couldn't finish sending redo block in 30 seconds.
The slowness may caused by:
1. Operating System. Please keep track of OS usage (like iostat).
2. Network. Please keep track network flow (like tcpdump).
不過也有可能是bug
Bug 9259587 ?Multiple LGWR reconnect attempts in Data Guard MAXIMUM_AVAILABILITY
This note gives a brief overview bug 9259587.?
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions BELOW 12.1
Versions confirmed as being affected 11.2.0.1 10.2.0.4
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in 12.1 (Future Release) 11.2.0.2 (Server Patch Set)
Symptoms:
Related To:
Hang (Process Spins)
Active Dataguard (ADG)
Physical Standby Database / Dataguard
Description
In a Data Guard configuration using LGWR SYNC transport on one or more LOG_ARCHIVE_DEST_n parameters, and using a protection mode of MAXIMUM_AVAILABILITY, then if the primary database becomes disconnected from the standby database, LGWR continues to attempt to reconnect to the standby database. It should instead avoid attempts to reconnect until an ARCH process has re-established communication with the standby database.
Rediscovery Notes:
Alert log contains messages like:
ORA-16198: LGWR received timedout error from KSR
LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16198)
LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Errors in file?
/app/oracle/diag/rdbms/ora11g_dga/ora11g/trace/ora11g_lgwr_290838.trc:
ORA-16198: Timeout incurred on internal channel during remote archival
LGWR: Network asynch I/O wait error 16198 log 2 service 'ora11g_DGb'
LGWR: Error 16198 disconnecting from destination LOG_ARCHIVE_DEST_2 standby?
host 'ora11g_DGb'
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
LGWR: Failed to archive log 2 thread 1 sequence 1422 (16198)
![RIL接聽電話沒有聲音的問題 [ RIL_Answer | RIL_SetAudioDevices ]](http://pic.xiahunao.cn/RIL接聽電話沒有聲音的問題 [ RIL_Answer | RIL_SetAudioDevices ])
![[轉]敏捷開發之Scrum掃盲,及敏捷開發中XP與SCRUM的區別](http://pic.xiahunao.cn/[轉]敏捷開發之Scrum掃盲,及敏捷開發中XP與SCRUM的區別)
![[轉]Flask --- 框架快速入門](http://pic.xiahunao.cn/[轉]Flask --- 框架快速入門)
)
