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.
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25USA
View courses
4949ce03-a10b-4bdd-b4d9-e843c3638f84
Oracle Database 18c Data Guard
Select your learning method
Learn essential skills
Course overview
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
Quote request
Please complete the form to ensure your quote is accurate and we will contact you soon.
For the best prices, get in touch!