Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

52

积分

0

好友

6

主题
1#
发表于 2012-7-17 16:39:04 | 查看: 4020| 回复: 0
警告日志里面出现大量的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
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 03:45 , Processed in 0.047791 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569