類似ARC0: Failed to archive log# 3 seq# 230556的錯誤
From : [@more@]
日誌中發現類似ARC0: Failed to archive log# 3 seq# 230556 的錯誤;正好也在asktom上看到解釋。 出現如上報警的原因是例項使用了多於1個的歸檔程式ARCH. 日誌中發現類似ARC0: Failed to archive log# 3 seq# 230556 的錯誤;正好也在asktom上看到解釋。 出現如上報警的原因是例項使用了多於1個的歸檔程式ARCH.假如設定多個歸檔程式,每個歸檔程式都會嘗試對日誌檔案進行歸檔,但由於不能獲得歸檔所需要的'kcrrlt'鎖而失敗;'kcrrlt'鎖是用來保護多個歸檔程式歸檔同一日誌檔案。失敗的歸檔程式將報警訊息寫到日誌檔案。 日誌檔案被其他歸檔程式成功歸檔後,也會寫訊息到日誌檔案。 因此該警告可以忽略。8i中訊息如下ARC0: Beginning to archive log# 1 seq# 230555 ARC0: Failed to archive log# 1 seq# 230555 9i會更具體 ARC1: Beginning to archive log# 2 thrd# 1 seq# 24 ARC1: Unable to archive log# 2 thrd# 1 seq# 24 Log actively being archived by another process同時初始化引數log_archive_trace 可以跟蹤歸檔程式執行的情況,如下是設定log_archive_trace=17看到的歸檔寫歸檔檔案的過程,每次64個OS資料塊*** SESSION ID:(33.787) 2005-06-02 05:32:22.340*** 2005-06-02 05:32:22.340ARC4: Begin archiving log# 3 seq# 980 thrd# 1ARC4: Archiving block 1 count 64 to : '/data/oracle/sptrprd1/archive/sptrprd1_0001_0000000980.arc'ARC4: Archiving block 65 count 64 to : '/data/oracle/sptrprd1/archive/sptrprd1_0001_0000000980.arc'……………………………………………ARC4: Archiving block 886465 count 64 to : '/data/oracle/sptrprd1/archive/sptrprd1_0001_0000000980.arc'ARC4: Archiving block 886529 count 64 to : '/data/oracle/sptrprd1/archive/sptrprd1_0001_0000000980.arc'ARC4: Archiving block 886593 count 44 to : '/data/oracle/sptrprd1/archive/sptrprd1_0001_0000000980.arc'ARC4: ArchivedLog entry added: /data/oracle/sptrprd1/archive/sptrprd1_0001_0000000980.arc*** 2005-06-02 05:32:39.517ARC4: Completed archiving log# 3 seq# 980 thrd# 1 報警日誌如下 ARC0: Beginning to archive log# 1 seq# 230555 ARC0: Failed to archive log# 1 seq# 230555 ARC0: Beginning to archive log# 3 seq# 230556 ARC0: Failed to archive log# 3 seq# 230556 ARC0: Beginning to archive log# 6 seq# 230557 Thu Jun 2 05:11:55 2005 Completed checkpoint up to RBA [0x3849e.2.10], SCN: 0x0719.affd88f4 Thu Jun 2 05:12:00 2005 ARC1: Completed archiving log# 1 seq# 230555 ARC1: Beginning to archive log# 3 seq# 230556 ARC1: Failed to archive log# 3 seq# 230556 ARC1: Beginning to archive log# 6 seq# 230557 ARC1: Failed to archive log# 6 seq# 230557 Thu Jun 2 05:12:13 2005 ARC4: Beginning to archive log# 3 seq# 230556 ARC4: Failed to archive log# 3 seq# 230556 ARC4: Beginning to archive log# 6 seq# 230557 ARC4: Failed to archive log# 6 seq# 230557 Thu Jun 2 05:12:34 2005
ARC2: Completed archiving log# 3 seq# 230556 ARC2: Beginning to archive log# 6 seq# 230557 ARC2: Failed to archive log# 6 seq# 230557 Thu Jun 2 05:12:40 2005 Beginning log switch checkpoint up to RBA [0x3849f.2.10], SCN: 0x0719.affdad06 Thread 1 advanced to log sequence 230559 Current log# 4 seq# 230559 mem# 0: /data/oracle/EUSLNP01/redo1/EUSLNP01_REDO_1_4.dbf Current log# 4 seq# 230559 mem# 1: /data/oracle/EUSLNP01/redo3/EUSLNP01_REDO_3_4.dbf Thu Jun 2 05:12:40 2005 ARC3: Beginning to archive log# 6 seq# 230557 ARC3: Failed to archive log# 6 seq# 230557 ARC3: Beginning to archive log# 5 seq# 230558 Thu Jun 2 05:12:50 2005 ARC2: Beginning to archive log# 6 seq# 230557 ARC2: Failed to archive log# 6 seq# 230557 ARC2: Beginning to archive log# 5 seq# 230558 ARC2: Failed to archive log# 5 seq# 230558 Thu Jun 2 05:13:01 2005 ARC0: Completed archiving log# 6 seq# 230557 Thu Jun 2 05:13:01 2005 ARC4: Beginning to archive log# 5 seq# 230558 ARC4: Failed to archive log# 5 seq# 230558 Thu Jun 2 05:13:26 2005 Completed checkpoint up to RBA [0x3849f.2.10], SCN: 0x0719.affdad06
ARC2: Completed archiving log# 3 seq# 230556 ARC2: Beginning to archive log# 6 seq# 230557 ARC2: Failed to archive log# 6 seq# 230557 Thu Jun 2 05:12:40 2005 Beginning log switch checkpoint up to RBA [0x3849f.2.10], SCN: 0x0719.affdad06 Thread 1 advanced to log sequence 230559 Current log# 4 seq# 230559 mem# 0: /data/oracle/EUSLNP01/redo1/EUSLNP01_REDO_1_4.dbf Current log# 4 seq# 230559 mem# 1: /data/oracle/EUSLNP01/redo3/EUSLNP01_REDO_3_4.dbf Thu Jun 2 05:12:40 2005 ARC3: Beginning to archive log# 6 seq# 230557 ARC3: Failed to archive log# 6 seq# 230557 ARC3: Beginning to archive log# 5 seq# 230558 Thu Jun 2 05:12:50 2005 ARC2: Beginning to archive log# 6 seq# 230557 ARC2: Failed to archive log# 6 seq# 230557 ARC2: Beginning to archive log# 5 seq# 230558 ARC2: Failed to archive log# 5 seq# 230558 Thu Jun 2 05:13:01 2005 ARC0: Completed archiving log# 6 seq# 230557 Thu Jun 2 05:13:01 2005 ARC4: Beginning to archive log# 5 seq# 230558 ARC4: Failed to archive log# 5 seq# 230558 Thu Jun 2 05:13:26 2005 Completed checkpoint up to RBA [0x3849f.2.10], SCN: 0x0719.affdad06
資料引用:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/66634/viewspace-1016608/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Data guard 中 alert 日誌報錯 "FAL archive failed"HiveAI
- 【Redis】錯誤:failed: Hostname must not be empty or nullRedisAINull
- Github錯誤之failed to push some refs toGithubAI
- VMware vmdk錯誤: Failed to lock the file.AI
- Installation failed with message INSTALL_FAILED_USER_RESTRICTED錯誤AIREST
- 遷移過程中出現的open failed錯誤AI
- Failed to run the WC DB work queue associated with 錯誤的解決AI
- 安裝CLUSTER碰到 Assertion failed offset fFileSize錯誤AI
- centos 重啟掛載錯誤 failed to mount /backupCentOSAI
- ARC0: Becoming the 'no FAL' ARCH ARC0: Thread not mountedthread
- IDEA啟動時報Failed to create JVM錯誤的解決IdeaAIJVM
- 新增第三方類庫造成的linker command failed with exit code 1 (use -v to see invocation)的錯誤除錯AI除錯
- Spring Boot配置錯誤:Failed to determine a suitable driver classSpring BootAIUI
- INSTALL_FAILED_NO_MATCHING_ABIS錯誤解決AI
- oracle ASM錯誤Initializing the Oracle ASMLib driver:[FAILED]OracleASMAI
- 記一次OPatch failed with error code 73錯誤AIError
- JS實現 類似圖片3D效果JS3D
- 12.2.0.1bug導致的Failed to register in OCRLOCAL group.錯誤AI
- XAMRAIN的INSTALL_FAILED_NO_MATCHING_ABIS錯誤處理AI
- Meta開源其類似GPT-3的語言模型 - RedditGPT模型
- Brew 升級更新錯誤"Failed to install vendor Ruby."AI
- [sublime xftp外掛] Host key verification failed ,錯誤處理FTPAI
- myeclipse中提示Hot Code Replace Failed提示窗錯誤EclipseAI
- PostgreSQL提示:‘psql: FATAL: ”Peer authentication failed for user ”postgres“’錯誤SQLAI
- 解決錯誤:ASP.NET Error: Failed to access IIS metabaseASP.NETErrorAI
- Genymotion錯誤之INSTALL_FAILED_CPU_ABI_INCOMPATIAI
- wp7 toolkit編譯錯誤 Xap packaging failed編譯AI
- Resolving archive.cloudera.com... failed: Temporary failure in nameHiveCloudAI
- FAL[server, ARCN]: FAL archive failed ORA-16401ServerHiveAI
- 錯誤 330 (net::ERR_CONTENT_DECODING_FAILED):未知錯誤解決辦法AI
- 類似gitbook的wiki選擇Git
- mysql類似merge的操作MySql
- FreeBSD系統下zfs: failed with error 6錯誤的解決方法AIError
- 真機除錯出現 application installation failed 錯誤 解決方案除錯APPAI
- PostgreSQL cache lookup failed for type XXXX 錯誤SQLAI
- Resolving failed: Temporary failure in name resolution 錯誤解決方法AI
- 告警日誌出現skgpspawn failed category 27142錯誤AIGo
- [渲染層網路層錯誤] Failed to load local font resource ?AI