Data guard 中 alert 日志报错 "FAL archive failed"

Data guard 中主库 alert 日志报错

209974 Wed Dec 02 09:08:35 2015
209975 ARC8: Standby redo logfile selected for thread 1 sequence 14792 for destination LOG_ARCHIVE_DEST_2
209976 Wed Dec 02 09:08:43 2015
209977 ARCa: Archive log rejected (thread 1 sequence 14791) at host 'gtfdbdg'
209978 FAL[server, ARCa]: FAL archive failed, see trace file.
209979 ARCH: FAL archive failed. Archiver continuing
209980 ORACLE Instance gtfdb1 - Archival Error. Archiver continuing.
209981 Wed Dec 02 09:08:43 2015
209982 ARCb: Archive log rejected (thread 1 sequence 14792) at host 'gtfdbdg'
209983 FAL[server, ARCb]: FAL archive failed, see trace file.
209984 ARCH: FAL archive failed. Archiver continuing
209985 ORACLE Instance gtfdb1 - Archival Error. Archiver continuing.

查看主库的 fal_server 参数设置

SQL> show parameter fal


NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client     string
fal_server     string GTFDBDG

官方文档中这个参数的说明如下，这个参数用于物理备库和 Snapshot 备库中，从远端数据库获取缺失的归档日志，此值应该配置成主库的 service_name

FAL_SERVER = Oracle_Net_service_name

Physical Standby Snapshot Standby

Specifies one or more Oracle Net service names for the databases from which this standby database can fetch (request) missing archived redo log files.

查看数据库的 service_name

SQL> show parameter service_name

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names     string gtfdb

可以发现，这个参数配置成了大写，所有 alert 日志报错，更改 fal_server 参数

SQL> alter system set fal_server='gtfdbdg' scope=both;


System altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-1851224/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-1851224/