设为首页收藏本站
开启辅助访问 切换到窄版
搜索
第一问答网»论坛 › 中问网 › 问答 › 请大家帮我看看在alert文件中出现的arc失败是怎么回事？ ...

请大家帮我看看在alert文件中出现的arc失败是怎么回事？

[复制链接]
查看11 | 回复7 | 2005-10-30 17:05:33 | 显示全部楼层 |阅读模式
检查alert文件，用grep Failed *.log命令找出了以下内容：
ARC1: Failed to archive log# 5 seq# 48904
ARC0: Failed to archive log# 2 seq# 48917
ARC1: Failed to archive log# 3 seq# 48930
ARC0: Failed to archive log# 4 seq# 48938
ARC1: Failed to archive log# 5 seq# 48939
ARC0: Failed to archive log# 3 seq# 48940
ARC1: Failed to archive log# 4 seq# 48943
ARC0: Failed to archive log# 5 seq# 48944
ARC1: Failed to archive log# 3 seq# 48945
ARC0: Failed to archive log# 5 seq# 48949
ARC1: Failed to archive log# 3 seq# 48950
ARC0: Failed to archive log# 1 seq# 48951
ARC1: Failed to archive log# 2 seq# 48952
ARC0: Failed to archive log# 4 seq# 48953
ARC1: Failed to archive log# 5 seq# 48954
ARC0: Failed to archive log# 3 seq# 48955
ARC1: Failed to archive log# 1 seq# 48956
ARC0: Failed to archive log# 4 seq# 48958
ARC1: Failed to archive log# 3 seq# 48960
ARC0: Failed to archive log# 4 seq# 48973
ARC1: Failed to archive log# 1 seq# 48986
ARC0: Failed to archive log# 3 seq# 48995
ARC1: Failed to archive log# 1 seq# 48996
ARCH: Failed to archive log# 2 seq# 48997
ARC0: Failed to archive log# 4 seq# 48998
ARC1: Failed to archive log# 3 seq# 49000
ARC0: Failed to archive log# 1 seq# 49001
ARC1: Failed to archive log# 1 seq# 49011
ARC0: Failed to archive log# 4 seq# 49018
ARC1: Failed to archive log# 5 seq# 49019
ARC0: Failed to archive log# 3 seq# 49020
ARC1: Failed to archive log# 1 seq# 49021
ARC0: Failed to archive log# 2 seq# 49022
ARC1: Failed to archive log# 4 seq# 49023
ARC0: Failed to archive log# 4 seq# 49033
ARC1: Failed to archive log# 5 seq# 49034
ARC0: Failed to archive log# 3 seq# 49035
ARC1: Failed to archive log# 1 seq# 49036
ARC0: Failed to archive log# 2 seq# 49037
ARC1: Failed to archive log# 4 seq# 49038
ARC0: Failed to archive log# 5 seq# 49039
ARC1: Failed to archive log# 3 seq# 49040
ARCH: Failed to archive log# 1 seq# 49051
ARC0: Failed to archive log# 1 seq# 49076
ARC1: Failed to archive log# 2 seq# 49092
ARC0: Failed to archive log# 3 seq# 49130
ARC1: Failed to archive log# 4 seq# 49153
ARC0: Failed to archive log# 3 seq# 49190

我的max arc进程是2：
alter system set log_archive_max_processes=2
不知道跟这个有没有关系？
谢谢
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
跟这个没有关系，当然你可以设大点，你的日志大小可能太小了，你的业务很繁忙吗？
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
看看alert中相关的内容，不要只显示failed。
可以看到你日志多久切换，是不是因为checkpoint无法完成等。
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
需要上下文信息.
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
出现那么多错误信息，是不是你的归档盘空间不足导致的啊？
建议先检查一下。
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
需要上下文，看来没什么问题，只是同一个log，两个arc process都去归档，其中一个必然failed。你的库都不down，肯定没问题。
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
不好意思，我没说清楚，列出的这些FAILED是库运行以来所有的记录，忘记把上下文贴出来了。
估计没什么大问题，因为都是报complete。
ARCH: Beginning to archive log# 5 seq# 48904
Fri Sep 10 20:30:53 2004
Current log# 3 seq# 48905 mem# 0: /data/oracle/oradata/yesno/redo05.log
Current log# 3 seq# 48905 mem# 1: /data/oracle/oradata/yesno/redo06.log
Fri Sep 10 20:30:53 2004
ARC1: Beginning to archive log# 5 seq# 48904
ARC1: Failed to archive log# 5 seq# 48904
Fri Sep 10 20:30:58 2004
ARCH: Completed archiving log# 5 seq# 48904
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
没什么问题，ARC1去归档 #48904时，ARCH0正在归档所以失败。
ARCH: Completed archiving log# 5 seq# 48904这个就是成功了
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

千问

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
回复楼主 返回列表
热门排行