转 FAL[server, ARC3]: FAL archive failed Error 16401 creating standby archive log file at host
感谢 EVISWANG
https://blog.csdn.net/EVISWANG/article/details/49924883
主库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
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.
CHANGESThere is no change made. CAUSEThe Problem here is that the Primary Database is switching Logs too frequently. Also check for the case explained in below note, Ora-16401: Archivelog Rejected By Rfs (Doc ID 1183143.1) SOLUTION
REFERENCESBUG: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.
|
相关文章
- SQL Server-聚焦强制索引查询条件和Columnstore Index(九)
- Sql server在另一台服务器,在Visual Studio 中没问题,IIS中 提示“在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。。。。”
- k8s集群中部署prometheus server
- Trouble Connecting to sql server Login failed. "The login is from an untrusted domain and cannot be used with Windows authentication"
- sql server drop login failed
- C#构造方法(函数) C#方法重载 C#字段和属性 MUI实现上拉加载和下拉刷新 SVN常用功能介绍(二) SVN常用功能介绍(一) ASP.NET常用内置对象之——Server sql server——子查询 C#接口 字符串的本质 AJAX原生JavaScript写法
- 在做httpModules测试的时候出现“HTTP Error 500.22 - Internal Server Error 检测到在集成的托管管道模式下不适用的 ASP.NET 设置。”
- SQL Server 中 EXEC全称execute 与 SP_EXECUTESQL动态执行sql代码语句 的区别
- Sql Server中将一个表的记录追加到另一个表中(一句经典示例)
- SQL SERVER错误:已超过了锁请求超时时段。 (Microsoft SQL Server,错误: 1222) 解决方案
- how to ignore server cert error in javamail
- 启动简单的springboot项目报错:To display the conditions report re-run your..Web server failed to start
- 误删Server后Tomcat服务器报错The Tomcat server configuration at ServersTomcat v8.5 Server at
- mac os 上启用简单http file server web 文件服务器
- org.apache.kafka.common.KafkaException: Socket server failed to bind to 114.115.20.100:9092: Cannot
- 执行buildman --fetch-arch arm提示"urllib2.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)>"如何处理?
- Eureka Server的多级缓存和过期机制
- Android ADB server didn't ACK * failed to start daemon * 简单有效的解决方案
- BluetoothLE-Multi-Library 一个能够连接多台蓝牙设备的库,它可以作为client端,也可以为server端。支持主机/从机,外围设备连接。
- sql server 小技巧(3) SQL Server 2012 数据库完整导出到SQL Azure (包括数据)
- sql server truncate table 删除表数据限制条件
- (4.52)解决sql server动态SQL中对表字段操作时需要频繁 ISNULL的问题
- sql server作业报错:从ICassFactory为CLSID为{17BCA6E8-A950-497E-B2F9-AF6AA475916F}的COM组件创建实例失败,原因是出现以下错误:c001f011.(Microsoft.Server.manageDTS)
- SQL SERVER BCP,SQL SERVER BULK INSERT
- (2.17)备份与还原--sql server事务日志不能截断的原因与收缩日志文件
- ComposerDownloaderTransportException ... Failed to enable crypto,failed to open stream: operation failed
- the server responded with a status of 415 ()
- frp错误处理:login to server failed: authorization failed
- 在Windows Server 2012 中安装 .NET 3.5 Framework