FAL[server, ARCN]: FAL archive failed ORA-16401
今天資料庫日誌報警,然後檢視日誌報錯如下:
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端,但是這個時候實際上這個日誌或者歸檔正在傳輸鎖定了檔案,所以第二個程式自然要報錯。解決方法
謝謝!
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
謝謝!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7728585/viewspace-1177812/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Data guard 中 alert 日誌報錯 "FAL archive failed"HiveAI
- FAL_CLIENT和FAL_SERVER引數詳解clientServer
- 關於RAC 的Data Guard中FAL_SERVER及FAL_CLIENT的設定Serverclient
- 主備互相切換用到的引數VALID_FOR、fal_client、fal_serverclientServer
- 9i Standby新引數:fal_server與fal_client,standby_file_management [final]Serverclient
- ORA-00270: error creating archive log ORA-16055: FAL request rejectedErrorHive
- FAL_SERVER設定錯誤導致SWITCHOVER切換HANG住Server
- 11gR2 DG不再需要FAL_CLIENTclient
- ARC0: Becoming the 'no FAL' ARCH ARC0: Thread not mountedthread
- 物理DG的FAL_CLIENT設定錯誤引起的主庫報錯client
- 【OCP最新題庫解析(052)--題10】 Which two are true about the Archive (ARCnHive
- LGWR和ARCH下密碼檔案不一致對FAL的影響密碼
- Oracle DataGuard FAL[client, ARC2]: Error 16191 connecting to 問題處理過程記錄OracleclientError
- 11g ADG 出現FAL[client,USER]:error 12154 connect to orcl for fetching gapclientError
- Resolving archive.cloudera.com... failed: Temporary failure in nameHiveCloudAI
- MySQL server5.7版出現server failedMySqlServerAI
- Server Tomcat v7.0 Server at localhost failed to startServerTomcatlocalhostAI
- Server Tomcat v9.0 Server at localhost failed to start.ServerTomcatlocalhostAI
- Standby Server中的log_archive_start=false還是true ?ServerHiveFalse
- informix onbar 備份失敗Archive API processing failed at line 258 for rc.ORMHiveAPIAI
- Xtrabackup備份報錯Failed to connect to MySQL serverAIMySqlServer
- CRS-2765: Resource 'ora.crsd' has failed on serverAIServer
- 類似ARC0: Failed to archive log# 3 seq# 230556的錯誤AIHive
- ORA-16401: archivelog rejected by RFS ---解決方法Hive
- ORACLE 9i歸檔之ARCn: Media recovery disabledOracle
- 【故障處理】ORA-28547: connection to server failed, probableServerAI
- solrcloud 報 HTTP Status 503 - Server is shutting down or failed to initializeSolrCloudHTTPServerAI
- 關於解決Server Tomcat v9.0 Server at localhost failed to start的問題ServerTomcatlocalhostAI
- oracle 的伺服器程式(PMON, SMON,CKPT,DBWn,LGWR,ARCn)Oracle伺服器
- ORA-12500: TNS:listener failed to start a dedicated server processAIServer
- ORA-12500 TNS : listener failed to start a dedicated server processAIServer
- Springboot jar 部署IllegalStateException: Failed to get nested archive for entry BOOT-INF/lib/byte-budSpring BootJARExceptionAIHive
- Thread: ADMU3011E: Server launched but failed initialization. Server logfiles shthreadServerAI
- Swift iOS : ArchiveSwiftiOSHive
- 更改Archive ModeHive
- "vSphere HA virtual machine failed to failover" error in vCenter Server問題分析MacAIErrorServer
- standby_archive_dest和log_archive_dest_n區別Hive
- log_archive_dest與log_archive_dest_n區別Hive