[转帖]ORA-03135: connection lost contact的解决方法

http://space.itpub.net/81912/viewspace-584

现象:

自从搭建了remote standby之后,每天都会收到primary的alert.log的报警邮件 ,内容是ORA-03135: connection lost contact.查看了错误发生的时间,在夜间两点.其余时间没有这个错误信息.以下分别是主库和从库的信息:

主库alert.log:

Tue Dec 11 02:01:10 2007

ARC1: Attempting destination LOG_ARCHIVE_DEST_3 network reconnect (3135)

ARC1: Destination LOG_ARCHIVE_DEST_3 network reconnect abandoned

Tue Dec 11 02:01:10 2007

Errors in file /u01/app/oracle/admin/prod/bdump/prod1_arc1_10383.trc:

ORA-03135: connection lost contact

FAL[server, ARC1]: Error 3135 creating remote archivelog file 'standby'

FAL[server, ARC1]: FAL archive failed, see trace file.

Tue Dec 11 02:01:11 2007

Errors in file /u01/app/oracle/admin/prod/bdump/prod1_arc1_10383.trc:

ORA-16055: FAL request rejected

ARCH: FAL archive failed. Archiver continuing

Tue Dec 11 02:01:11 2007

ORACLE Instance prod1 - Archival Error. Archiver continuing.

Tue Dec 11 02:01:16 2007

主库trace file信息:

*** 2007-12-11 02:01:10.994

Error 3135 creating standby archive log file at host 'standby'

*** 2007-12-11 02:01:10.994 60639 kcrr.c

ARC1: Attem