关于oracle的警告日志
上一篇 /
下一篇 2005-09-09 21:57:00
我的数据库的警告日志一直提示检查点没完成,
不知是什么问题,能否提点儿建议,如下:
thread 1 advanced to log sequence 12633
current log# 3 seq# 12633 mem# 0: e:\oracle\oradata\syj\redo03_1.log
current log# 3 seq# 12633 mem# 1: e:\oracle\oradata\syj\redo03_2.log
thread 1 advanced to log sequence 12634
current log# 2 seq# 12634 mem# 0: e:\oracle\oradata\syj\redo02_1.log
current log# 2 seq# 12634 mem# 1: e:\oracle\oradata\syj\redo02_2.log
thread 1 cannot allocate new log, sequence 12635
checkpoint not complete
current log# 2 seq# 12634 mem# 0: e:\oracle\oradata\syj\redo02_1.log
current log# 2 seq# 12634 mem# 1: e:\oracle\oradata\syj\redo02_2.log
thread 1 advanced to log sequence 12635
current log# 1 seq# 12635 mem# 0: e:\oracle\oradata\syj\redo01_1.log
current log# 1 seq# 12635 mem# 1: e:\oracle\oradata\syj\redo01_2.log
thread 1 advanced to log sequence 12636
current log# 3 seq# 12636 mem# 0: e:\oracle\oradata\syj\redo03_1.log
current log# 3 seq# 12636 mem# 1: e:\oracle\oradata\syj\redo03_2.log
thread 1 cannot allocate new log, sequence 12637
checkpoint not complete
current log# 3 seq# 12636 mem# 0: e:\oracle\oradata\syj\redo03_1.log
current log# 3 seq# 12636 mem# 1: e:\oracle\oradata\syj\redo03_2.log
thread 1 advanced to log sequence 12637
current log# 2 seq# 12637 mem# 0: e:\oracle\oradata\syj\redo02_1.log
current log# 2 seq# 12637 mem# 1: e:\oracle\oradata\syj\redo02_2.log
thread 1 advanced to log sequence 12638
current log# 1 seq# 12638 mem# 0: e:\oracle\oradata\syj\redo01_1.log
current log# 1 seq# 12638 mem# 1: e:\oracle\oradata\syj\redo01_2.log
thread 1 cannot allocate new log, sequence 12639
checkpoint not complete
current log# 1 seq# 12638 mem# 0: e:\oracle\oradata\syj\redo01_1.log
current log# 1 seq# 12638 mem# 1: e:\oracle\oradata\syj\redo01_2.log
回答:
加几个新的redolog file就好,
检查你的初始化文件是否有以下配置
log_checkpoint_interval = 0
log_checkpoint_timeout = 0
log_checkpoints_to_alert=true
导入论坛
引用链接
收藏
分享给好友
管理
举报
TAG: