归档日志异常增长

alicejapan

数据库版本是10.2.0.4 -64位
操作系统是REDHAT 5.5- 64位
RAC 结构

由于历史原因两个节点的日志大小不一致 node1 700m node2 450m
昨天凌晨0：00分左右到1:45左右日志突然异常切换 node1 node2上平均30s不到切换一次，但是node1 与node1的归档日志量不一样，node1的归档不到1M node2的归档量有200M。没有和切归档相关job和crontab，archive_lag_target为0.

请问各位有什么线索吗？

截取一段日志

  Current log# 14 seq# 2024 mem# 0: +DATA/paydb/onlinelog/group_14
Mon Jul 16 01:38:47 2012
LNS: Standby redo logfile selected for thread 2 sequence 2024 for destination LOG_ARCHIVE_DEST_3
Mon Jul 16 01:39:13 2012
Thread 2 cannot allocate new log, sequence 2025
Checkpoint not complete
  Current log# 14 seq# 2024 mem# 0: +DATA/paydb/onlinelog/group_14
Mon Jul 16 01:39:16 2012
Thread 2 advanced to log sequence 2025 (LGWR switch)
  Current log# 3 seq# 2025 mem# 0: +DATA/paydb_st/onlinelog/group_3.339.782441885
Mon Jul 16 01:39:16 2012
LNS: Standby redo logfile selected for thread 2 sequence 2025 for destination LOG_ARCHIVE_DEST_3
Mon Jul 16 01:39:42 2012
Thread 2 cannot allocate new log, sequence 2026
Checkpoint not complete
  Current log# 3 seq# 2025 mem# 0: +DATA/paydb_st/onlinelog/group_3.339.782441885
Mon Jul 16 01:39:46 2012
Thread 2 advanced to log sequence 2026 (LGWR switch)
  Current log# 6 seq# 2026 mem# 0: +DATA/paydb_st/onlinelog/group_6.456.782613529
Mon Jul 16 01:39:46 2012
LNS: Standby redo logfile selected for thread 2 sequence 2026 for destination LOG_ARCHIVE_DEST_3
Mon Jul 16 01:40:05 2012
Thread 2 cannot allocate new log, sequence 2027
Checkpoint not complete
  Current log# 6 seq# 2026 mem# 0: +DATA/paydb_st/onlinelog/group_6.456.782613529
Mon Jul 16 01:40:08 2012
Thread 2 advanced to log sequence 2027 (LGWR switch)
  Current log# 13 seq# 2027 mem# 0: +DATA/paydb/onlinelog/group_13
Mon Jul 16 01:40:08 2012
LNS: Standby redo logfile selected for thread 2 sequence 2027 for destination LOG_ARCHIVE_DEST_3
Mon Jul 16 01:40:35 2012
Thread 2 cannot allocate new log, sequence 2028
Checkpoint not complete
  Current log# 13 seq# 2027 mem# 0: +DATA/paydb/onlinelog/group_13
Mon Jul 16 01:40:38 2012
Thread 2 advanced to log sequence 2028 (LGWR switch)
  Current log# 14 seq# 2028 mem# 0: +DATA/paydb/onlinelog/group_14
Mon Jul 16 01:40:38 2012
LNS: Standby redo logfile selected for thread 2 sequence 2028 for destination LOG_ARCHIVE_DEST_3
Mon Jul 16 01:41:01 2012
Thread 2 cannot allocate new log, sequence 2029

[ 本帖最后由 alicejapan 于 2012-7-17 14:29 编辑 ]

Maclean Liu(刘相兵

提问之前 请先搜索一下

1.rac不到redo大小就切换是什么原因？


http://t.askmaclean.com/thread-139-1-1.html


2. redolog重做日志一分钟切换三次

http://t.askmaclean.com/viewthre ... ra=page%3D2#pid6772