FAL[server, ARC3]: FAL archive failed Error 16401 creating standby archive log file at host

原创 2015年11月19日 11:09:40

主库alert相关报错如下:

Tue Nov 17 21:04:26 2015

ARC3: Archive log rejected (thread 2 sequence 11378) at host 'PRODS'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance PROD2 - Archival Error. Archiver continuing.
Tue Nov 17 21:10:05 2015

查找主库相关trace:

[root@cisdb02 trace]# ls -lrt *arc*
-rw-r----- 1 oracle asmadmin  446473 Nov 19 07:01 PROD2_arc3_92713.trm
-rw-r----- 1 oracle asmadmin 3534044 Nov 19 07:01 PROD2_arc3_92713.trc

*** 2015-11-17 21:04:26.332
Error 16401 creating standby archive log file at host 'PRODS'
kcrrwkx: unknown error:16401
OSSIPC:SKGXP:[c9ed480.38243]{0}: (92713 <- 13377)SKGXPDOAINVALCON: connection 0xcb4ca70 admno 0x336c50eb scoono 0x69c551c8 acconn 0x534de827 getting closed. inactive: 0


备库alert相关报错如下:

Tue Nov 17 21:04:26 2015
ARC3: Archive log rejected (thread 2 sequence 11378) at host 'PRODS'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance PROD2 - Archival Error. Archiver continuing.
Tue Nov 17 21:10:05 2015


增加日志:

+ standby 
Tue Nov 17 21:02:11 2015 
RFS[115]: Selected log 12 for thread 2 sequence 11378 dbid 244525669 branch 832687336 
Tue Nov 17 21:02:17 2015 
Archived Log entry 7021 added for thread 2 sequence 11377 ID 0xe935962 dest 1: 
Tue Nov 17 21:02:21 2015 
Media Recovery Log /u01/CCBPROD/oracle/oradata/archive/prod_11377_2_832687336.arc 
Tue Nov 17 21:04:11 2015 
RFS[115]: Selected log 11 for thread 2 sequence 11379 dbid 244525669 branch 832687336 

+ primary 
Tue Nov 17 21:02:11 2015 
Thread 2 advanced to log sequence 11378 (LGWR switch) 
Current log# 16 seq# 11378 mem# 0: +DATA_CIS/prod/onlinelog/group_16.343.862077675 
Current log# 16 seq# 11378 mem# 1: +RECO_CIS/prod/onlinelog/group_16.1464.862077677 
Tue Nov 17 21:02:11 2015 
LNS: Standby redo logfile selected for thread 2 sequence 11378 for destination LOG_ARCHIVE_DEST_2 
Tue Nov 17 21:02:16 2015 
Archived Log entry 48606 added for thread 2 sequence 11377 ID 0xe935962 dest 1: 
Tue Nov 17 21:04:08 2015 
Thread 2 advanced to log sequence 11379 (LGWR switch) 
Current log# 4 seq# 11379 mem# 0: +DATA_CIS/prod/onlinelog/group_4.278.841237531 
Current log# 4 seq# 11379 mem# 1: +RECO_CIS/prod/onlinelog/group_4.260.841237531 
Tue Nov 17 21:04:11 2015 
LNS: Standby redo logfile selected for thread 2 sequence 11379 for destination LOG_ARCHIVE_DEST_2 
Tue Nov 17 21:04:13 2015 
Archived Log entry 48608 added for thread 2 sequence 11378 ID 0xe935962 dest 1: 
Tue Nov 17 21:04:26 2015 
ARC3: Archive log rejected (thread 2 sequence 11378) at host 'PRODS' 
FAL[server, ARC3]: FAL archive failed, see trace file. 
ARCH: FAL archive failed. Archiver continuing 
ORACLE Instance PROD2 - Archival Error. Archiver continuing. 


问题原因:

This is false gap so can be ignored: 
primary switched from 11378 to 11379 in 2 mins, meanwhile standby has not finished archiving 11378 before it saw 11379, hence gap was detected and FAL sent to get 11378 from primary. however it was not needed. 

More information please see following note: 
ORA-16401 and ORA-16055 reported in primary alert.log when redolog switch is over frequently ( Doc ID 1243177.1 )


there is no real gap so error can be ignored. make sure log file switch doesn't happen that frequently so there will be no false gap detected. 


ignore the error as there is no real gap. Also increase the size of online redo log of primary database so it won't switch frequently. 


ignore the error as there is no real gap. Also increase the size of online redo log of primary database so it won't switch frequently. 

ignore the error as there is no real gap. Also increase the size of online redo log of primary database so it won't switch frequently. 

单击此项可添加到收藏夹 客户建议 转到底部转到底部

In this Document

Symptoms
  Changes
  Cause
  Solution
  References

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.1.0 [Release 10.2 to 11.2]
Linux x86-64
***Checked for relevance on 31-Aug-2012*** 
***Checked for relevance on 8-Jul-2015***

SYMPTOMS

- ORA-16401 and ORA-16055 Error reported sometimes at Primary ALERT.LOG:

ARC3: Archive log rejected (thread 1 sequence 136480) at host '(DESCRIPTION=  (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.26)(PORT=1530))(CONNECT_DATA=(SERVICE_NAME=sdbinfo)(SERVER=DEDICATED)))'
Errors in file /opt/dbinfo/diag/rdbms/dbinfo/dbinfo/trace/dbinfo_arc3_7445.trc:
ORA-16401: archivelog rejected by RFS
FAL[server, ARC3]: FAL archive failed, see trace file.
Errors in file /opt/dbinfo/diag/rdbms/dbinfo/dbinfo/trace/dbinfo_arc3_7445.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance dbinfo - Archival Error. Archiver continuing.



- RedoLog switch happens very frequently before the above Error reported
- The requested ArchiveLog by FAL requests the current Log Sequence or the Sequence currently being archived

CHANGES

There is no change made.

CAUSE

The Problem here is that the Primary Database is switching Logs too frequently.

Using ARCH to send the archives, every time there's a log switch the Primary has to send the Archivelog to the Standby, meanwhile another Log Switch occurred on the Primary which causes also another Archivelog to be sent to the Standby, but the first one has not finished yet, a GAP is formed and detected by the Standby. At this Time the first Archivelog is also sent as FAL Request, but this one will fail because the first one is still being archiving, locked, so the second one fails.

Also check for the case explained in below note,

Ora-16401: Archivelog Rejected By Rfs (Doc ID 1183143.1)

SOLUTION

  • Ignore these Messages as long as the Standby Database keeps synchronized with the Primary
  • Database Increase the Size of the Online Redologs to reduce Redolog Switch Frequency
  • Increase Network Bandwith between the Primary and Standby Database

REFERENCES

BUG:9848109 - ORA-16401: ARCHIVE LOG REJECTED BY REMOTE FILE SERVER


ignore the error as there is no real gap. Also increase the size of online redo log of primary database so it won't switch frequently. 
ignore the error as there is no real gap. Also increase the size of online redo log of primary database so it won't switch frequently. 
版权声明:本文为博主原创文章,未经博主允许不得转载。

网络带宽不足引起arc进程争用导致两个standby失败

一.背景概述 2014/08/17,按照客户的要求对异地dataguard进行实施工作。实施完成后拓扑结构及相关配置信息如下: 实施异地前同城standby可以正常应用日志且稳定运行时间超过...
  • Smasegain
  • Smasegain
  • 2015年07月21日 22:08
  • 2353

<< Oracle高可用>>部分书面作业 - 第八课 Data Gaurd 故障分析和处理

1.模拟由于网络,监听器的原因导致归档无法传到standby上的情形,分别从相应的主备数据库的视图和alert文件定位故障的原因;当故障排除后,看Oracle是否能自动恢复归档的传递,模拟:备库故意没...
  • t0nsha
  • t0nsha
  • 2013年10月13日 17:03
  • 2746

ORA-16401: archivelog rejected by RFS

主库alert日志 Sat Aug 11 06:19:59 2012 Errors in file /export/home/oracle/admin/SAMP/bdump/samp1_arc1_1...
  • deanza
  • deanza
  • 2012年08月11日 19:58
  • 1446

Logon database Tiger引起DataGuard不同步问题

当DataGuard升级CPU后,发现主备库不能同步了,日志报错,所以在主库的执行的升级的后脚本“@catbundle.sql cpu apply”不能同步到备库     现象: broker...
  • lichangzai
  • lichangzai
  • 2014年10月23日 15:46
  • 2516

FAL_CLIENT和FAL_SERVER

FAL_CLIENT和FAL_SERVER是配置dataguard用到的两个参数,FAL指获取归档日志(Fetch Archived Log) 在一定的条件下,或者因为网络失败,或者因为资源紧张...
  • csdnhadoop
  • csdnhadoop
  • 2017年03月23日 16:00
  • 518

FAL_CLIENT和FAL_SERVER参数详解

FAL_CLIENT和FAL_SERVER是配置dataguard用到的两个参数,FAL指获取归档日志(Fetch Archived Log) 在一定的条件下,或者因为网络失败,或者因为资源紧张,会...
  • jiaping0424
  • jiaping0424
  • 2016年06月16日 13:53
  • 977

关于RAC 的Data Guard中FAL_SERVER及FAL_CLIENT的设置

关于RAC 的Data Guard中FAL_SERVER及FAL_CLIENT的设置 http://space.itpub.net/index.php?action/viewspace/itemid...
  • orion61
  • orion61
  • 2011年09月05日 13:58
  • 867

11.2.0.3 ASM实例出现ORA-4031错误导致数据库归档失败

环境: 平台:RedHat EnterPrise 5.8 X86_X64 数据库:Oracle EnterPrise 11.2.0.3 集群软件:Oracle grid 11.2.0.3 ...
  • wuweilong
  • wuweilong
  • 2014年03月02日 13:14
  • 3688

dataguard 错误分析之RESOLVABLE GAP

s select STATUS, GAP_STATUS from V$ARCHIVE_DEST_STATUS where DEST_ID = 2;
  • pengpengfly_jhp
  • pengpengfly_jhp
  • 2014年07月29日 20:54
  • 5685

ORA-00270: error creating archive log

今天主库报了如下的错误 ****************************************************************** LGWR: Setting 'acti...
  • u012422541
  • u012422541
  • 2015年04月17日 13:17
  • 3054
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:FAL[server, ARC3]: FAL archive failed Error 16401 creating standby archive log file at host
举报原因:
原因补充:

(最多只允许输入30个字)