Programming, Database, For Corporates, For Working Professionals

Oracle Database 19c: Data Guard Administration

Course Duration: 40 hours

Course Level: Intermediate

About Course

Language: English

Duration: 40 Hrs

Awarding Body: Oracle

Associated Exam: 1Z0-076

Course Description:

The Oracle Certified Professional, Oracle Database 19c: Data Guard Administrator certification is for Database Systems Administrators with responsibility for Disaster Recovery. Ideal candidates have 4 to 5 years of Database Administration with 2 to 3 years of Data Guard.

Preparing for the required exam gives you a thorough knowledge of Oracle Data Guard Administration. You gain skills and knowledge on Oracle Data Guard concepts, configuration, management, optimization and monitoring, data protection, HA, and disaster recovery. By passing this exam, a certified individual shows you have the ability to create a High Availability or Disaster Recovery solution for an Oracle Database ecosystem and gain knowledge of Workload offload capabilities available in Data Guard.

This certification challenges your knowledge and pushes the limits of your database skills and increases your value to your company and in the marketplace.

Pre-Requisite:

Oracle Database Administration 2019 Certified Professional (or)
Oracle Database 12c Administrator Certified Professional (or)
Oracle Certified Expert, Oracle Database 12c: Data Guard Administrator (or)
Oracle Database 11g Administrator Certified Professional

Course Objectives:

After taking this course, you should be able to:

Oracle Data Guard: Architecture (Overview)
Physical Standby Database: Redo Apply Architecture
Logical Standby Database: SQL Apply Architecture
Data Protection Modes
Data Guard Operational Requirements

Course Content:

Course Overview
Introduction to Oracle Data Guard
Oracle Net Services in a Data Guard Environment
Creating a Physical Standby Database by Using SQL and RMAN Commands
Managing Physical Standby Files After Structural Changes on the Primary Database
Using Oracle Active Data Guard: Supported Workloads in Read-Only Standby
Using Oracle Active Data Guard: Far Sync and Real-Time Cascading
Creating and Managing a Snapshot Standby Database
Creating a Logical Standby Database
Oracle Data Guard Broker: Overview
Creating a Data Guard Broker Configuration
Monitoring a Data Guard Broker Configuration
Configuring Data Protection Modes
Optimizing and Tuning a Data Guard Configuration
Performing Role Transitions
Using Flashback Database in a Data Guard Configuration
Enabling Fast-Start Failover
Backup and Recovery Considerations in an Oracle Data Guard Configuration
Enhanced Client Connectivity in a Data Guard Environment
Patching and Upgrading Databases in a Data Guard Configuration

Benefits of the course

The course enables professionals to design and implement robust high-availability and disaster recovery strategies through Oracle Data Guard configurations, minimizing downtime and protecting against data loss
Participants gain expertise in configuring and administering advanced features—such as Fast-Start Failover, Active Data Guard, Flashback, and Data Guard Broker—for automated role transitions and optimized performance
It prepares DBAs to deploy Data Guard in multitenant, RAC, and cloud environments, ensuring scalable, secure, and maintainable standby solutions
It equips learners with practical skills to create and manage physical, logical, and snapshot standby databases using tools like RMAN, DGMGRL, and Enterprise Manager
The program develops troubleshooting and tuning capabilities, including monitoring redo transport, resolving archive gaps, and optimizing disaster recovery operations