For individuals

Recorded Video Learning

  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Instructor Led Live Online Training

  • Live Interactive training
  • Certified & industry expert Trainers
  • On Demand Dedicated Cloud lab access
  • 24x7 Support & Assistance
  • Fast-track / Regular / Weekend

  • Start training at your convenient time
  • For business

    Corporate training

    • Self-paced e-learning and/or instructor-led options)
    • Course, category, and all-access pricing
    • Enterprise-class learning management system (LMS)
    • Enhanced reporting for individuals and teams
    • 24x7 assistance and support

    Course Details

    Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. It provides a comprehensive set of services that create, maintain, manage, and monitor standby databases and enables Oracle databases to survive disasters and data corruptions. Data Guard maintains these standby databases as transactionally consistent copies of the production database.

    Oracle Data Guard Training Overview

    We ensure training is completely packaged with all the concepts necessary. The training starts with an introduction to Data Guard and moves on to Creating a Physical Standby Database by Using SQL and RMAN Commands, Enterprise Manager Grid Control. The curriculum also covers ways of Using Flashback Database, Performing Backup and Recovery Considerations, Patching and Upgrading Databases, Monitoring and Optimizing a Data Guard Configuration.

    Oracle Data Guard Training Curriculum

    Causes of Data Loss
    Oracle Data Guard Architecture
    Types of Standby Databases (benefits of each type)
    Using the Data Guard Broker
    Differentiating Between Standby Databases and Data Guard Broker Configuration
    Data Protection Modes
    Performing Role Transitions

    Preparing the Primary Database
    Creating the Physical Standby Database

    Oracle Data Guard Broker Features
    Oracle Data Guard Broker Configurations
    Data Guard Monitor Process
    Data Guard Monitor Configuration Files
    Benefits of Using the Data Guard Broker
    Comparing Configuration Management With and Without the Broker
    Using DGMGRL

    Defining a Data Guard Configuration (overview)
    Setting up the Broker Configuration Files
    Setting the DG_BROKER_START Initialization Parameter to TRUE to start the Data Guard Broker
    Creating the Broker Configuration
    Adding the Standby Database to the Configuration

    Using Enterprise Manager Grid Control to Create a Physical Standby Database
    Using the Add Standby Database Wizard
    Verifying a Configuration
    Editing Standby database properties
    Viewing the Data Guard Configuration Status

    Monitoring the Data Guard Configuration by Using Enterprise Manager Grid Control Verifying the Configuration, Viewing Log File Details
    Using Enterprise Manager Data Guard Metrics
    Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
    Viewing Standby Redo Log Information
    Monitoring Redo Apply

    Snapshot Standby Database: Architecture
    Converting a Physical Standby Database to a Snapshot Standby Database
    Activating a Snapshot Standby Database: Issues and Cautions
    Viewing Snapshot Standby Database Information
    Converting a Snapshot Standby Database to a Physical Standby Database

    Using Real-Time Query
    Enabling and Disabling Real-Time Query
    Enabling Block Change Tracking on a Physical Standby Database
    Creating Fast Incremental Backups
    Monitoring Block Change Tracking

    Preparing to Create a Logical Standby Database
    Checking for Unsupported Objects, Data Types, and Tables
    Ensuring Unique Row Identifiers
    Creating the Logical Standby Using SQL Commands and Grid Control
    Securing your Logical Standby Database

    Contrast switchover vs. failover
    Preparing for a Switchover
    Performing a Switchover using DGMGRL and Enterprise Manager
    Types of Failovers
    Re-enabling Disabled Databases

    Overview of Flashback Database
    Configuring Flashback Database
    Using Flashback Database Instead of Apply Delay
    Using Flashback Database and Real Time Apply
    Flashback Through Standby Database Role Transitions
    Using Flashback Database After Failover

    Installing the Observer Software
    Configuring Fast-Start Failover
    Configuring Automatic Reinstatement of the Primary Database
    Initiating Fast-Start Failover from an Application
    Disabling Fast-Start Failover
    Starting and Stopping the Observer
    Moving the Observer to a new Host

    Understanding Client Connectivity in a Data Guard Configuration
    Preventing Clients from Connecting to the Wrong Database
    Creating Services for the Data Guard Configuration Databases
    Automating Client Failover in a Data Guard Configuration
    Automating Failover for OCI Clients
    Automating Failover for OLE DB Clients
    Configuring JDBC Clients for Failover

    Backup and Recovery of a Logical Standby Database
    Using the RMAN Recovery Catalog in a Data Guard Configuration
    Creating the Recovery Catalog
    Registering a Database in the Recovery Catalog
    Configuring Daily Incremental Backups
    Using a Backup to Recover a Data File on the Primary Database
    Recovering a Data File on the Standby Database

    Upgrading an Oracle Data Guard Broker Configuration
    Using SQL Apply to Upgrade the Oracle Database
    Performing a Rolling Upgrade by Using SQL Apply
    Performing a Rolling Upgrade by Using an Existing Logical Standby Database
    Performing a Rolling Upgrade by Creating a New Logical Standby Database
    Performing a Rolling Upgrade by Using a Physical Standby Database

    Monitoring the Data Guard Configuration by Using Enterprise Manager Grid Control Verifying the Configuration Viewing Log File Details
    Using Enterprise Manager Data Guard Metrics
    Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
    Viewing Standby Redo Log Information
    Monitoring Redo Apply

    Using Enterprise Manager Grid Control to monitor configuration performance
    Setting the ReopenSecs and NetTimeout database properties
    Compressing Redo Data
    Delaying the Application of Redo Data
    Optimizing SQL Apply
    Adjusting the Number of APPLIER and PREPARER processes


    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

    Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad,  San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…

    • Oracle Data Guard Training Washington, DC
    • Oracle Data Guard Training Virginia
    • Oracle Data Guard Training New Jersey
    • Oracle Data Guard Training Illinois
    • Oracle Data Guard Training North Carolina
    • Oracle Data Guard Training California
    • Oracle Data Guard Training Maryland
    • Oracle Data Guard Training Georgia
    • Oracle Data Guard Training Texas
    • Oracle Data Guard Training New York
    • Oracle Data Guard Training San Francisco
    • Oracle Data Guard Training Oregon
    • Oracle Data Guard Training Ohio
    • Oracle Data Guard Training Florida
    • Oracle Data Guard Training Seattle
    • Oracle Data Guard Training Chicago
    • Oracle Data Guard Training Dallas
    • Oracle Data Guard Training Los Angeles
    • Oracle Data Guard Training Baltimore
    • Oracle Data Guard Training Houston
    • Oracle Data Guard Training San Diego
    • Oracle Data Guard Training Santa Clara
    • Oracle Data Guard Training Columbus
    • Oracle Data Guard Training Towson
    • Oracle Data Guard Training Salt Lake City
    • Oracle Data Guard Training Austin
    • Oracle Data Guard Training Sunnyvale
    • Oracle Data Guard Training Franklin
    • Oracle Data Guard Training Orlando
    • Oracle Data Guard Training Boston
    • Oracle Data Guard Training San Jose
    • Oracle Data Guard Training St. Louis


    Course Reviews


    124 ratings
    • 587
    • 419
    • 312
    • 25
    • 11

    Drop Us A Query

    Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
    Course Adviser

    Fill your details, course adviser will reach you.