日期:2014-05-16  浏览次数:20462 次

物理standby出现ORA-03135丢失连接

环境:WINDOWS 2003 R2 SP2,ORACLE 10.2.0.3.0?

配置同机房和远端机房两台物理STANDBY,其中同机房采用LGWR传输,远端采用ARCH传输

?

现象:主服务器系统日志里间歇性报:“没有可用的归档目的地,归档失败”,但是两台STANDBY同步正常

主库ALERT日志中报 “ORA-16014:日志2的序列号XXX未归档,没有可用的目的地”,查看相应的TRACE文件,发现报ORA--3135:丢失连接错误

?

原因:通过检查,发现ALERT日志中报归档失败的都是远端归档目的地,而同机房的归档路径正常。而METALINK上对ORA-03135的描述如下:

Applies to:

Oracle Net Services - Version: 10.1.0.2.0 to 10.2.0.4.0
This problem can occur on any platform.

Symptoms

customer reported intermittently the archiver process hits error and?
following seen in the primary node alert log

Errors in file /opt/oracle/admin/ORCL/bdump/orcl1_arc4_28059.trc:?
ORA-03135: connection lost contact?
Mon Sep 22 22:24:51 2008?
FAL[server, ARC4]: FAL archive failed, see trace file.?
Mon Sep 22 22:24:51 2008?
Errors in file /opt/oracle/admin/ORCL/bdump/orcl1_arc4_28059.trc:?
ORA-16055: FAL request rejected?



.

Changes

There may be a firewall rule changed or the firewall is newly installed.

?

经确认,主库至远端库之间存在防火墙,且相互之间网络较慢,网络传输存在连接超时现象