alert中的日志，请教为什么

显示全部楼层 · 2005-10-30 17:05:33

Mon Sep 06 12:42:34 2004
Thread 1 advanced to log sequence 20241
Current log# 3 seq# 20241 mem# 0: D:\ORANT\DATABASE\LOGDOOR3.ORA
Current log# 3 seq# 20241 mem# 1: E:\VSCDBF\LOGDOOR3A.ORA
Thread 1 cannot allocate new log, sequence 20242
Checkpoint not complete
Current log# 3 seq# 20241 mem# 0: D:\ORANT\DATABASE\LOGDOOR3.ORA
Current log# 3 seq# 20241 mem# 1: E:\VSCDBF\LOGDOOR3A.ORA

千问 · 2005-10-30 17:05:33

加大日志文件的大小，或者多增加几个日志组试试。

千问 · 2005-10-30 17:05:33

谢谢答复
这里的环境是unarchived log
当时是有大量的插入动作
LOG是1、2、3、4个group，5M一个，是因为来不及checkpoint而导致覆盖log3了吗？
接上面的log
Thread 1 advanced to log sequence 20242
Current log# 4 seq# 20242 mem# 0: D:\ORANT\DATABASE\LOGDOOR4.ORA
Current log# 4 seq# 20242 mem# 1: E:\VSCDBF\LOGDOOR4A.ORA
Mon Sep 06 12:43:05 2004
Thread 1 advanced to log sequence 20243
Current log# 1 seq# 20243 mem# 0: D:\ORANT\DATABASE\LOGDOOR1.ORA
Current log# 1 seq# 20243 mem# 1: E:\VSCDBF\LOGDOOR1A.ORA