• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How To Calculate The Required Network Bandwidth Transfer Of Redo In Data Guard Environments

By admin

It’s important to transfer and apply redo as fast as possible in a Data Guard environment. To achieve this we have to calculate the required network bandwidth based on the redo generation rate on the primary database.

The formula used (assuming a conservative TCP/IP network overhead of 25%) for calculating the network bandwidth is:

Required bandwidth = ((Redo rate bytes per sec. / 0.75) * 8) / 1,000,000 = bandwidth in Mbps

Measuring the Peak Redo Rate

Use the Oracle Statspack utility for accurate measurement of the redo rate.

Based on your business you should have a good idea as to what your peak periods of normal business activity are. For example, you may be running an online store which historically sees the peak activity for 4 hours every Monday between 10:00 am – 2:00 pm. Or, you may be running a merchandising database which batch-loads a new catalog every Thursday for 2 hours between 1 am – 3 am. Note that we say “normal” business activity – this means that in certain days of the year you may witness much heavier business volume than usual, e.g. the 2-3 days before Mother’s Day or Valentine’s Day for an online florist business. Just for those days, perhaps you may allocate higher bandwidth than usual, and you may not consider those as “normal” business activity. However, if such periodic surges of traffic are regularly expected as part of your business operations, you must consider them in your redo rate calculation.

During the peak duration of your business, run a Statspack snapshot at periodic intervals. For example, you may run it three times during your peak hours, each time for a five-minute duration. The Statspack snapshot report will include a “Redo size” line under the “Load Profile” section near the beginning of the report. This line includes the “Per Second” and “Per Transaction” measurements for the redo size in bytes during the snapshot interval. Make a note of the “Per Second” value. Take the highest “Redo size” “Per Second” value of these three snapshots, and that is your peak redo generation rate.

Note that if your primary database is a RAC database, you must run the Statspack snapshot on every RAC instance. Then, for each Statspack snapshot, sum the “Redo Size Per Second” value of each instance, to obtain the net peak redo generation rate for the primary database. Remember that for
a RAC primary database, each node generates its own redo and independently sends that redo to the standby database – hence the reason to sum up the redo rates for each RAC node, to obtain the net peak redo rate for the database.

As an Alternative you can also get the ‘Redo rate bytes per sec.’ from V$SYSMETRIC_HISTORY, eg.

SQL> select * from v$sysmetric_history where metric_name = 'Redo Generated Per Sec';

or in a RDA-Output:

Performance - AWR Report - Statistic: "redo size" 

Example

Let us assume the redo rate is a 500 KB/sec.

Required bandwidth = ((Redo rate bytes per sec. / 0.75) * 8) / 1,000,000 = bandwidth in Mbps  
Required bandwidth = ((512000/0.75) * 8) /1,000,000 
Required bandwidth = 5.46 Mbps

Filed Under: Data Guard, oracle, RAC

Some more articles you might also be interested in …

  1. How to Recover DROPPED PDB After Flashback of CDB
  2. How to Roll Forward a standby database using RMAN incremental backup in 11g
  3. Beginners Guide to Working with spfile in Oracle ASM
  4. How to change static parameters through SPFILE parameter file in Oracle Database
  5. How to Install and configure OSWatcher Black Box (OSWbb)
  6. How to Recover A Dropped Tablespace Using TSPITR
  7. Script to monitor RMAN Backup and Restore Operations
  8. CentOS / RHEL 7 : How to set udev rules for ASM on multipath disks
  9. How to recreate Control file in Oracle Database
  10. How to set udev rule for setting the disk permission on ASM disks when using multipath on CentOS/RHEL 6

You May Also Like

Primary Sidebar

Recent Posts

  • What are Command Rules in oracle Database
  • Using Rule Sets in Oracle Database Vault
  • How Realms Work in Oracle Database Vault
  • How to use Privilege Analysis in Oracle Database
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary