Oracle Data Guard

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions.


    What you will learn?

    This Oracle Database 11g: Data Guard Administration Release 2 training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. Explore how Data Guard standby databases can be used to support production functions such as reporting, querying and testing, while in a standby role.

    Learn To:

      • Offload business processing needs to another system
      • Offload backup needs to another system
      • Build highly available systems
      • Offload business processing needs to another system

    Benefits to You

    Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

    Data Guard Architecture

    This course explores Data Guard architecture, the configuration of physical and logical standby databases and role transitions. Expert instructors will also help you explore Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases.

    Oracle Data Guard Course Highlights:

      • Use Data Guard to achieve a highly available Oracle Database
      • Describe the Data Guard architecture.
      • Modify the Data Guard Services
      • Use the Data Guard Broker
      • Implement physical and logical standby databases
      • Perform failover and switchover operations
      • Enable fast-start failover.


      • Create and manage physical and logical standby databases
      • Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
      • Use Enterprise Manager Grid Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
      • Use Data Guard to achieve a highly available Oracle database


      • Support Engineer
      • Technical Consultant
      • Database Administrators

    Database Administrator Job Growth

    DBAs play an important and responsible role in every company’s Information Technology (IT) department. DBAs are also very well paid and the average annual salary is more than $100,000 in the USA.

    Among all the IT/computer best jobs in a recent CNN.com Best Jobs in America report, Database Administrator job has the highest job growth forecast (30% increase) for the next 10 years until 2023.

    Introduction to Oracle Data Guard

      • Causes of Data Loss
      • Oracle Data Guard Architecture
      • Types of Standby Databases
      • Using the Data Guard Broker
      • Data Protection Modes
      • Performing Role Transitions

    Creating a Physical Standby Database by Using SQL and RMAN Commands

      • Preparing the Primary Database
      • Creating the Physical Standby Database

    Oracle Data Guard Broker

      • 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

    Creating a Data Guard Broker Configuration

      • Defining a Data Guard Configuration
      • 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
      • Creating a Logical Standby Database
      • Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
      • Viewing Standby Redo Log Information
      • Monitoring Redo Apply

    Creating a Logical Standby Database

      • Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
      • Viewing Standby Redo Log Information
      • Monitoring Redo Apply

    Creating and Managing a Snapshot Standby Database

      • 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 Oracle Active Data Guard

      • 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

    Configuring Data Protection Modes

      • 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
      • Securing your Logical Standby Database

    Performing Role Transitions

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

    Using Flashback Database in a Data Guard Configuration

      • 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

    Enabling Fast-Start 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

    Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration

      • 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

    Optimizing a Data Guard Configuration

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

    We record every live session we hold. Video recordings of each and every session will be posted on our blog too. So, this means you can get access to what the session is about and this way you do not miss any class. But take a note of it that you can have access to these Video recordings for 6 months only from the date you start your training. Access to these videos or to other required course material will be provided using Google Drive Cloud for lifetime.

    Yes, you can cancel your enrolment. We provide a complete refund after deducting the administration fee. To know more, please go through our Refund Policy.

    We have a team of industry-expert instructors or trainers who possess 8-10 yrs. of relevant experience in various Business Technologies. Every instructor / trainer undergo our specialized training program called “Train the Trainer” at Xoomtrainings. Our trainers are trained so that our learners get a great learning experience.

    Yes, classes at Xoomtrainings are conducted through online video streaming where there is two-way communication between users and instructors. The users can speak by using a microphone, chat by sending a message through a chat window and share their screens with an instructor. For better understanding, users can take the sample recorded class on this page to know of the quality of instruction and the way the class is conducted.

    Yes, the instructor will allocate you a real-time project to have a clear understanding of how you are able to conceptualize and implement the real-world application of the course content.

    Yes, we run multiple offers from time-to-time. Please, contact the support team they will give the Coupon Code.

    Yes, we will give you a discount of Rs 1500/- on selected course if you refer someone. We also offer special discount for groups.

    Yes, we will provide you the links of the software to download (trial version) which are open source and for proprietary tools we will provide you trial version, if available.

    For your practical work, we will help you set up a Virtual Machine on your system with IDE’s. This will be local access for you. The detailed step-wise installation guides are present in your LMS which will help you install and set-up the environment for any course. In case, you come across any doubt, the 24/7 support team will promptly assist you through mail (support@xoomtrainings.in) or Phone (+91 -40-4018 3355)

    4 Mbps of internet speed is recommended to attend LIVE classes. However, we have seen people attending the classes with a much slower internet connection too.

    Yes. You will receive a Digital E-Certificate from us once you complete the course. You can include this is in your Resume to get placed better.

    Xoomtrainings is the largest online education company and a large number of recruitment firms contacts us for our student’s profiles from time-to-time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placement. However, if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

    No doubt, your transaction is always safe and secure with Xoomtrainings.

    You will get 24/7 access to the blog to post your questions. Trainers will answer your questions through email within 24 hrs. of time. Also, our support team will help you 24/7 through mail (support@xoomtrainings.in) or Phone (+91-40-4018 3355 ,7093502091,92 ).

    You can give us a CALL at INDIA: +91-40-4018 3355 ,7093502091,92  Or Email at contact@xoomtrainings.in


    Tab Content

    Course Reviews

    No Reviews found for this course.

    • Rs.38,000.00
    • 30 Hours

    Course Features

    Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

    Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

    Xoomtrainings certified based on your project performance, reviewed by our expert panel

    Xoomtrianings enjoys strong relationship with multiple staffing companies in US, UK and India. If you are looking out for exploring Placement opportunities, you can pass your resumes once you complete the course and we will help you with job assistance. We don’t charge any extra fees for passing the resume to our partners and clients

    Course Enquiry

    © 2015 - 2016 Xoom Trainings powered by Innovin IT Solutions Pvt.LTD..All Rights Reserved.
    There are no courses Added to Cart