DATAGUARD 估算业务高峰redo传送网络的带宽
计算公式 (assuming a conservative TCP/IP network overhead of 30%) 保守有30%的网络开销为TCP/IP开销
那么,DATAGUARD的redo 带宽则为:
DG redo需要带宽 = ((Redo rate bytes per sec. / 0.7) * 8) / 1,000,000 = bandwidth in Mbps
估算网络开销,需要在生产系统的业务高峰期间,每隔一段时间运行AWR的快照。至少在业务高峰时段运行三次(因每个系统不同自行度量),每次的AWR snap的间隔十五分钟的时间。
在awr报告中"Load Profile"下的 "Redo size" 这一行包含了“Per Second”和“Per Transaction”对redo 以字节为单位的测量,记下的"Per Second"的值。就确定了最高的“重做大小”这三个快照“每秒”的价值,那就是你的高峰redo的生成率。
如果是一套RAC系统,那么需要在相同的业务高峰时段为每个节点都运行AWR报告,在RAC主数据库中,每个节点生成自己redo并独立发送重做到备用数据库 -
因此,综合每个RAC节点的redo size,来确定RAC系统业务高峰的重做率
或者,也可以从V$ SYSMETRIC_HISTORY中得到每秒redo 速率字节。“
例:
SQL> select * from v$sysmetric_history where metric_name = 'Redo Generated Per Sec';
BEGIN_TIM END_TIME INTSIZE_CSEC GROUP_ID METRIC_ID METRIC_NAME VALUE METRIC_UNIT
--------- --------- ------------ ---------- ---------- ------------------------ ---------- -----------------
31-MAY-13 31-MAY-13 6004 2 2016 Redo Generated Per Sec 0 Bytes Per Second
31-MAY-13 31-MAY-13 6002 2 2016 Redo Generated Per Sec 172.60913 Bytes Per Second
31-MAY-13 31-MAY-13 6003 2 2016 Redo Generated Per Sec 11.7274696 Bytes Per Second
31-MAY-13 31-MAY-13 6002 2 2016 Redo Generated Per Sec 0 Bytes Per Second
31-MAY-13 31-MAY-13 6003 2 2016 Redo Generated Per Sec 12.3271697 Bytes Per Second
31-MAY-13 31-MAY-13 6902 2 2016 Redo Generated Per Sec 0 Bytes Per Second
31-MAY-13 31-MAY-13 9003 2 2016 Redo Generated Per Sec 262.445851 Bytes Per Second
31-MAY-13 31-MAY-13 9003 2 2016 Redo Generated Per Sec 8.70820837 Bytes Per Second
31-MAY-13 31-MAY-13 9003 2 2016 Redo Generated Per Sec 95.434855 Bytes Per Second
31-MAY-13 31-MAY-13 9004 2 2016 Redo Generated Per Sec 119.680142 Bytes Per Second
31-MAY-13 31-MAY-13 9004 2 2016 Redo Generated Per Sec 57.8409596 Bytes Per Second
例:
如果业务高峰的redo size 是 300 KB/sec.
那需求的带宽应该为
DG redo带宽 = ((Redo rate bytes per sec. / 0.7) * 8) / 1,000,000 = bandwidth in Mbps
= ((307200/0.7) * 8) /1,000,000
= 3.51 Mbps
DATAGUARD 估算业务高峰redo传送网络的带宽
最新推荐文章于 2024-03-03 18:06:15 发布