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 … [Read more...] about How To Calculate The Required Network Bandwidth Transfer Of Redo In Data Guard Environments
Data Guard
What are Oracle Data Guard Protection Modes (redo transport rules) and how to configure them
A Data Guard configuration always runs in one of three data protection modes (also called as redo transport rules): Maximum Protection Maximum Availability Maximum Performance (default mode of operation) All three modes provide a high degree of data protection, but they differ in terms of the effect that each has on the availability and performance of the primary database. Data Guard Protection modes The supported redo transport configurations for the 3 Data Guard Protection Modes … [Read more...] about What are Oracle Data Guard Protection Modes (redo transport rules) and how to configure them