• 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

Data Guard

How to Use real-time query to access data on a physical standby database

By admin

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

Filed Under: Data Guard, oracle, oracle 12c

How to Create a Physical Standby Database by Using SQL and RMAN Commands

By admin

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

Filed Under: Data Guard, oracle, oracle 12c

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 … [Read more...] about How To Calculate The Required Network Bandwidth Transfer Of Redo In Data Guard Environments

Filed Under: Data Guard, oracle, RAC

What are Oracle Data Guard Protection Modes (redo transport rules) and how to configure them

By admin

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

Filed Under: Data Guard, oracle

Primary Sidebar

Recent Posts

  • How to disable ACPI in CentOS/RHEL 7
  • How to Use real-time query to access data on a physical standby database
  • CentOS/RHEL 8: “ACPI MEMORY OR I/O RESET_REG” Server Hung after reboot
  • How to Create a Physical Standby Database by Using SQL and RMAN Commands
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary