redo日志大小设置建议
先看一个alert日志中日志切换的例子后再予以说明:
Fri Aug 6 12:16:57 2021
Thread 1 advanced to log sequence 1661
Current log# 1 seq# 1661 mem# 0: /oracle/oradata/redo01.log
Thread 1 advanced to log sequence 1662
Current log# 2 seq# 1662 mem# 0: /oracle/oradata/redo02.log
Fri Aug 6 12:18:21 2021
Thread 1 advanced to log sequence 1663
Current log# 3 seq# 1663 mem# 0: /oracle/oradata/redo03.log
Thread 1 advanced to log sequence 1664
Current log# 1 seq# 1664 mem# 0: /oracle/oradata/redo01.log
Fri Aug 6 12:21:17 2021
Thread 1 advanced to log sequence 1665
Current log# 2 seq# 1665 mem# 0: /oracle/oradata/redo02.log
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/70006680/viewspace-2791414/ ,如需转载,请注明出处,否则将追究法律责任。