免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12下一页
最近访问板块 发新帖
查看: 3519 | 回复: 11
打印 上一主题 下一主题

这种情况需要增加redo.log文件大小吗 [复制链接]

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2016-08-18 06:20:00
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2012-01-13 11:13 |只看该作者 |倒序浏览
最近查看alert.log文件,有下面一些错误提示:
  1. Thread 1 cannot allocate new log, sequence 1052
  2. Checkpoint not complete
复制代码
网上说这个错误需要增加redo文件大小。不过我这个出现的频率不是很高,12月30日出现1次,1月4日2次,1月6日1次,1月11日1次。这种情况下需要增加redo大小吗?

论坛徽章:
0
2 [报告]
发表于 2012-01-13 11:27 |只看该作者
我觉得redo文件过大不安全,还是增加redo组好!
还是先查看一下原因吧!

论坛徽章:
59
2015七夕节徽章
日期:2015-08-24 11:17:25ChinaUnix专家徽章
日期:2015-07-20 09:19:30每周论坛发贴之星
日期:2015-07-20 09:19:42ChinaUnix元老
日期:2015-07-20 11:04:38荣誉版主
日期:2015-07-20 11:05:19巳蛇
日期:2015-07-20 11:05:26CU十二周年纪念徽章
日期:2015-07-20 11:05:27IT运维版块每日发帖之星
日期:2015-07-20 11:05:34操作系统版块每日发帖之星
日期:2015-07-20 11:05:36程序设计版块每日发帖之星
日期:2015-07-20 11:05:40数据库技术版块每日发帖之星
日期:2015-07-20 11:05:432015年辞旧岁徽章
日期:2015-07-20 11:05:44
3 [报告]
发表于 2012-01-13 12:38 |只看该作者
把所有的信息都贴上来吧。

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2016-08-18 06:20:00
4 [报告]
发表于 2012-01-13 15:50 |只看该作者
下面是从12月30日到现在所有的信息。今天已经15点48分了,log里面还没有出现新的信息。
  1.   Current log# 2 seq# 1025 mem# 0: /oracle/oradata/szdb/redo02.log
  2. Fri Dec 30 14:01:08 CST 2011
  3. Thread 1 advanced to log sequence 1026 (LGWR switch)
  4.   Current log# 3 seq# 1026 mem# 0: /oracle/oradata/szdb/redo03.log
  5. Fri Dec 30 14:01:10 CST 2011
  6. Thread 1 advanced to log sequence 1027 (LGWR switch)
  7.   Current log# 1 seq# 1027 mem# 0: /oracle/oradata/szdb/redo01.log
  8. Fri Dec 30 14:03:47 CST 2011
  9. Thread 1 advanced to log sequence 1028 (LGWR switch)
  10.   Current log# 2 seq# 1028 mem# 0: /oracle/oradata/szdb/redo02.log
  11. Fri Dec 30 14:06:53 CST 2011
  12. Thread 1 advanced to log sequence 1029 (LGWR switch)
  13.   Current log# 3 seq# 1029 mem# 0: /oracle/oradata/szdb/redo03.log
  14. Fri Dec 30 16:37:06 CST 2011
  15. Thread 1 advanced to log sequence 1030 (LGWR switch)
  16.   Current log# 1 seq# 1030 mem# 0: /oracle/oradata/szdb/redo01.log
  17. Fri Dec 30 16:37:17 CST 2011
  18. Thread 1 advanced to log sequence 1031 (LGWR switch)
  19.   Current log# 2 seq# 1031 mem# 0: /oracle/oradata/szdb/redo02.log
  20. Thread 1 cannot allocate new log, sequence 1032
  21. Checkpoint not complete
  22.   Current log# 2 seq# 1031 mem# 0: /oracle/oradata/szdb/redo02.log
  23. Fri Dec 30 16:37:22 CST 2011
  24. Thread 1 advanced to log sequence 1032 (LGWR switch)
  25.   Current log# 3 seq# 1032 mem# 0: /oracle/oradata/szdb/redo03.log
  26. Fri Dec 30 16:40:18 CST 2011
  27. Thread 1 advanced to log sequence 1033 (LGWR switch)
  28.   Current log# 1 seq# 1033 mem# 0: /oracle/oradata/szdb/redo01.log
  29. Fri Dec 30 16:43:27 CST 2011
  30. Thread 1 advanced to log sequence 1034 (LGWR switch)
  31.   Current log# 2 seq# 1034 mem# 0: /oracle/oradata/szdb/redo02.log
  32. Fri Dec 30 22:00:12 CST 2011
  33. Thread 1 advanced to log sequence 1035 (LGWR switch)
  34.   Current log# 3 seq# 1035 mem# 0: /oracle/oradata/szdb/redo03.log
  35. Sat Dec 31 10:13:35 CST 2011
  36. Thread 1 advanced to log sequence 1036 (LGWR switch)
  37.   Current log# 1 seq# 1036 mem# 0: /oracle/oradata/szdb/redo01.log
  38. Sun Jan 01 18:00:40 CST 2012
  39. Thread 1 advanced to log sequence 1037 (LGWR switch)
  40.   Current log# 2 seq# 1037 mem# 0: /oracle/oradata/szdb/redo02.log
  41. Mon Jan 02 22:00:07 CST 2012
  42. Thread 1 advanced to log sequence 1038 (LGWR switch)
  43.   Current log# 3 seq# 1038 mem# 0: /oracle/oradata/szdb/redo03.log
  44. Tue Jan 03 09:00:45 CST 2012
  45. Thread 1 advanced to log sequence 1039 (LGWR switch)
  46.   Current log# 1 seq# 1039 mem# 0: /oracle/oradata/szdb/redo01.log
  47. Tue Jan 03 11:13:26 CST 2012
  48. Thread 1 advanced to log sequence 1040 (LGWR switch)
  49.   Current log# 2 seq# 1040 mem# 0: /oracle/oradata/szdb/redo02.log
  50. Tue Jan 03 11:13:29 CST 2012
  51. Thread 1 advanced to log sequence 1041 (LGWR switch)
  52.   Current log# 3 seq# 1041 mem# 0: /oracle/oradata/szdb/redo03.log
  53. Tue Jan 03 11:15:52 CST 2012
  54. Thread 1 advanced to log sequence 1042 (LGWR switch)
  55.   Current log# 1 seq# 1042 mem# 0: /oracle/oradata/szdb/redo01.log
  56. Tue Jan 03 11:18:55 CST 2012
  57. Thread 1 advanced to log sequence 1043 (LGWR switch)
  58.   Current log# 2 seq# 1043 mem# 0: /oracle/oradata/szdb/redo02.log
  59. Tue Jan 03 16:19:21 CST 2012
  60. Thread 1 advanced to log sequence 1044 (LGWR switch)
  61.   Current log# 3 seq# 1044 mem# 0: /oracle/oradata/szdb/redo03.log
  62. Wed Jan 04 10:31:43 CST 2012
  63. Thread 1 advanced to log sequence 1045 (LGWR switch)
  64.   Current log# 1 seq# 1045 mem# 0: /oracle/oradata/szdb/redo01.log
  65. Wed Jan 04 10:31:56 CST 2012
  66. Thread 1 advanced to log sequence 1046 (LGWR switch)
  67.   Current log# 2 seq# 1046 mem# 0: /oracle/oradata/szdb/redo02.log
  68. Thread 1 cannot allocate new log, sequence 1047
  69. Checkpoint not complete
  70.   Current log# 2 seq# 1046 mem# 0: /oracle/oradata/szdb/redo02.log
  71. Wed Jan 04 10:32:01 CST 2012
  72. Thread 1 advanced to log sequence 1047 (LGWR switch)
  73.   Current log# 3 seq# 1047 mem# 0: /oracle/oradata/szdb/redo03.log
  74. Wed Jan 04 10:34:51 CST 2012
  75. Thread 1 advanced to log sequence 1048 (LGWR switch)
  76.   Current log# 1 seq# 1048 mem# 0: /oracle/oradata/szdb/redo01.log
  77. Wed Jan 04 10:37:58 CST 2012
  78. Thread 1 advanced to log sequence 1049 (LGWR switch)
  79.   Current log# 2 seq# 1049 mem# 0: /oracle/oradata/szdb/redo02.log
  80. Wed Jan 04 16:07:42 CST 2012
  81. Thread 1 advanced to log sequence 1050 (LGWR switch)
  82.   Current log# 3 seq# 1050 mem# 0: /oracle/oradata/szdb/redo03.log
  83. Wed Jan 04 16:07:53 CST 2012
  84. Thread 1 advanced to log sequence 1051 (LGWR switch)
  85.   Current log# 1 seq# 1051 mem# 0: /oracle/oradata/szdb/redo01.log
  86. Thread 1 cannot allocate new log, sequence 1052
  87. Checkpoint not complete
  88.   Current log# 1 seq# 1051 mem# 0: /oracle/oradata/szdb/redo01.log
  89. Wed Jan 04 16:07:58 CST 2012
  90. Thread 1 advanced to log sequence 1052 (LGWR switch)
  91.   Current log# 2 seq# 1052 mem# 0: /oracle/oradata/szdb/redo02.log
  92. Wed Jan 04 16:10:49 CST 2012
  93. Thread 1 advanced to log sequence 1053 (LGWR switch)
  94.   Current log# 3 seq# 1053 mem# 0: /oracle/oradata/szdb/redo03.log
  95. Wed Jan 04 16:13:52 CST 2012
  96. Thread 1 advanced to log sequence 1054 (LGWR switch)
  97.   Current log# 1 seq# 1054 mem# 0: /oracle/oradata/szdb/redo01.log
  98. Wed Jan 04 22:00:11 CST 2012
  99. Thread 1 advanced to log sequence 1055 (LGWR switch)
  100.   Current log# 2 seq# 1055 mem# 0: /oracle/oradata/szdb/redo02.log
  101. Thu Jan 05 12:31:15 CST 2012
  102. Thread 1 advanced to log sequence 1056 (LGWR switch)
  103.   Current log# 3 seq# 1056 mem# 0: /oracle/oradata/szdb/redo03.log
  104. Thu Jan 05 12:31:17 CST 2012
  105. Thread 1 advanced to log sequence 1057 (LGWR switch)
  106.   Current log# 1 seq# 1057 mem# 0: /oracle/oradata/szdb/redo01.log
  107. Thu Jan 05 12:31:35 CST 2012
  108. Thread 1 advanced to log sequence 1058 (LGWR switch)
  109.   Current log# 2 seq# 1058 mem# 0: /oracle/oradata/szdb/redo02.log
  110. Thu Jan 05 12:34:44 CST 2012
  111. Thread 1 advanced to log sequence 1059 (LGWR switch)
  112.   Current log# 3 seq# 1059 mem# 0: /oracle/oradata/szdb/redo03.log
  113. Thu Jan 05 12:37:45 CST 2012
  114. Thread 1 advanced to log sequence 1060 (LGWR switch)
  115.   Current log# 1 seq# 1060 mem# 0: /oracle/oradata/szdb/redo01.log
  116. Thu Jan 05 16:30:10 CST 2012
  117. Thread 1 advanced to log sequence 1061 (LGWR switch)
  118.   Current log# 2 seq# 1061 mem# 0: /oracle/oradata/szdb/redo02.log
  119. Thu Jan 05 16:30:12 CST 2012
  120. Thread 1 advanced to log sequence 1062 (LGWR switch)
  121.   Current log# 3 seq# 1062 mem# 0: /oracle/oradata/szdb/redo03.log
  122. Thu Jan 05 16:30:32 CST 2012
  123. Thread 1 advanced to log sequence 1063 (LGWR switch)
  124.   Current log# 1 seq# 1063 mem# 0: /oracle/oradata/szdb/redo01.log
  125. Thu Jan 05 16:33:40 CST 2012
  126. Thread 1 advanced to log sequence 1064 (LGWR switch)
  127.   Current log# 2 seq# 1064 mem# 0: /oracle/oradata/szdb/redo02.log
  128. Thu Jan 05 16:36:42 CST 2012
  129. Thread 1 advanced to log sequence 1065 (LGWR switch)
  130.   Current log# 3 seq# 1065 mem# 0: /oracle/oradata/szdb/redo03.log
  131. Fri Jan 06 00:00:24 CST 2012
  132. Thread 1 advanced to log sequence 1066 (LGWR switch)
  133.   Current log# 1 seq# 1066 mem# 0: /oracle/oradata/szdb/redo01.log
  134. Fri Jan 06 17:15:29 CST 2012
  135. Thread 1 advanced to log sequence 1067 (LGWR switch)
  136.   Current log# 2 seq# 1067 mem# 0: /oracle/oradata/szdb/redo02.log
  137. Fri Jan 06 17:15:31 CST 2012
  138. Thread 1 advanced to log sequence 1068 (LGWR switch)
  139.   Current log# 3 seq# 1068 mem# 0: /oracle/oradata/szdb/redo03.log
  140. Fri Jan 06 17:15:45 CST 2012
  141. Thread 1 cannot allocate new log, sequence 1069
  142. Checkpoint not complete
  143.   Current log# 3 seq# 1068 mem# 0: /oracle/oradata/szdb/redo03.log
  144. Fri Jan 06 17:15:45 CST 2012
  145. Thread 1 advanced to log sequence 1069 (LGWR switch)
  146.   Current log# 1 seq# 1069 mem# 0: /oracle/oradata/szdb/redo01.log
  147. Fri Jan 06 17:18:52 CST 2012
  148. Thread 1 advanced to log sequence 1070 (LGWR switch)
  149.   Current log# 2 seq# 1070 mem# 0: /oracle/oradata/szdb/redo02.log
  150. Fri Jan 06 17:21:51 CST 2012
  151. Thread 1 advanced to log sequence 1071 (LGWR switch)
  152.   Current log# 3 seq# 1071 mem# 0: /oracle/oradata/szdb/redo03.log
  153. Fri Jan 06 22:59:07 CST 2012
  154. Thread 1 advanced to log sequence 1072 (LGWR switch)
  155.   Current log# 1 seq# 1072 mem# 0: /oracle/oradata/szdb/redo01.log
  156. Sun Jan 08 07:00:55 CST 2012
  157. Thread 1 advanced to log sequence 1073 (LGWR switch)
  158.   Current log# 2 seq# 1073 mem# 0: /oracle/oradata/szdb/redo02.log
  159. Mon Jan 09 07:05:36 CST 2012
  160. Thread 1 advanced to log sequence 1074 (LGWR switch)
  161.   Current log# 3 seq# 1074 mem# 0: /oracle/oradata/szdb/redo03.log
  162. Tue Jan 10 05:00:12 CST 2012
  163. Thread 1 advanced to log sequence 1075 (LGWR switch)
  164.   Current log# 1 seq# 1075 mem# 0: /oracle/oradata/szdb/redo01.log
  165. Tue Jan 10 22:00:07 CST 2012
  166. Thread 1 advanced to log sequence 1076 (LGWR switch)
  167.   Current log# 2 seq# 1076 mem# 0: /oracle/oradata/szdb/redo02.log
  168. Wed Jan 11 11:24:15 CST 2012
  169. Thread 1 advanced to log sequence 1077 (LGWR switch)
  170.   Current log# 3 seq# 1077 mem# 0: /oracle/oradata/szdb/redo03.log
  171. Wed Jan 11 11:24:17 CST 2012
  172. Thread 1 advanced to log sequence 1078 (LGWR switch)
  173.   Current log# 1 seq# 1078 mem# 0: /oracle/oradata/szdb/redo01.log
  174. Wed Jan 11 11:24:44 CST 2012
  175. Thread 1 advanced to log sequence 1079 (LGWR switch)
  176.   Current log# 2 seq# 1079 mem# 0: /oracle/oradata/szdb/redo02.log
  177. Wed Jan 11 11:27:46 CST 2012
  178. Thread 1 advanced to log sequence 1080 (LGWR switch)
  179.   Current log# 3 seq# 1080 mem# 0: /oracle/oradata/szdb/redo03.log
  180. Wed Jan 11 11:30:46 CST 2012
  181. Thread 1 advanced to log sequence 1081 (LGWR switch)
  182.   Current log# 1 seq# 1081 mem# 0: /oracle/oradata/szdb/redo01.log
  183. Wed Jan 11 13:54:28 CST 2012
  184. Thread 1 advanced to log sequence 1082 (LGWR switch)
  185.   Current log# 2 seq# 1082 mem# 0: /oracle/oradata/szdb/redo02.log
  186. Wed Jan 11 13:54:29 CST 2012
  187. Thread 1 advanced to log sequence 1083 (LGWR switch)
  188.   Current log# 3 seq# 1083 mem# 0: /oracle/oradata/szdb/redo03.log
  189. Wed Jan 11 13:55:05 CST 2012
  190. Thread 1 advanced to log sequence 1084 (LGWR switch)
  191.   Current log# 1 seq# 1084 mem# 0: /oracle/oradata/szdb/redo01.log
  192. Wed Jan 11 13:58:07 CST 2012
  193. Thread 1 advanced to log sequence 1085 (LGWR switch)
  194.   Current log# 2 seq# 1085 mem# 0: /oracle/oradata/szdb/redo02.log
  195. Wed Jan 11 14:01:00 CST 2012
  196. Thread 1 advanced to log sequence 1086 (LGWR switch)
  197.   Current log# 3 seq# 1086 mem# 0: /oracle/oradata/szdb/redo03.log
  198. Wed Jan 11 15:22:38 CST 2012
  199. Thread 1 advanced to log sequence 1087 (LGWR switch)
  200.   Current log# 1 seq# 1087 mem# 0: /oracle/oradata/szdb/redo01.log
  201. Wed Jan 11 15:24:30 CST 2012
  202. Thread 1 advanced to log sequence 1088 (LGWR switch)
  203.   Current log# 2 seq# 1088 mem# 0: /oracle/oradata/szdb/redo02.log
  204. Wed Jan 11 15:24:41 CST 2012
  205. Thread 1 cannot allocate new log, sequence 1089
  206. Checkpoint not complete
  207.   Current log# 2 seq# 1088 mem# 0: /oracle/oradata/szdb/redo02.log
  208. Wed Jan 11 15:24:44 CST 2012
  209. Thread 1 advanced to log sequence 1089 (LGWR switch)
  210.   Current log# 3 seq# 1089 mem# 0: /oracle/oradata/szdb/redo03.log
  211. Wed Jan 11 15:32:48 CST 2012
  212. Thread 1 advanced to log sequence 1090 (LGWR switch)
  213.   Current log# 1 seq# 1090 mem# 0: /oracle/oradata/szdb/redo01.log
  214. Thu Jan 12 07:07:36 CST 2012
  215. Thread 1 advanced to log sequence 1091 (LGWR switch)
  216.   Current log# 2 seq# 1091 mem# 0: /oracle/oradata/szdb/redo02.log
  217. Thu Jan 12 08:57:36 CST 2012
  218. Thread 1 advanced to log sequence 1092 (LGWR switch)
  219.   Current log# 3 seq# 1092 mem# 0: /oracle/oradata/szdb/redo03.log
  220. Thu Jan 12 08:57:38 CST 2012
  221. Thread 1 advanced to log sequence 1093 (LGWR switch)
  222.   Current log# 1 seq# 1093 mem# 0: /oracle/oradata/szdb/redo01.log
  223. Thu Jan 12 09:00:11 CST 2012
  224. Thread 1 advanced to log sequence 1094 (LGWR switch)
  225.   Current log# 2 seq# 1094 mem# 0: /oracle/oradata/szdb/redo02.log
  226. Thu Jan 12 09:03:16 CST 2012
  227. Thread 1 advanced to log sequence 1095 (LGWR switch)
  228.   Current log# 3 seq# 1095 mem# 0: /oracle/oradata/szdb/redo03.log
  229. Thu Jan 12 10:00:14 CST 2012
  230. Thread 1 advanced to log sequence 1096 (LGWR switch)
  231.   Current log# 1 seq# 1096 mem# 0: /oracle/oradata/szdb/redo01.log
  232. Thu Jan 12 22:00:22 CST 2012
  233. Thread 1 advanced to log sequence 1097 (LGWR switch)
  234.   Current log# 2 seq# 1097 mem# 0: /oracle/oradata/szdb/redo02.log
复制代码

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2016-08-18 06:20:00
5 [报告]
发表于 2012-01-13 15:54 |只看该作者
9月份开始出现Checkpoint not complete这些信息,我在12月28日发现后,把redo文件由50m增加到了100m。之后还是不时出现这个信息。

论坛徽章:
0
6 [报告]
发表于 2012-01-13 17:51 |只看该作者
感觉日志切换并不频繁,可能是在数据高峰时出现not complete。如果业务影响不大,可以再观察。

论坛徽章:
59
2015七夕节徽章
日期:2015-08-24 11:17:25ChinaUnix专家徽章
日期:2015-07-20 09:19:30每周论坛发贴之星
日期:2015-07-20 09:19:42ChinaUnix元老
日期:2015-07-20 11:04:38荣誉版主
日期:2015-07-20 11:05:19巳蛇
日期:2015-07-20 11:05:26CU十二周年纪念徽章
日期:2015-07-20 11:05:27IT运维版块每日发帖之星
日期:2015-07-20 11:05:34操作系统版块每日发帖之星
日期:2015-07-20 11:05:36程序设计版块每日发帖之星
日期:2015-07-20 11:05:40数据库技术版块每日发帖之星
日期:2015-07-20 11:05:432015年辞旧岁徽章
日期:2015-07-20 11:05:44
7 [报告]
发表于 2012-01-13 23:41 |只看该作者
平均三分钟切换一次。够快的了。

论坛徽章:
17
CU大牛徽章
日期:2013-03-13 15:32:352017金鸡报晓
日期:2017-02-08 10:33:21fulanqi
日期:2016-06-17 17:54:25lufei
日期:2016-06-17 17:38:40平安夜徽章
日期:2015-12-26 00:06:30冥斗士
日期:2015-11-25 14:38:112015年辞旧岁徽章
日期:2015-03-03 16:54:15亥猪
日期:2015-01-26 17:23:43CU大牛徽章
日期:2013-04-17 11:02:58CU大牛徽章
日期:2013-04-17 11:02:36CU大牛徽章
日期:2013-04-17 11:02:15CU大牛徽章
日期:2013-04-17 11:01:45
8 [报告]
发表于 2012-01-14 10:06 |只看该作者
增加一个日志文件呗

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2016-08-18 06:20:00
9 [报告]
发表于 2012-01-16 10:09 |只看该作者
guyeh 发表于 2012-01-14 10:06
增加一个日志文件呗

增加日志文件的个数好还是增加日志文件的大小好?

论坛徽章:
1
数据库技术版块每日发帖之星
日期:2016-08-18 06:20:00
10 [报告]
发表于 2012-01-16 10:11 |只看该作者
sinopec_付强 发表于 2012-01-13 17:51
感觉日志切换并不频繁,可能是在数据高峰时出现not complete。如果业务影响不大,可以再观察。

renxiao2003 发表于 2012-01-13 23:41
平均三分钟切换一次。够快的了。


的确大部分时间都没有出现,偶尔会出现高峰,出现not complete。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP