ALTER SYSTEM ARCHIVE LOG&Checkpoint not complete

xinxin415415

警告日志里面出现大量的ALTER SYSTEM ARCHIVE LOG，导致redo log没有写满都发生切换，在22点出现大量的Checkpoint not complete（22点有跑job）
另外有以下警告，这个4K的问题是不是只能重建才能解决？
WARNING: You are creating/reusing datafile /dev/rdb_redo323.
WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details.
Completed:
alter database add logfile group 1  ('/dev/rdb_redo313', '/dev/rdb_redo323') size 100M




Mon Jul 16 16:15:44 2012
Thread 1 advanced to log sequence 10409 (LGWR switch)
  Current log# 1 seq# 10409 mem# 0: /dev/rdb_redo313
  Current log# 1 seq# 10409 mem# 1: /dev/rdb_redo323
Mon Jul 16 16:18:39 2012
Thread 1 advanced to log sequence 10410 (LGWR switch)
  Current log# 5 seq# 10410 mem# 0: /dev/rdb_redo311
  Current log# 5 seq# 10410 mem# 1: /dev/rdb_redo321
Mon Jul 16 19:00:13 2012
Thread 1 advanced to log sequence 10411 (LGWR switch)
  Current log# 6 seq# 10411 mem# 0: /dev/rdb_redo312
  Current log# 6 seq# 10411 mem# 1: /dev/rdb_redo322
Mon Jul 16 20:06:59 2012
ALTER SYSTEM ARCHIVE LOG
Mon Jul 16 20:06:59 2012
Thread 1 advanced to log sequence 10412 (LGWR switch)
  Current log# 2 seq# 10412 mem# 0: /dev/rdb_redo314
  Current log# 2 seq# 10412 mem# 1: /dev/rdb_redo324
Mon Jul 16 21:59:44 2012
Thread 1 advanced to log sequence 10413 (LGWR switch)
  Current log# 1 seq# 10413 mem# 0: /dev/rdb_redo313
  Current log# 1 seq# 10413 mem# 1: /dev/rdb_redo323
Mon Jul 16 22:00:02 2012
Thread 1 advanced to log sequence 10414 (LGWR switch)
  Current log# 5 seq# 10414 mem# 0: /dev/rdb_redo311
  Current log# 5 seq# 10414 mem# 1: /dev/rdb_redo321
Mon Jul 16 22:00:20 2012
Thread 1 advanced to log sequence 10415 (LGWR switch)
  Current log# 6 seq# 10415 mem# 0: /dev/rdb_redo312
  Current log# 6 seq# 10415 mem# 1: /dev/rdb_redo322
Mon Jul 16 22:00:38 2012
Thread 1 cannot allocate new log, sequence 10416
Checkpoint not complete
  Current log# 6 seq# 10415 mem# 0: /dev/rdb_redo312
  Current log# 6 seq# 10415 mem# 1: /dev/rdb_redo322
Mon Jul 16 22:00:41 2012
Thread 1 advanced to log sequence 10416 (LGWR switch)
  Current log# 2 seq# 10416 mem# 0: /dev/rdb_redo314
  Current log# 2 seq# 10416 mem# 1: /dev/rdb_redo324
Mon Jul 16 22:03:41 2012
Thread 1 cannot allocate new log, sequence 10417
Checkpoint not complete
  Current log# 2 seq# 10416 mem# 0: /dev/rdb_redo314
  Current log# 2 seq# 10416 mem# 1: /dev/rdb_redo324
Mon Jul 16 22:03:44 2012
Thread 1 advanced to log sequence 10417 (LGWR switch)
  Current log# 1 seq# 10417 mem# 0: /dev/rdb_redo313
  Current log# 1 seq# 10417 mem# 1: /dev/rdb_redo323
Mon Jul 16 23:16:15 2012
Thread 1 advanced to log sequence 10418 (LGWR switch)
  Current log# 5 seq# 10418 mem# 0: /dev/rdb_redo311
  Current log# 5 seq# 10418 mem# 1: /dev/rdb_redo321
Tue Jul 17 04:28:39 2012
Thread 1 advanced to log sequence 10419 (LGWR switch)
  Current log# 6 seq# 10419 mem# 0: /dev/rdb_redo312
  Current log# 6 seq# 10419 mem# 1: /dev/rdb_redo322
Tue Jul 17 09:31:16 2012
Thread 1 advanced to log sequence 10420 (LGWR switch)
  Current log# 2 seq# 10420 mem# 0: /dev/rdb_redo314
  Current log# 2 seq# 10420 mem# 1: /dev/rdb_redo324
Tue Jul 17 10:57:07 2012
Thread 1 advanced to log sequence 10421 (LGWR switch)
  Current log# 1 seq# 10421 mem# 0: /dev/rdb_redo313
  Current log# 1 seq# 10421 mem# 1: /dev/rdb_redo323
Tue Jul 17 13:48:32 2012
Thread 1 advanced to log sequence 10422 (LGWR switch)
  Current log# 5 seq# 10422 mem# 0: /dev/rdb_redo311
  Current log# 5 seq# 10422 mem# 1: /dev/rdb_redo321
Tue Jul 17 14:57:05 2012
Thread 1 advanced to log sequence 10423 (LGWR switch)
  Current log# 6 seq# 10423 mem# 0: /dev/rdb_redo312
  Current log# 6 seq# 10423 mem# 1: /dev/rdb_redo322