Our course teaches you to protect your databases from downtime. You’ll explore core architectural principles and gain practical skills in configuring, managing, monitoring and optimising physical, logical and snapshot standby databases. You’ll also cover change management, patching and upgrading to maintain high availability across Oracle versions 12cR2, 18c and 19c.
Oracle Database 18c Data Guard
Protect and optimise your Oracle databases with Data Guard
Gain the skills to use Oracle Data Guard to protect databases from downtime. Learn architecture and hands-on techniques for role changes, standby automation, change management, patching, upgrades and fast recovery. Ideal for DBAs, this practical course strengthens disaster recovery planning and operational confidence in Oracle environments.
Learning objectives
- Prepare a primary Oracle database for a Data Guard configuration
- Create and manage physical, logical and snapshot standby databases
- Monitor and administer environments for high availability
- Configure and use Redo Transport and Redo Apply services
- Perform role transitions, switchovers and failovers
- Set up and operate the Data Guard Broker
- Apply Flashback Database and RMAN in a Data Guard setup
- Optimise, troubleshoot and manage change in standby configurations
- Implement patching and upgrading procedures
What you’ll learn
Develop expertise in Oracle Data Guard to ensure database resilience. Learn to design and manage standby environments, configure redo transport, execute switchovers and failovers, apply flashback recovery, fine-tune performance, resolve issues, and implement structured change, patching and upgrades to sustain high availability.
Data Guard concepts
Gain a clear understanding of Oracle Data Guard’s core architecture, key terminology and data protection models. You’ll explore physical, logical and snapshot standby databases, role transitions, protection modes and multitenant setups. You’ll also understand how to align configurations with business needs to enhance resilience, ensure high availability and maintain continuity across both modern and legacy Oracle environments.
Creating and configuring standby databases
Learn how to set up Oracle standby databases using SQL, RMAN and DBCA, from preparing the primary database and duplicating files to configuring network parameters. You’ll gain the skills to create physical, logical and snapshot standby databases, implement multitenant scenarios, and apply best practices with troubleshooting techniques, ensuring highly available and resilient environments that are tailored to your organisation’s needs.
Managing and monitoring standby environments
Once your standby databases are configured, the focus shifts to maintaining, monitoring and optimising them for peak performance. You’ll work with Redo Transport and Apply services, configuring real-time apply, resolving archive gaps, and using Oracle views and diagnostic tools to validate configurations. The course also covers Flashback Database and RMAN strategies to ensure continuity and recoverability.
Automation with Data Guard Broker
Explore Oracle Data Guard Broker, the powerful management tool for automating Data Guard configurations. Work with both the DGMGRL command line and Oracle Enterprise Manager to build, validate and manage configurations, automate switchovers and failovers, and adjust protection modes. You’ll also cover troubleshooting with Broker diagnostics and advanced features such as Fast Start Failover and configuring multiple observers.
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
Database administrators and support staff responsible for implementing or managing Oracle Data Guard.
Prerequisites
Delegates should be experienced Oracle DBAs with knowledge of RMAN and Linux or Unix. Attendance on our Oracle Database and Linux Introduction 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
Explore the essential skills to set up and support Oracle Data Guard environments. This course covers standby database creation, configuration management, recovery techniques, performance tuning and automation, helping you keep business-critical systems resilient and protected.
What is Oracle Data Guard and why is it important?
Oracle Data Guard is a disaster recovery and high availability solution that maintains standby databases to protect against planned and unplanned downtime. It ensures continuous data protection, allows for fast recovery after failures, and supports business continuity across Oracle Database versions 12cR2, 18c, and 19c.
What Oracle Database versions does this training cover?
The Oracle Data Guard training supports multiple database versions, including Oracle 12cR2, 18c, and 19c. This ensures you gain versatile skills that can be applied across different Oracle environments, making the course relevant for organisations running mixed-version infrastructures or planning future database upgrades.
Is Data Guard covered in a multitenant environment?
Yes. You’ll learn how Data Guard interacts with Oracle Multitenant setups, including working with pluggable databases (PDBs). We demonstrate how to create, clone and manage standby configurations for containerised databases to support real-world Oracle 18c environments.
Does the course include using Data Guard Broker?
Yes, in depth. You’ll use the Data Guard Broker via both Enterprise Manager and the DGMGRL command-line tool. You’ll set up full configurations, manage switchover and failover tasks and automate routine Data Guard operations with confidence.
Can I attend this course if I’ve only worked with Oracle 12c?
Yes. The course builds on foundational DBA skills and knowledge from Oracle 12c is directly applicable. You’ll learn how to extend that foundation to Data Guard in 18c and 19c, making the transition to newer versions smoother and more informed.
What our customers say
“Thoroughly enjoyed the course, very informative and a good balance between instruction and practical work.”
Megan, StayAhead Learner - Transport
“Tarn is an excellent instructor. Everything was clearly communicated. One of the best courses I have attended in recent years.”
Simon, Senior DBA - Government
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs