Oracle Data Guard Training | Online Certification Course

Key Highlights

+1 930 200 4823

( Toll Free )

30 Hrs Instructor Led Training

Self-paced Videos

20 Hrs Project & Exercises

Certification

Job Assistance

Flexible Schedule

Lifetime Free Upgrade

Mentor Support

Curriculum

A complete index of
job-ready skills curated
to meet the industrial need.
Explore.

Introduction to Oracle Data Guard

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

Creating a Physical Standby Database by Using SQL and RMAN Commands

Preparing the Primary Database
Creating the Physical Standby Database

Oracle Data Guard Broker: Overview

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 (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

Creating a Physical Standby Database by Using Enterprise Manager Grid Control

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

Creating a Logical Standby Database

Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying 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

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 and Grid Control
Securing your Logical Standby Database

Performing Role Transitions

Contrast switchover vs failover
Preparing for a Switchover
Performing a Switchover using DGMGRL and Enterprise Manager
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

Managing Client Connectivity

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

Patching and Upgrading Databases in a Data Guard Configuration

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 a Data Guard Configuration

Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying 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

Optimizing a Data Guard Configuration

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

We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.

Project Details

We bring you the best learning experience by delivering all our training sessions practical. Following are the few use cases we shall discuss during the training.

Oracle Data Guard Training Objectives

1. What are the Oracle Data Guard Training course objectives?

Upon the course completion, the trainee will be able to:

Understand Oracle Data Guard architecture and its concepts
Create, manage, and monitor Physical and Logical Standby databases
Implement Data Guard Broker and control its functions
Implement Oracle Active Data Guard
Use RMAN in a Data Guard environment
Ensure success with a first-time failover database implementation
Gain knowledge about how to use Data Guard Recovery Manager
Understand Troubleshooting Techniques and Tips in Data Guard
Working with scripts to perform Data Guard administration and Monitoring
Implement Rolling Upgrade using DBMS_ROLLING
Understand the advanced options in the Oracle Data Guard

2. Why should you learn Oracle Data Guard Training?

Many top companies are incorporating Oracle Data Guard in their deployments, and this created more demand for professionals working on Oracle Data Guard worldwide.
Certified Oracle Data Guard developers are earning high salaries compared to professionals working on other technologies.
The average salary of a certified Oracle Data Guard professional is $124,444 per annum.

3. Who should attend the Oracle Data Guard training?

Oracle Database Administrators
Individuals interested in learning Oracle Data Guard

4. What are the prerequisites for learning Oracle Data Guard?

Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.

5. What projects are included in this Oracle Data Guard course?

The tutor will take care of handling the projects. We will provide two real-time projects with a highly-skilled guide who can assist you throughout the project.

+1 930 200 4823

( Toll Free )

Training Options

Different individuals. Different upgrade goals. Different modes of learning.

We got solutions for everyone looking for an AWS Architect course. Opt in for your convenient upgrade option, and we will guide you through.

Duration

One-on-one Session

Support

Resources

Time

Fee

Live Online.

30 Hours

Yes

24x7

Additional tips from the trainer

30 July 2024, 07:00 AM

03 August 2024, 08:00 AM

Self-Paced

30 Hours

Weekdays & Working Hours

Accessible through LMS

At your convenience

Oracle Data Guard Training Upcoming Batches

Weekday

30 July 2024 to 30 August 2024

07:00 AM

Weekend

03 August 2024 to 03 September 2024

08:00 AM

Weekday

06 August 2024 to 06 September 2024

07:00 AM

Weekend

10 August 2024 to 10 September 2024

07:30 AM

Schedules Doesn't Suit You ?

Our Team can set up a batch at your convinient time.

Corporates Training

Experience and witness the express transformation of your workforce from the world-class tech upgrade platform.

Customized training options

Tailored curriculum to fit your project needs.

Practical exposure is assured.

We have got everything covered for any IT upgrade for your organization. We are one click away.

Success Stories from Future Digital Leaders

Hi, I’m Teena, enrolled for Oracle Data Guard course at Tekslate. The trainer taught all the concepts thoroughly and clarified and answered all the questions. Thanks to the trainer for making this course so exciting. Thank you Tekslate.

Tina

I am feeling delighted with this course and thanks to the Tekslate providing such good trainers, and I get a good subject knowledge on all the Oracle Data Guard concepts.

Spandana

Tekslate is the best place to learn Oracle Data Guard course at an affordable price with best course content. Trainers are highly experienced and certified professionals.

Rohith

Oracle Data Guard Training FAQ'S

Have questions? We’ve got the answers. Get the details on how you can grow in this course.

1. Who are the trainers?

We have a strong team of professions who are experts in their fields. Our trainers are highly supportive and render a friendly working environment to the students positively stimulating their growth.

2. What if I miss a class?

We will share you the missed session from our recordings. We at Tekslate maintains a recorded copy of each live course you undergo.

3. How will I execute the practical?

Our Trainers will provide the student with the Server Access ensuring practical real-time experience and training with all the utilities required for the in-depth understanding of the course.