redo基本上一分钟切一次,归档明显很小
SQL> show parameter ARCHIVE_LAG_TARGET
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
SQL> select bytes/1024/1024 from v$log; 在线日志都是150M大小!
BYTES/1024/1024
---------------
150
150
150
redo日志:
ll /oradata/sip/redo* -th
-rw-r----- 1 oracle oinstall 151M Dec 7 14:15 /oradata/sip/redo02.log
-rw-r----- 1 oracle oinstall 151M Dec 7 14:15 /oradata/sip/redo01.log
-rw-r----- 1 oracle oinstall 151M Dec 7 14:14 /oradata/sip/redo03.log
归档日志目录:
-rw-r----- 1 oracle oinstall 288K Dec 7 13:50 1_21639_883154058.dbf
-rw-r----- 1 oracle oinstall 328K Dec 7 13:51 1_21640_883154058.dbf
-rw-r----- 1 oracle oinstall 175K Dec 7 13:52 1_21641_883154058.dbf
-rw-r----- 1 oracle oinstall 183K Dec 7 13:53 1_21642_883154058.dbf
-rw-r----- 1 oracle oinstall 182K Dec 7 13:54 1_21643_883154058.dbf
-rw-r----- 1 oracle oinstall 159K Dec 7 13:55 1_21644_883154058.dbf
-rw-r----- 1 oracle oinstall 135K Dec 7 13:56 1_21645_883154058.dbf
-rw-r----- 1 oracle oinstall 72K Dec 7 13:57 1_21646_883154058.dbf
-rw-r----- 1 oracle oinstall 189K Dec 7 13:58 1_21647_883154058.dbf
-rw-r----- 1 oracle oinstall 77K Dec 7 13:59 1_21648_883154058.dbf
-rw-r----- 1 oracle oinstall 2.1M Dec 7 14:00 1_21649_883154058.dbf
-rw-r----- 1 oracle oinstall 151K Dec 7 14:01 1_21650_883154058.dbf
-rw-r----- 1 oracle oinstall 198K Dec 7 14:02 1_21651_883154058.dbf
-rw-r----- 1 oracle oinstall 168K Dec 7 14:03 1_21652_883154058.dbf
-rw-r----- 1 oracle oinstall 202K Dec 7 14:04 1_21653_883154058.dbf
-rw-r----- 1 oracle oinstall 115K Dec 7 14:05 1_21654_883154058.dbf
-rw-r----- 1 oracle oinstall 112K Dec 7 14:06 1_21655_883154058.dbf
-rw-r----- 1 oracle oinstall 132K Dec 7 14:07 1_21656_883154058.dbf
-rw-r----- 1 oracle oinstall 208K Dec 7 14:08 1_21657_883154058.dbf
-rw-r----- 1 oracle oinstall 120K Dec 7 14:09 1_21658_883154058.dbf
-rw-r----- 1 oracle oinstall 79K Dec 7 14:10 1_21659_883154058.dbf
-rw-r----- 1 oracle oinstall 117K Dec 7 14:11 1_21660_883154058.dbf
-rw-r----- 1 oracle oinstall 157K Dec 7 14:12 1_21661_883154058.dbf
-rw-r----- 1 oracle oinstall 182K Dec 7 14:13 1_21662_883154058.dbf
-rw-r----- 1 oracle oinstall 173K Dec 7 14:14 1_21663_883154058.dbf
-rw-r----- 1 oracle oinstall 148K Dec 7 14:15 1_21664_883154058.dbf
原因分析:
Oracle 有一个机制,当dataguard中的primary节点和standby节点上REDO磁盘IO性能不足或者primary节点和standby节点间网络性能不足的时候,
primary节点会发生定期的internal incremental Recovery Checkpointing !
而这种定期的internal incremental Recovery Checkpointing会导致primary节点switch redo log
这是一种保护机制,自动调节每次redo的传输量,来最大的保证redo可以传输到standby节点上!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29289867/viewspace-1985482/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29289867/viewspace-1985482/