Oracle Data Guard 12c | 19c Training

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews 4.9

Learners : 1080

Duration :  25 Days

About Course

Our Oracle Data Guard maintains these standby databases as copies of the production database. Then, if the production database becomes unavailable because of a planned or unplanned outage, Oracle Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. Oracle Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability. Enroll now and get certified in it.

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.


vishal meda
vishal meda
They give trainings properly and trainers are well versed with them where i recommend to all viswa trainings are good!!
Ntr fan
Ntr fan
I just finished sap bods training in Hyderabad. Excellent course and curriculum 100% doubt clarification sessions. Thanks Chaitanya
Shiva Krishna
Shiva Krishna
I recently completed informatica online training with Chaitanya. Course was built by excellent trainer. And process of learning was streamlined. Thanks
Mohammad ali syed
Mohammad ali syed
It was great and smooth understandable training. You can learn lots.
Govinda Bhatia
Govinda Bhatia
Not recommended as there will be no server access working to do practical after training. Also there will be no fix for the same. So it's wastage of money. If server access not at all working then no meaning to provide server access. Also it not working for single day properly. Need to followup daily but in response you told will fix that sir at home once he will back will fix. After he came back again it's not working and not able to fix for single day also Every time new excuse it's wastage of money.
M Leela mohan
M Leela mohan
I took SQL Server and MSBI Online training with Murali Krishna. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with VISWA Online Trainings.
Attended live Virtual training for IoT Trainer was very good. He had excellent knowledge of IoT and was very good at explaining concepts in detail.…
Lakshmi Lakshmi
Lakshmi Lakshmi
Best sap commerce cloud and Spartacus training institute in india. He provides a great mix of listening, speaking, and practical learning activities and a very safe, supportive learning environment. He maintains a friendly relationship with the students during class. He not only teaches but also monitors our practice status on daily basis.
Ch Chandranath
Ch Chandranath
I have undergone Oracle Tuning training. I can proudly say that this is one of the best training institutes available in the market. The way Mr. Kumar teaches the concepts and makes them understandable is very commendable and unique. Even a novice can clearly understand the concepts clearly after attending his classes.

Quick Links