Oracle Database 19c: Data Guard Administration Workshop

This course teaches you how to use Oracle Data Guard, and how this solution protects your Oracle database against planned and unplanned downtimes.

Learn To:

  • Build highly available systems.
  • Offload business processing needs to another system.
  • Offload backup needs to another system.
  • Gain an understanding of Oracle Database Exadata Cloud Service.

Benefits to You:

You'll walk away from this course with an understanding of how Data Guard standby databases can be used to support various production functions. These functions include reporting, querying and testing, while in a standby role.

This course will also teach you about the new Oracle Data Guard 12c features and architecture. You'll get a chance to explore topics like Oracle Active Data Guard, Far Sync, rolling upgrades and snapshot standby databases. Furthermore, enrolling in this course will help you learn how to manage and troubleshoot a Data Guard configuration.


Administrators, Database Administrators, Implementers


  • Basic understanding of PL/SQL and Triggers
  • Familiarity with database administration.

Course topics

1 - Introduction to Oracle Data Guard
2 - Oracle Net Services in a Data Guard Environment
3 - Creating a Physical Standby Database by Using SQL and RMAN Commands
4 - Managing Physical Standby Files After Structural Changes on the Primary Database
5 - Using Oracle Active Data Guard: Supported Workloads in Read-Only Standby
6 - Using Oracle Active Data Guard: Far Sync and Real-Time Cascading
7 - Creating and Managing a Snapshot Standby Database
8 - Creating a Logical Standby Database
9 - Oracle Data Guard Broker: Overview
10 - Creating a Data Guard Broker Configuration
11 - Monitoring a Data Guard Broker Configuration
12 - Configuring Data Protection Modes
13 - Optimizing and Tuning a Data Guard Configuration
14 - Performing Role Transitions
15 - Using Flashback Database in a Data Guard Configuration
16 - Enabling Fast-Start Failover
17 - Backup and Recovery Considerations in an Oracle Data Guard Configuration
18 - Enhanced Client Connectivity in a Data Guard Environment
19 - Patching and Upgrading Databases in a Data Guard Configuration


Other relevant courses

5 days
Virtual Classroom On Demand
3 days
Virtual Classroom On Demand
28. October
3 days
Virtual Classroom
5 days
Classroom Virtual On Demand