This course gives you the expertise you need to effectively plan, implement and manage Oracle Data Guard configurations. Over four days, you’ll learn how to build database resilience and advance your skills in disaster recovery.
Oracle Database 19c Data Guard
Safeguard business critical systems with Oracle Data Guard
Discover the functions and benefits of Oracle Data Guard, a powerful tool for database protection. Through guided exercises in our live labs, you’ll learn how to set up, manage and troubleshoot standby databases, equipping you to maintain system availability and resilience in any scenario.
Learning objectives
- Configure Oracle Data Guard environments
- Create and manage standby databases
- Use Data Guard Broker effectively
- Monitor and tune standby setups
- Troubleshoot configuration issues
- Perform database role transitions
- Manage backups with RMAN
- Implement Flashback Database
- Handle upgrades and patching
What you’ll learn
Starting with its architecture and progressing to the practical creation of physical, logical and snapshot standby databases, this course will give you a solid understanding of Oracle Data Guard. Through practical exercises, you’ll learn how to use the Data Guard Broker and apply effective strategies for monitoring, troubleshooting and recovery.
Data Guard architecture
The course begins with a clear overview of Oracle Data Guard and its core components. You’ll explore how data is transported and applied across different standby database types, including physical, logical and snapshot configurations. You’ll also examine how Data Guard operates within multitenant environments. This foundation gives you a strong understanding of the architecture and the role each element plays in maintaining availability and system performance.
Creating standby databases
You’ll learn how to build physical, logical and snapshot standby databases using a mix of tools, from SQL commands to RMAN and the dbca. We’ll walk you through the steps needed to prepare your primary environment, configure synchronisation settings, and ensure your standby databases are ready to support failover when required.
Using Data Guard Broker
Once your standby setup is in place, the Data Guard Broker makes its management easier. You’ll learn how to use Oracle’s built-in tools to monitor your configuration, switch roles between primary and standby, and automate common tasks. We’ll cover both the command-line interface and the graphical options, so you’ll know what to use and when.
What’s included
- 4 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
Key facts
Ideal for
DBAs and technical teams who need to set up, manage or troubleshoot Oracle Data Guard.
Prerequisites
Linux Introduction, Oracle Database 19c Administration, or Oracle Database 19c Backup and Recovery with RMAN. An equivalent knowledge of Linux and Oracle database administration will also be accepted.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Plan, build and manage Oracle Data Guard environments. Learn to reduce downtime, maintain resilience, and handle real-world database challenges with confidence.
What is Oracle Data Guard?
Oracle Data Guard is a high availability and disaster recovery solution that creates and manages standby copies of your primary Oracle database. It ensures data integrity and business continuity by automatically replicating changes and enabling fast failover in the event of planned maintenance or unexpected outages. This makes it a vital tool for minimising downtime, protecting critical data, and maintaining service availability across enterprise environments.
Which versions of Oracle does this course support?
The course focuses on Oracle Database 19c, which is Oracle’s current long-term support release and widely used in enterprise environments. That said, we also reference features and behaviours from earlier versions, 12cR2 and 18c, where relevant. This gives you a broader understanding and the flexibility to support a range of systems in your organisation, especially if you’re managing mixed-version environments.
Do I need to know Linux to take part?
Yes, having a working knowledge of Linux or UNIX is important because the course is delivered on a Linux-based platform. You’ll be using command-line tools and editing configuration files, so being comfortable navigating the file system and understanding basic commands will make the course much easier to follow. If you’re new to Linux or want to refamiliarise yourself with the platform, we recommend completing our Linux Introduction course first.
What our customers say
"Very knowledgeable instructor, well paced, not rushed. Everything was explained clearly."
Kimberley, Community Risk Reduction IT Systems – Fire
‘John is an exceptional teacher. His teaching style, clarity, and support have made a lasting impact on my learning journey.’
Mihai, Junior Developer - Outsourcing
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