Oracle Database 18c Data Guard

Select your learning method

Overview Learning objectives What you’ll learn Key facts FAQs What our customers say Get in touch

Learn essential skills

Course overview

Learn how to keep your Oracle databases running without disruption with our Oracle Database 18c Data Guard course. Gain an understanding of key architectural concepts and develop essential skills to set up, administer, monitor and tune physical, logical and snapshot standby databases for Oracle versions 12cR2, 18c and 19c.

Strengthen database resilience with proven Data Guard strategies

Learn how to leverage Oracle Data Guard to protect Oracle databases from planned and unexpected downtime. Build skills to maintain continuous availability, manage role transitions, streamline standby operations, restore systems after outages, and apply change management, patching and upgrade techniques. Designed for DBAs, it strengthens disaster recovery readiness for confidently managing Oracle environments.

Learning objectives

Configure a primary Oracle database for an Oracle Data Guard deployment
Build, maintain and optimise physical, logical and snapshot standby databases
Monitor, manage and fine-tune environments to ensure high availability
Implement and administer Redo Transport and Redo Apply services
Execute database role transitions, including switchovers and failovers
Configure and manage Oracle Data Guard Broker operations
Utilise Flashback Database and RMAN as part of Data Guard strategies
Diagnose, resolve and manage change within standby configurations
Apply patching and upgrade processes to maintain system stability

What you’ll learn

Build your expertise in Oracle Data Guard to maintain high database availability. Gain practical skills in designing and administering standby environments, managing redo transport, performing role transitions, integrating flashback recovery, optimising performance, troubleshooting issues, and applying structured change, patching, and upgrade processes to support business continuity.

Configuring Redo Transport and Apply Services

Learn how to configure Oracle Data Guard redo transport in both synchronous and asynchronous modes, ensuring efficient and reliable data transfer. Manage archive gaps, handle transmission errors, and apply redo data effectively. This module also covers cascading standby databases and advanced features such as Fast-Sync to deliver maximum protection and high availability.

Change management in Oracle Data Guard

Gain the skills to implement structural changes in an Oracle Data Guard environment while maintaining stability and consistency. You’ll work with tasks such as adding or dropping tablespaces, renaming datafiles, and modifying redo log configurations. The focus is on applying best practices to minimise downtime, protect data integrity, and keep standby databases in sync with production systems.

Performance tuning for standby databases

Optimise Oracle Data Guard performance for both physical and logical standby databases. Learn to fine-tune redo transmission, SQL apply, memory allocation, and process configuration for maximum efficiency. You’ll also use diagnostic tools and troubleshooting techniques to resolve bottlenecks, maintain transaction consistency, and ensure your standby systems run at peak performance under varying workloads.

Patching and upgrading Data Guard environments

Understand the process of applying patches and performing rolling upgrades within an Oracle Data Guard configuration. You’ll explore prerequisites, learn methods for upgrading both logical and physical standby databases, and apply techniques to minimise downtime. By the end of the course, you’ll be able to confidently maintain currency and security while avoiding unnecessary service disruption.

What’s included

Four days of instructor-led training in a live virtual classroom
Interactive hands-on live labs
All relevant course materials

Key facts

Ideal for

IT professionals and DBAs who plan, deploy or manage Oracle Data Guard configurations in enterprise environments.

Prerequisites

Delegates should be comfortable with Oracle database administration, RMAN backup, and Linux or Unix systems. Prior attendance on equivalent ILX courses is recommended.

Learning experience

Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one

FAQs

Designed for experienced professionals, this course covers configuration, recovery and performance optimisation in Oracle Data Guard. Explore how to streamline system resilience, automate database roles, and meet enterprise continuity demands across a variety of business and infrastructure needs.

What will I learn in the Oracle Data Guard course?

You’ll gain skills in designing, configuring, and managing Oracle Data Guard environments. Topics include physical, logical, and snapshot standby databases, redo transport and apply services, Data Guard Broker automation, performance tuning, change management, patching, upgrades, flashback recovery, and troubleshooting to ensure continuous availability and disaster recovery readiness.

What prerequisites are needed for this Oracle Data Guard training?

A working knowledge of Oracle Database Administration is required, along with experience in backup and recovery using RMAN. Familiarity with Linux or UNIX operating systems is essential. These skills can be gained through recommended prerequisite courses in Oracle administration, RMAN backup and recovery, and Linux fundamentals.

How will this Oracle Data Guard course help my organisation?

By implementing the strategies taught in this course, you can minimise downtime, enhance disaster recovery capabilities, and maintain high availability for critical systems. The skills learned help improve operational efficiency, ensure compliance with business continuity requirements, and protect against costly data loss events.

How much practical experience will I get?

Practical learning is fundamental to the course. Learners will spend extensive time in virtual labs that mirror real-world Oracle environments. You’ll install, configure, and monitor Data Guard components, perform switchovers and failovers, troubleshoot issues, and recover lost files. Each lab builds operational confidence, ensuring you can apply disaster recovery and high-availability techniques immediately in production systems.

Will I learn best practices for disaster recovery planning?

Yes. You’ll learn how to integrate Oracle Data Guard into a robust disaster recovery strategy, covering role configuration, replication policies, failover procedures, and achieving RPO/RTO objectives. The course also covers flashback technologies, validation methods, and safe testing practices, enabling you to design resilient Oracle environments aligned with compliance and governance requirements.

What our customers say

“Very well laid out and John does an amazing job of explaining things in detail.”

Ali, Operations Technical Service Analyst – Utilities

“The lecturer was amazing - so passionate and knowledgeable, which made the sessions really enjoyable and easy to follow. I learned a lot and felt supported throughout. I would recommend StayAhead trainings to my colleagues.”

Kamila, Data Administrator - Retail / Hire

Why study with ILX

500,000+ learners

Join the half a million learners developing their skills with our training

5,000+ businesses

A trusted partner to thousands of organisations worldwide

96% customer satisfaction

Our passionate team goes above and beyond to support customer needs