Oracle Data Guard 19c

Introduction to Oracle Data Guard

• Basic components of Oracle Data Guard
• Physical and logical standby databases
• Benefits of implementing Oracle Data Guard

Creating a Physical Standby Database by Using Enterprise Manager Cloud Control

• Data Guard broker configuration
• Physical standby database
• Data Guard configuration
• Database properties
• Data Guard configuration

Oracle Net Services in a Data Guard Environment

• Basics of Oracle Net Services
• Client connectivity
• Data Guard best practice solutions

Creating a Physical Standby Database by Using SQL and RMAN Commands

• Primary database and Oracle Net Services
• Physical standby database

Using Oracle Active Data Guard

• Real-time query
• RMAN block change tracking
• Far Sync

Creating and Managing a Snapshot Standby Database

• Snapshot standby database
• Converting a snapshot standby database

Creating a Logical Standby Database

• Creating a logical standby database
• SQL Apply filtering

Oracle Data Guard Broker: Overview

• Data Guard broker architecture
• Data Guard broker components
• Benefits of the Data Guard broker
• Data Guard broker configurations
• Enterprise Manager
• DGMGRL

Creating a Data Guard Broker Configuration

• Monitoring a Data Guard Broker Configuration
• Enterprise Manager Cloud Control
• DGMGRL
• SQL

Configuring Data Protection Modes

• Describing the Data Protection Modes
• Changing the Data Protection Modes

Performing Role Transitions

• Database roles
• Switchover
• Failover

Using Flashback Database in a Data Guard Configuration

• Advantages of using Flashback Database
• Configuring Flashback Database

Enabling Fast-Start Failover

• Fast-start failover
• Fast-start failover configuration
• Observer
• Role changes
• Reinstating the primary database

Backup and Recovery Considerations in an Oracle Data Guard Configuration

• Recovery Manager (RMAN)
• Offload backups
• Recovering primary database

Enhanced Client Connectivity in a Data Guard Environment

• Client Connectivity in a Data Guard Environment
• Failover procedures

Patching and Upgrading Databases in a Data Guard Configuration

• Standby-First Patch Apply technique
• Traditional upgrade methods
• Rolling upgrades
• DBMS_ROLLING

Optimizing a Data Guard Configuration

• Monitoring configuration performance
• Redo transport
• SQL Apply

Oracle Database Exadata Cloud Service Overview

• Architecture and capabilities of Exadata Cloud Service
• Exadata Cloud Service and an on-premise Exadata implementation

Working within in a hands-on learning environment, guided by our expert team, attendees will learn to:

• Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
• Create and manage physical and logical standby databases
• Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
• Use Data Guard to achieve a highly available Oracle database
• Gain an understanding of Oracle Database Exadata Cloud Service

Machine based practical labs and exercises. Student machines are required.

• Basic understanding of Oracle Database principles
• Linux operating system fundamentals
• Basic understanding of PL/SQL and Triggers

This hands on course is geared for experienced Database Administrators who possess

• Basic understanding of Oracle Database principles
• Linux operating system fundamentals
• Basic understanding of PL/SQL and Triggers