Oracle Active Data Guard Oracle Active Data Guard increases performance, availability, data protection, and return on investment wherever Data Guard is used for real-time data protection and availability. An Oracle Active Data Guard standby database can be used to offload a primary database of reporting, ad hoc queries, data extracts, and backups, making it a very effective way to insulate interactive users and critical business tasks on the production system from the overhead of long-running … [Read more...] about How to Use real-time query to access data on a physical standby database
Data Guard
How to Create a Physical Standby Database by Using SQL and RMAN Commands
You perform the steps listed below when using SQL and RMAN commands to create a physical standby database. These are high level steps and are explained in detail later in the blog. Prepare the primary database. Set parameters on the physical standby database. Configure Oracle Net Services. Start the standby database instance. Execute the DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command. Start the transport and application of redo. Preparing the Primary … [Read more...] about How to Create a Physical Standby Database by Using SQL and RMAN Commands
How To Calculate The Required Network Bandwidth Transfer Of Redo In Data Guard Environments
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
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