類似ARC0: Failed to archive log# 3 seq# 230556的錯誤

ysjxjf發表於2009-02-03
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
資料引用:

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/66634/viewspace-1016608/,如需轉載,請註明出處,否則將追究法律責任。

相關文章