类似ARC0:Failedtoarchivelog#3seq#230556的错误

王朝other·作者佚名  2008-05-19
宽屏版  字体: |||超大  

日志中发现类似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 可以跟踪归档进程运行的情况,http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams108.htm如下是设置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

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
© 2005- 王朝网络 版权所有