Required Network Bandwidth Transfer Of Redo In Data Guard

Based on primary database's redo generation rate we need calculate the required network bandwith.

How to calculate Redo rate.

Method 1:

We need run AWR report at periodic intervals. Please note down  "Per Second" value. Take the highest "Redo size" "Per Second" value from AWR report, and that is your peak redo generation rate.

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.7	0.1	0.00	0.00
DB CPU(s):	0.2	0.0	0.00	0.00
Redo size:	171,813.4	15,421.0
Logical reads:	6,451.7	579.1

 

Method 2:

Query v$sysmetric_history view to find redo generation per second.
select avg (value) from v$sysmetric_history where metric_name = 'Redo Generated Per Sec';

The formula used for calculation the network bandwidth is:

Required bandwith = ((Redo rate bytes per sec./0.7)*8) / 1,000,00


Example

Let us assume the redo rate is a 740 KB/sec.
Required bandwith = ((Redo rate bytes per sec./0.7)*8) / 1,000,000

Required bandwith = ((757760./0.7)*8) / 1,000,000
Required bandwith = 8.66 Mbps