rac的重做日志非常频繁，也增加了日志组，扩大了redo size，还是没有解决

显示全部楼层 · 2010-3-1 11:07:22

select * from v$log order by thread#;

GROUP#
THREAD#
SEQUENCE#
BYTES
MEMBERS
ARCHIVED
STATUS
FIRST_CHANGE#
FIRST_TIME
1
1
1
27272
104857600
2
NO
CURRENT
961617518
2010-11-16 9:59
2
6
1
27269
524288000
1
YES
ACTIVE
961617046
2010-11-16 9:58
3
9
1
27271
524288000
1
YES
ACTIVE
961617431
2010-11-16 9:59
4
5
1
27270
524288000
1
YES
ACTIVE
961617195
2010-11-16 9:58
5
10
2
9107
524288000
1
YES
ACTIVE
961616865
2010-11-16 9:58
6
7
2
9106
524288000
1
YES
ACTIVE
961615835
2010-11-16 9:56
7
8
2
9108
524288000
1
YES
ACTIVE
961617097
2010-11-16 9:58
8
4
2
9105
104857600
2
YES
ACTIVE
961615175
2010-11-16 9:55
9
3
2
9109
104857600
2
NO
CURRENT
961617549
2010-11-16 9:59

alert.log
Checkpoint not complete
Current log# 1 seq# 27276 mem# 0: +DATA/ora10g/onlinelog/group_1.273.727886725
Current log# 1 seq# 27276 mem# 1: +DATA/ora10g/onlinelog/group_1.274.727886725
Tue Nov 16 10:01:11 2010
Thread 1 advanced to log sequence 27277 (LGWR switch)
Current log# 6 seq# 27277 mem# 0: +DATA/ora10g/onlinelog/group_6.317.735211509
Tue Nov 16 10:02:00 2010
Thread 1 cannot allocate new log, sequence 27278
Checkpoint not complete
Current log# 6 seq# 27277 mem# 0: +DATA/ora10g/onlinelog/group_6.317.735211509
Tue Nov 16 10:02:03 2010
Thread 1 advanced to log sequence 27278 (LGWR switch)
Current log# 5 seq# 27278 mem# 0: +DATA/ora10g/onlinelog/group_5.316.735211417
Thread 1 cannot allocate new log, sequence 27279
Checkpoint not complete
Current log# 5 seq# 27278 mem# 0: +DATA/ora10g/onlinelog/group_5.316.735211417
Tue Nov 16 10:02:12 2010
Thread 1 advanced to log sequence 27279 (LGWR switch)
Current log# 9 seq# 27279 mem# 0: +DATA/ora10g/onlinelog/group_9.276.735213123

千问 · 2010-3-1 11:07:22

日志的状态都没有INACTIVE

千问 · 2010-3-1 11:07:22

redo size和归档日志的大小相差多少？

千问 · 2010-3-1 11:07:22

是不是bug

千问 · 2010-3-1 11:07:22

redo size 新增了几组是500M，归档文件大小
44K ./1_23901_733922072.dbf
188K./1_23984_733922072.dbf
4.0K./1_22691_733922072.dbf
56K ./1_23591_733922072.dbf
60K ./1_25597_733922072.dbf
112K./1_27017_733922072.dbf
24K ./1_24877_733922072.dbf
80K ./1_22807_733922072.dbf
8.0K./1_22725_733922072.dbf
196K./1_22903_733922072.dbf
8.0K./1_22645_733922072.dbf
20K ./1_24429_733922072.dbf
60K ./1_22512_733922072.dbf
140K./1_25706_733922072.dbf
44K ./1_26865_733922072.dbf
56K ./1_23787_733922072.dbf
12K ./1_26358_733922072.dbf

千问 · 2010-3-1 11:07:22

如果是BUG，请问如何解决啊，数据库的版本是:10.2.0.4

千问 · 2010-3-1 11:07:22

你用logMiner分析下日志？

千问 · 2010-3-1 11:07:22

已经将这个参数设为：archive_lag_target＝1800

千问 · 2010-3-1 11:07:22

数据库应该没有那么频繁的

千问 · 2010-3-1 11:07:22

是不是应用程序里面有啥问题？