FAL[server, ARCN]: FAL archive failed ORA-16401

本文涉及的产品
日志服务 SLS,月写入数据量 50GB 1个月
简介: 今天数据库日志报警,然后查看日志报错如下: Sat Jun 07 17:35:19 2014 Archived Log entry 3272 added for thread 1 sequence 3224 ID 0xaad09f63 dest 1: Sa...
今天数据库日志报警,然后查看日志报错如下:
Sat Jun 07 17:35:19 2014
Archived Log entry 3272 added for thread 1 sequence 3224 ID 0xaad09f63 dest 1:
Sat Jun 07 17:35:36 2014
LNS: Standby redo logfile selected for thread 1 sequence 3225 for destination LOG_ARCHIVE_DEST_2
Sat Jun 07 17:35:39 2014
ARC0: Archive log rejected (thread 1 sequence 3224) at host 'yjfcores'
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance yjfcore - Archival Error. Archiver continuing.


trace记录
*** 2014-06-06 11:48:12.502 4645 krsu.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 16401 creating standby archive log file at host 'yjfcores'


*** 2014-06-07 15:56:21.520
kcrrwkx: unknown error:16401
Error 16401 creating standby archive log file at host 'yjfcores'


*** 2014-06-07 17:35:39.802
kcrrwkx: unknown error:16401

查看METLAINK,解释如下:

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.

他的说法和明确就是由于日志切换非常频繁(或者网络带宽不够),ARCH或者LSN正在进行日志传输,但是这个时候进行了日志切换从而导致可能的GAP检测到了,启动了另外的一个归档进程传输GAP归档到STANDBY端,
但是这个时候实际上这个日志或者归档正在传输锁定了文件,所以第二个进程自然要报错。解决方法

  • 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

谢谢!
相关实践学习
日志服务之使用Nginx模式采集日志
本文介绍如何通过日志服务控制台创建Nginx模式的Logtail配置快速采集Nginx日志并进行多维度分析。
目录
打赏
0
0
0
0
91
分享
相关文章
ORA-00257: archiver error. Connect internal only, until freed.
今天一上班,登陆测试库,出现 ORA-00257: archiver error. Connect internal only, until freed. 看alert.
1103 0
ORA-00257: archiver error. Connect internal only, until freed引发的血案
我一向都是已解决方法为目的来解决问题,导致有些概念模糊不清晰。 先写下解决方法。 SQL> select * from V$FLASH_RECOVERY_AREA_USAGE; FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_R...
1026 0
【ORACLE】ORA-00245: control file backup operation failed
从oracle 11.2.0.2.0开始,控制文件的快照文件必须能够被所有节点的数据实例访问到,并且必须放在共享的位置。否则,使用RMAN进行备份控制文件的时候会报如下错误: ORA-00245: control file backup operation failed。
874 0
【oracle】ORA-01580 error creating control backup file
早上查看报警邮件的时候发现了ORA-01580 error creating control backup file。 通常次错误与RMAN 备份控制文件的策略有关: 比如: RMAN> backup current controlfile; Starting ...
1098 0
【RAC】ORA-29780: unable to connect to GPnP daemon [CLSGPNP_ERR]
安装完成 11GR2 Grid 之后,使用asmca创建磁盘组的时候遇到如下报错: ORA-29780: unable to connect to GPnP daemon [CLSGPNP_ERR] google 一把 和环境变量有关:(CRS/GRID 是运行正常的).
843 0
ORA-01103: database name 'test' in control file is not 'standby'
主备primary,standby库的instance name不一致引起的 把备库的db_name要和主库一致,但*.
1226 0
ORA-00257: archiver error. Connect internal only, until freed 错误解决
出现ORA-00257错误(空间不足错误),通过查找资料,绝大部分说这是由于归档日志太多,占用了全部的硬盘剩余空间导致的,通过简单删除日志或加大存储空间就能够解决。 SecureCRT登录服务器,切换用户oracle,连接oracle [root@userbeta~]# su - orac...
1992 0