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.