Oracle Data Guard 12c | 19c Certification Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

4627 Reviews 4.9

Learners : 1080

Duration :  25 Days

About Course

These standby databases are kept up to date by our Oracle Data Guard as replicas of the production database. Then, if a scheduled or accidental failure renders the production database unavailable, Oracle Data Guard can move any standby database to the production role, minimizing the outage’s associated downtime. To offer a high level of data protection and availability, Oracle Data Guard can be used in conjunction with conventional backup, restore, and cluster procedures. Enrol today to earn your certification.

Oracle Data Guard Training Course Syllabus

Introduction to Oracle Data Guard

✔ What Is Oracle Data Guard?
✔ Types of Standby Databases
✔ Types of Data Guard Services
✔ Role Transitions: Switchover and Failover
✔ Oracle Data Guard Broker Framework
✔ Choosing an Interface for Administering a Data Guard Configuration
✔ Oracle Data Guard: Architecture(Overview)
✔ Primary Database Processes

Networking for Oracle Data Guard

✔ Networking Overview
✔ Listener.ora Configuration
✔ Statics vs. Dynamic Registration
✔ Static Entries for Database Duplication and SQL Maintenance
✔ Static Entries for Broker Operations
✔ Oracle Network Configuration Tuning
✔ tnsnames.ora Configuration

Creating a Physical Standby Database by Using SQL and RMAN Commands

✔ Steps to Create a Physical Standby Database
✔ Preparing the Primary Database
✔ Configuring Standby Redo Logs
✔ Creating Standby Redo Logs
✔ Using SQL to Create Standby Redo Logs
✔ Viewing Standby Redo Log Information
✔ Setting Initialization Parameters on the Primary Database to Control Redo Transport

Oracle Data Guard Broker: Overview

✔ Oracle Data Guard Broker: Features
✔ Data Guard Broker: Components
✔ Data Guard Broker: Configurations
✔ Data Guard Broker: Management Model
✔ Data Guard Broker: Architecture
✔ Data Guard Monitor: DMON Process
✔ Benefits of Using the Data Guard Broker
✔ Comparing Configuration Management With and Without the Data Guard Broker

Creating a Data Guard Broker Configuration

✔ Data Guard Broker: Requirements
✔ Data Guard Broker and the SPFILE
✔ Data Guard Monitor: Configuration File
✔ Data Guard Broker: Log Files
✔ Creating a Broker Configuration
✔ Defining the Broker Configuration and the Primary Database Profile
✔ Adding a Standby Database to the Configuration
✔ Enabling the Configuration

Creating a Logical Standby Database

✔ Benefits of Implementing a Logical Standby Database
✔ Logical Standby Database: SQL Apply Architecture
✔ SQL Apply Process: Architecture
✔ Preparing to Create a Logical Standby Database
✔ Unsupported Objects
✔ Unsupported Data Types
✔ Checking for Unsupported Tables
✔ Checking for Tables with Unsupported Data Types

Creating and Managing a Snapshot Standby Database

✔ Snapshot Standby Databases: Overview
✔ Snapshot Standby Database: Architecture
✔ Converting a Physical Standby Database to a Snapshot Standby Database
✔ Activating a Snapshot Standby Database: Issues and Cautions
✔ Snapshot Standby Database: Target Restrictions
✔ Viewing Snapshot Standby Database Information
✔ Using DGMGRL to View Snapshot Standby Database Information
✔ Converting a Snapshot Standby Database to a Physical Standby Database

Using Oracle Active Oracle Data Guard

✔ Oracle Active Data Guard
✔ Using Real-Time Query
✔ Checking the Standby’s Open Mode
✔ Understanding Lag in an Active Data Guard Configuration
✔ Monitoring Apply Lag: V$DATAGUARD_STATS
✔ Setting a Predetermined Service Level for Currency of Standby Queries
✔ Configuring Zero Lag Between the Primary and Standby Databases

Configuring Data Protection Modes

✔ Data Protection Modes and Redo Transport Modes
✔ Maximum Protection Mode
✔ Maximum Availability Mode
✔ Maximum Performance Mode
✔ Comparing Data Protection Modes
✔ Setting the Data Protection Mode by Using DGMGRL
✔ Setting the Data Protection Mode

Performing Role Transitions

✔ Role Management Services
✔ Role Transitions: Switchover and Failover
✔ Switchover
✔ Preparing for a Switchover
✔ Performing a Switchover by Using DGMGRL
✔ Considerations When Performing a Switchover to a Logical Standby Database
✔ Situations That Prevent a Switchover

Using Flashback Database in a Data Guard Configuration

✔ 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
✔ Using Flashback Database After RESETLOGS
✔ Flashback Through Standby Database Role Transitions

Enabling Fast-Start Failover

✔ Fast-Start Failover: Overview
✔ When Does Fast-Start Failover Occur?
✔ Installing the Observer Software
✔ Fast-Start Failover Prerequisites
✔ Configuring Fast-Start Failover
✔ Setting the Lag-Time Limit
✔ Configuring the Primary Database to Shut Down Automatically
✔ Automatic Reinstatement After Fast-Start Failover
✔ Backup and Recovery Considerations in an Oracle Data Guard Configuration
✔ Using RMAN to Back Up and Restore Files in a Data Guard Configuration
✔ Offloading Backups to a Physical Standby
✔ Restrictions and Usage Notes

Backup and Recovery of a Logical Standby Database

✔ Using the RMAN Recovery Catalog in Oracle DataGuard Configuration
✔ Creating the Recovery Catalog Registering a Database in the Recovery Catalog
✔ Setting Persistent Configuration Settings
✔ Monitoring a Data Guard Broker Configuration
✔ Viewing the Data Guard Configuration Status

Monitoring Oracle Data Guard Performance

✔ Viewing Log File Details
✔ Oracle DataGuard Metrics
✔ Managing Data Guard Metrics
✔ Viewing Metric Value History

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

Oracle Data Guard Training - Upcoming Batches

7th NOV 2022



Coming Soon



5th NOV 2022



Coming Soon



Don't find suitable time ?


Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

Oracle Data Guard Training FAQ'S

What are the advantages of using Oracle Data Guard?

The following are the different benefits of using the Oracle Data Guard feature in your environment.

  1. High Availability.
  2. Data Protection.
  3. The off-loading Backup operation to standby database.
  4. Automatic Gap detection and Resolution in standby database.
  5. Automatic Role Transition using Data Guard Broker.
What are the different services available in Oracle Data Guard?

The following are the different Services available in the Oracle Data Guard of the Oracle database.

  • Redo Transport Services.
  • Log Apply Services.
  • Role -Transitions.
What are the different Protection modes available in Oracle Data Guard?

Below are the protection modes available in DG

  1. Maximum Protection
  2. Maximum Availability
  3. Maximum Performance => This is the default protection mode. It provides the highest level of data protection that is possible without affecting the performance of a primary database. This is accomplished by allowing transactions to commit as soon as all redo data generated by those transactions has been written to the online log.
How to check what protection mode of the primary database in your Oracle Data Guard?


Get ahead in your career by learning Oracle DataGuard through VISWA Online Trainings

What are the advantages of using a physical standby database in Oracle Data Guard?
  1. High Availability.
  2. Load balancing (Backup and Reporting).
  3. Data Protection.
  4. Disaster Recovery.


Vishnu Gadipudi
Vishnu Gadipudi
I Enrolled in VISWA Online Trainings for IBM Integration BUS course . Recently I Completed IBM Integration BUS Batch. It was Really Awesome Experience. Best Place To Learn , Experienced Trainer, Gives Us High Level Knowledge....
Navya Biradavolu
Navya Biradavolu
I was enrolled for looker Bl Tool,it was amazing experience . especially soft skill batch is one of my favourite batch . overall learning process is quite impressive.
Indla sneha
Indla sneha
I have joined I have joined VISWA Online TRAININGS for Java full stack course and i have completed Advance Java module. I had a good knowledge of Hibernate, spring,spring boot,spring MVC. Tutor has knowledge in depth and is supportive. Srinadh sir solved all our doubts....
bindu hima
bindu hima
I am recently completed Talend course and trainer is Rajendra very professional and helpful. All the doubts were solved in a precise manner.
Tarunasree Gowra
Tarunasree Gowra
"I truly enjoyed this course." Chaitanya sir fantastic-very knowledgeable. Sir give us very informative and clear instruction on how to achieve the goal. Thank you!
Tejaswini Kommu
Tejaswini Kommu
Overall Linux Admin sessions batch was very good. Mr. RAM Krishna teaching was very helpful to remind our basic concepts in linux & networking.
Gopanaboina Mounika
Gopanaboina Mounika
It was great learning with such a great and experienced staff. Praveen Sir (Oracle EPM Cloud - FCCS) was very helpful and operations team also very helpful in solving any minor problems students go through process.
Jyothi Gutlapalli
Jyothi Gutlapalli
I like to share my experience which provide lots of courses and one of those I recently completed my Salesforce BA Course and I like to tell you it was a great experience and my knowledge and confidence is really boosted after completing this course.
Good experience and great learning platform for Hyperion Essbase and Planning. The faculty is also well trained and soft spoken.
Chaitu Viswa
Chaitu Viswa
It was very good session for QlikView. I would like to thank to teacher Mr.Chandu for providing guidance for the required modules. Thanks VISWA Team for giving apportunity to leran new skills.

Quick Links