论坛 › Oracle › 这种情况需要增加redo.log文件大小吗

云裴 发表于 2012-01-13 11:13

这种情况需要增加redo.log文件大小吗

最近查看alert.log文件，有下面一些错误提示：Thread 1 cannot allocate new log, sequence 1052
Checkpoint not complete网上说这个错误需要增加redo文件大小。不过我这个出现的频率不是很高，12月30日出现1次，1月4日2次，1月6日1次，1月11日1次。这种情况下需要增加redo大小吗？

sinopec_付强 发表于 2012-01-13 11:27

我觉得redo文件过大不安全，还是增加redo组好！
还是先查看一下原因吧！

renxiao2003 发表于 2012-01-13 12:38

把所有的信息都贴上来吧。

云裴 发表于 2012-01-13 15:50

下面是从12月30日到现在所有的信息。今天已经15点48分了，log里面还没有出现新的信息。Current log# 2 seq# 1025 mem# 0: /oracle/oradata/szdb/redo02.log
Fri Dec 30 14:01:08 CST 2011
Thread 1 advanced to log sequence 1026 (LGWR switch)
Current log# 3 seq# 1026 mem# 0: /oracle/oradata/szdb/redo03.log
Fri Dec 30 14:01:10 CST 2011
Thread 1 advanced to log sequence 1027 (LGWR switch)
Current log# 1 seq# 1027 mem# 0: /oracle/oradata/szdb/redo01.log
Fri Dec 30 14:03:47 CST 2011
Thread 1 advanced to log sequence 1028 (LGWR switch)
Current log# 2 seq# 1028 mem# 0: /oracle/oradata/szdb/redo02.log
Fri Dec 30 14:06:53 CST 2011
Thread 1 advanced to log sequence 1029 (LGWR switch)
Current log# 3 seq# 1029 mem# 0: /oracle/oradata/szdb/redo03.log
Fri Dec 30 16:37:06 CST 2011
Thread 1 advanced to log sequence 1030 (LGWR switch)
Current log# 1 seq# 1030 mem# 0: /oracle/oradata/szdb/redo01.log
Fri Dec 30 16:37:17 CST 2011
Thread 1 advanced to log sequence 1031 (LGWR switch)
Current log# 2 seq# 1031 mem# 0: /oracle/oradata/szdb/redo02.log
Thread 1 cannot allocate new log, sequence 1032
Checkpoint not complete
Current log# 2 seq# 1031 mem# 0: /oracle/oradata/szdb/redo02.log
Fri Dec 30 16:37:22 CST 2011
Thread 1 advanced to log sequence 1032 (LGWR switch)
Current log# 3 seq# 1032 mem# 0: /oracle/oradata/szdb/redo03.log
Fri Dec 30 16:40:18 CST 2011
Thread 1 advanced to log sequence 1033 (LGWR switch)
Current log# 1 seq# 1033 mem# 0: /oracle/oradata/szdb/redo01.log
Fri Dec 30 16:43:27 CST 2011
Thread 1 advanced to log sequence 1034 (LGWR switch)
Current log# 2 seq# 1034 mem# 0: /oracle/oradata/szdb/redo02.log
Fri Dec 30 22:00:12 CST 2011
Thread 1 advanced to log sequence 1035 (LGWR switch)
Current log# 3 seq# 1035 mem# 0: /oracle/oradata/szdb/redo03.log
Sat Dec 31 10:13:35 CST 2011
Thread 1 advanced to log sequence 1036 (LGWR switch)
Current log# 1 seq# 1036 mem# 0: /oracle/oradata/szdb/redo01.log
Sun Jan 01 18:00:40 CST 2012
Thread 1 advanced to log sequence 1037 (LGWR switch)
Current log# 2 seq# 1037 mem# 0: /oracle/oradata/szdb/redo02.log
Mon Jan 02 22:00:07 CST 2012
Thread 1 advanced to log sequence 1038 (LGWR switch)
Current log# 3 seq# 1038 mem# 0: /oracle/oradata/szdb/redo03.log
Tue Jan 03 09:00:45 CST 2012
Thread 1 advanced to log sequence 1039 (LGWR switch)
Current log# 1 seq# 1039 mem# 0: /oracle/oradata/szdb/redo01.log
Tue Jan 03 11:13:26 CST 2012
Thread 1 advanced to log sequence 1040 (LGWR switch)
Current log# 2 seq# 1040 mem# 0: /oracle/oradata/szdb/redo02.log
Tue Jan 03 11:13:29 CST 2012
Thread 1 advanced to log sequence 1041 (LGWR switch)
Current log# 3 seq# 1041 mem# 0: /oracle/oradata/szdb/redo03.log
Tue Jan 03 11:15:52 CST 2012
Thread 1 advanced to log sequence 1042 (LGWR switch)
Current log# 1 seq# 1042 mem# 0: /oracle/oradata/szdb/redo01.log
Tue Jan 03 11:18:55 CST 2012
Thread 1 advanced to log sequence 1043 (LGWR switch)
Current log# 2 seq# 1043 mem# 0: /oracle/oradata/szdb/redo02.log
Tue Jan 03 16:19:21 CST 2012
Thread 1 advanced to log sequence 1044 (LGWR switch)
Current log# 3 seq# 1044 mem# 0: /oracle/oradata/szdb/redo03.log
Wed Jan 04 10:31:43 CST 2012
Thread 1 advanced to log sequence 1045 (LGWR switch)
Current log# 1 seq# 1045 mem# 0: /oracle/oradata/szdb/redo01.log
Wed Jan 04 10:31:56 CST 2012
Thread 1 advanced to log sequence 1046 (LGWR switch)
Current log# 2 seq# 1046 mem# 0: /oracle/oradata/szdb/redo02.log
Thread 1 cannot allocate new log, sequence 1047
Checkpoint not complete
Current log# 2 seq# 1046 mem# 0: /oracle/oradata/szdb/redo02.log
Wed Jan 04 10:32:01 CST 2012
Thread 1 advanced to log sequence 1047 (LGWR switch)
Current log# 3 seq# 1047 mem# 0: /oracle/oradata/szdb/redo03.log
Wed Jan 04 10:34:51 CST 2012
Thread 1 advanced to log sequence 1048 (LGWR switch)
Current log# 1 seq# 1048 mem# 0: /oracle/oradata/szdb/redo01.log
Wed Jan 04 10:37:58 CST 2012
Thread 1 advanced to log sequence 1049 (LGWR switch)
Current log# 2 seq# 1049 mem# 0: /oracle/oradata/szdb/redo02.log
Wed Jan 04 16:07:42 CST 2012
Thread 1 advanced to log sequence 1050 (LGWR switch)
Current log# 3 seq# 1050 mem# 0: /oracle/oradata/szdb/redo03.log
Wed Jan 04 16:07:53 CST 2012
Thread 1 advanced to log sequence 1051 (LGWR switch)
Current log# 1 seq# 1051 mem# 0: /oracle/oradata/szdb/redo01.log
Thread 1 cannot allocate new log, sequence 1052
Checkpoint not complete
Current log# 1 seq# 1051 mem# 0: /oracle/oradata/szdb/redo01.log
Wed Jan 04 16:07:58 CST 2012
Thread 1 advanced to log sequence 1052 (LGWR switch)
Current log# 2 seq# 1052 mem# 0: /oracle/oradata/szdb/redo02.log
Wed Jan 04 16:10:49 CST 2012
Thread 1 advanced to log sequence 1053 (LGWR switch)
Current log# 3 seq# 1053 mem# 0: /oracle/oradata/szdb/redo03.log
Wed Jan 04 16:13:52 CST 2012
Thread 1 advanced to log sequence 1054 (LGWR switch)
Current log# 1 seq# 1054 mem# 0: /oracle/oradata/szdb/redo01.log
Wed Jan 04 22:00:11 CST 2012
Thread 1 advanced to log sequence 1055 (LGWR switch)
Current log# 2 seq# 1055 mem# 0: /oracle/oradata/szdb/redo02.log
Thu Jan 05 12:31:15 CST 2012
Thread 1 advanced to log sequence 1056 (LGWR switch)
Current log# 3 seq# 1056 mem# 0: /oracle/oradata/szdb/redo03.log
Thu Jan 05 12:31:17 CST 2012
Thread 1 advanced to log sequence 1057 (LGWR switch)
Current log# 1 seq# 1057 mem# 0: /oracle/oradata/szdb/redo01.log
Thu Jan 05 12:31:35 CST 2012
Thread 1 advanced to log sequence 1058 (LGWR switch)
Current log# 2 seq# 1058 mem# 0: /oracle/oradata/szdb/redo02.log
Thu Jan 05 12:34:44 CST 2012
Thread 1 advanced to log sequence 1059 (LGWR switch)
Current log# 3 seq# 1059 mem# 0: /oracle/oradata/szdb/redo03.log
Thu Jan 05 12:37:45 CST 2012
Thread 1 advanced to log sequence 1060 (LGWR switch)
Current log# 1 seq# 1060 mem# 0: /oracle/oradata/szdb/redo01.log
Thu Jan 05 16:30:10 CST 2012
Thread 1 advanced to log sequence 1061 (LGWR switch)
Current log# 2 seq# 1061 mem# 0: /oracle/oradata/szdb/redo02.log
Thu Jan 05 16:30:12 CST 2012
Thread 1 advanced to log sequence 1062 (LGWR switch)
Current log# 3 seq# 1062 mem# 0: /oracle/oradata/szdb/redo03.log
Thu Jan 05 16:30:32 CST 2012
Thread 1 advanced to log sequence 1063 (LGWR switch)
Current log# 1 seq# 1063 mem# 0: /oracle/oradata/szdb/redo01.log
Thu Jan 05 16:33:40 CST 2012
Thread 1 advanced to log sequence 1064 (LGWR switch)
Current log# 2 seq# 1064 mem# 0: /oracle/oradata/szdb/redo02.log
Thu Jan 05 16:36:42 CST 2012
Thread 1 advanced to log sequence 1065 (LGWR switch)
Current log# 3 seq# 1065 mem# 0: /oracle/oradata/szdb/redo03.log
Fri Jan 06 00:00:24 CST 2012
Thread 1 advanced to log sequence 1066 (LGWR switch)
Current log# 1 seq# 1066 mem# 0: /oracle/oradata/szdb/redo01.log
Fri Jan 06 17:15:29 CST 2012
Thread 1 advanced to log sequence 1067 (LGWR switch)
Current log# 2 seq# 1067 mem# 0: /oracle/oradata/szdb/redo02.log
Fri Jan 06 17:15:31 CST 2012
Thread 1 advanced to log sequence 1068 (LGWR switch)
Current log# 3 seq# 1068 mem# 0: /oracle/oradata/szdb/redo03.log
Fri Jan 06 17:15:45 CST 2012
Thread 1 cannot allocate new log, sequence 1069
Checkpoint not complete
Current log# 3 seq# 1068 mem# 0: /oracle/oradata/szdb/redo03.log
Fri Jan 06 17:15:45 CST 2012
Thread 1 advanced to log sequence 1069 (LGWR switch)
Current log# 1 seq# 1069 mem# 0: /oracle/oradata/szdb/redo01.log
Fri Jan 06 17:18:52 CST 2012
Thread 1 advanced to log sequence 1070 (LGWR switch)
Current log# 2 seq# 1070 mem# 0: /oracle/oradata/szdb/redo02.log
Fri Jan 06 17:21:51 CST 2012
Thread 1 advanced to log sequence 1071 (LGWR switch)
Current log# 3 seq# 1071 mem# 0: /oracle/oradata/szdb/redo03.log
Fri Jan 06 22:59:07 CST 2012
Thread 1 advanced to log sequence 1072 (LGWR switch)
Current log# 1 seq# 1072 mem# 0: /oracle/oradata/szdb/redo01.log
Sun Jan 08 07:00:55 CST 2012
Thread 1 advanced to log sequence 1073 (LGWR switch)
Current log# 2 seq# 1073 mem# 0: /oracle/oradata/szdb/redo02.log
Mon Jan 09 07:05:36 CST 2012
Thread 1 advanced to log sequence 1074 (LGWR switch)
Current log# 3 seq# 1074 mem# 0: /oracle/oradata/szdb/redo03.log
Tue Jan 10 05:00:12 CST 2012
Thread 1 advanced to log sequence 1075 (LGWR switch)
Current log# 1 seq# 1075 mem# 0: /oracle/oradata/szdb/redo01.log
Tue Jan 10 22:00:07 CST 2012
Thread 1 advanced to log sequence 1076 (LGWR switch)
Current log# 2 seq# 1076 mem# 0: /oracle/oradata/szdb/redo02.log
Wed Jan 11 11:24:15 CST 2012
Thread 1 advanced to log sequence 1077 (LGWR switch)
Current log# 3 seq# 1077 mem# 0: /oracle/oradata/szdb/redo03.log
Wed Jan 11 11:24:17 CST 2012
Thread 1 advanced to log sequence 1078 (LGWR switch)
Current log# 1 seq# 1078 mem# 0: /oracle/oradata/szdb/redo01.log
Wed Jan 11 11:24:44 CST 2012
Thread 1 advanced to log sequence 1079 (LGWR switch)
Current log# 2 seq# 1079 mem# 0: /oracle/oradata/szdb/redo02.log
Wed Jan 11 11:27:46 CST 2012
Thread 1 advanced to log sequence 1080 (LGWR switch)
Current log# 3 seq# 1080 mem# 0: /oracle/oradata/szdb/redo03.log
Wed Jan 11 11:30:46 CST 2012
Thread 1 advanced to log sequence 1081 (LGWR switch)
Current log# 1 seq# 1081 mem# 0: /oracle/oradata/szdb/redo01.log
Wed Jan 11 13:54:28 CST 2012
Thread 1 advanced to log sequence 1082 (LGWR switch)
Current log# 2 seq# 1082 mem# 0: /oracle/oradata/szdb/redo02.log
Wed Jan 11 13:54:29 CST 2012
Thread 1 advanced to log sequence 1083 (LGWR switch)
Current log# 3 seq# 1083 mem# 0: /oracle/oradata/szdb/redo03.log
Wed Jan 11 13:55:05 CST 2012
Thread 1 advanced to log sequence 1084 (LGWR switch)
Current log# 1 seq# 1084 mem# 0: /oracle/oradata/szdb/redo01.log
Wed Jan 11 13:58:07 CST 2012
Thread 1 advanced to log sequence 1085 (LGWR switch)
Current log# 2 seq# 1085 mem# 0: /oracle/oradata/szdb/redo02.log
Wed Jan 11 14:01:00 CST 2012
Thread 1 advanced to log sequence 1086 (LGWR switch)
Current log# 3 seq# 1086 mem# 0: /oracle/oradata/szdb/redo03.log
Wed Jan 11 15:22:38 CST 2012
Thread 1 advanced to log sequence 1087 (LGWR switch)
Current log# 1 seq# 1087 mem# 0: /oracle/oradata/szdb/redo01.log
Wed Jan 11 15:24:30 CST 2012
Thread 1 advanced to log sequence 1088 (LGWR switch)
Current log# 2 seq# 1088 mem# 0: /oracle/oradata/szdb/redo02.log
Wed Jan 11 15:24:41 CST 2012
Thread 1 cannot allocate new log, sequence 1089
Checkpoint not complete
Current log# 2 seq# 1088 mem# 0: /oracle/oradata/szdb/redo02.log
Wed Jan 11 15:24:44 CST 2012
Thread 1 advanced to log sequence 1089 (LGWR switch)
Current log# 3 seq# 1089 mem# 0: /oracle/oradata/szdb/redo03.log
Wed Jan 11 15:32:48 CST 2012
Thread 1 advanced to log sequence 1090 (LGWR switch)
Current log# 1 seq# 1090 mem# 0: /oracle/oradata/szdb/redo01.log
Thu Jan 12 07:07:36 CST 2012
Thread 1 advanced to log sequence 1091 (LGWR switch)
Current log# 2 seq# 1091 mem# 0: /oracle/oradata/szdb/redo02.log
Thu Jan 12 08:57:36 CST 2012
Thread 1 advanced to log sequence 1092 (LGWR switch)
Current log# 3 seq# 1092 mem# 0: /oracle/oradata/szdb/redo03.log
Thu Jan 12 08:57:38 CST 2012
Thread 1 advanced to log sequence 1093 (LGWR switch)
Current log# 1 seq# 1093 mem# 0: /oracle/oradata/szdb/redo01.log
Thu Jan 12 09:00:11 CST 2012
Thread 1 advanced to log sequence 1094 (LGWR switch)
Current log# 2 seq# 1094 mem# 0: /oracle/oradata/szdb/redo02.log
Thu Jan 12 09:03:16 CST 2012
Thread 1 advanced to log sequence 1095 (LGWR switch)
Current log# 3 seq# 1095 mem# 0: /oracle/oradata/szdb/redo03.log
Thu Jan 12 10:00:14 CST 2012
Thread 1 advanced to log sequence 1096 (LGWR switch)
Current log# 1 seq# 1096 mem# 0: /oracle/oradata/szdb/redo01.log
Thu Jan 12 22:00:22 CST 2012
Thread 1 advanced to log sequence 1097 (LGWR switch)
Current log# 2 seq# 1097 mem# 0: /oracle/oradata/szdb/redo02.log

云裴 发表于 2012-01-13 15:54

9月份开始出现Checkpoint not complete这些信息，我在12月28日发现后，把redo文件由50m增加到了100m。之后还是不时出现这个信息。

sinopec_付强 发表于 2012-01-13 17:51

感觉日志切换并不频繁，可能是在数据高峰时出现not complete。如果业务影响不大，可以再观察。

renxiao2003 发表于 2012-01-13 23:41

平均三分钟切换一次。够快的了。

guyeh 发表于 2012-01-14 10:06

增加一个日志文件呗

云裴 发表于 2012-01-16 10:09

guyeh 发表于 2012-01-14 10:06 static/image/common/back.gif
增加一个日志文件呗
增加日志文件的个数好还是增加日志文件的大小好？

云裴 发表于 2012-01-16 10:11

sinopec_付强 发表于 2012-01-13 17:51 static/image/common/back.gif
感觉日志切换并不频繁，可能是在数据高峰时出现not complete。如果业务影响不大，可以再观察。

renxiao2003 发表于 2012-01-13 23:41 static/image/common/back.gif
平均三分钟切换一次。够快的了。

的确大部分时间都没有出现，偶尔会出现高峰，出现not complete。

查看完整版本: 这种情况需要增加redo.log文件大小吗