Evolve your understanding and practical working knowledge of Oracle Data Guard and gain real-world skills to plan, implement, manage and troubleshoot standby database configurations. This course is ideal for professionals looking to boost their Oracle DBA capabilities ready to apply straight away in work projects.
Oracle Database 12cR2 Data Guard
Safeguard and optimise your Oracle databases with confidence
If you're responsible for database availability, this course is ideal for helping you acquire deeper Oracle knowledge. Over four proactive days, you’ll learn how to configure and manage Oracle Data Guard to reduce downtime and improve resilience. You’ll leave confident in your ability to keep systems running, even when complexities occur.
Learning objectives
- Set up physical standby databases
- Build logical and snapshot standby setups
- Use Redo and Apply services
- Manage role transitions
- Work with the Data Guard Broker
- Monitor and troubleshoot configurations
- Use flashback and recovery
- Apply patches and perform upgrades
What you’ll learn
This targeted course takes you through Oracle Data Guard step-by-step, from setup through to recovery. You’ll learn how to keep your database environment stable and secure using built-in tools and best practices, with plenty of proactive time to apply everything in our live labs.
Setting up standby databases
On this immersive course, we’ll show you exactly how to set up physical, logical and snapshot standby databases. You’ll practise setting up different types using SQL commands, RMAN and the DBCA, and we’ll guide you through every step. You’ll also learn how to get things working in multitenant setups, which is increasingly common in the real world. Whether you’re starting from a backup or cloning live, this course enables you to feel more comfortable with any relevant setup tasks.
Using the Data Guard Broker
Managing databases manually can be time consuming. The Data Guard Broker is an effective shortcut to easier setup and administration. On this course, you will be guided through how to use the system to configure, manage and monitor your Data Guard environment with ease. You’ll learn to use the command-line tool (DGMGRL), test everything’s working as it should, and even run scripts for increased efficiency.
Backups, recovery and flashback
In this module, you’ll learn how to confidently manage database backup and recovery operations using Oracle’s Recovery Manager (RMAN). We’ll guide you through practical steps to protect your data, recover from file loss, and minimise downtime using features such as Flashback Database and the Data Recovery Advisor. You’ll also explore how to restore control files, recover individual data blocks, and perform tablespace point-in-time recovery. Realistic scenarios help you build practical experience in resolving common challenges faced by database administrators, ensuring you’re prepared to maintain business continuity and data integrity in critical environments.
What’s included
- 4 days of live virtual classroom or classroom training
- Valuable practice using real-world backup and recovery scenarios
- Access to live labs for practical skill development
- Digital course resources to support ongoing learning
- StayAhead certificate of attendance
- Flexible private training options for teams
Key facts
Ideal for
DBAs and support teams who look after Oracle environments and want to improve their skills.
Prerequisites
It's advisable to have some working knowledge of Oracle Database admin and be confident working in Linux or UNIX. If you’ve done our Oracle Admin and RMAN Backup courses, you’ll have appropriate knowledge for the course.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one. (Do not change this copy)
FAQs
During this focused course, you’ll learn how to keep your Oracle databases protected and available using Data Guard. You’ll be offered targeted practice with setup, monitoring, recovery and more, and all in a relaxed, instructor-led environment.
Do I need to know Oracle before I take this course?
Yes, this course is aimed at people who already work with Oracle and understand the basics of database administration. You should feel comfortable navigating the system, working with SQL, and handling day-to-day DBA tasks. If you’re not quite there yet, we recommend taking our Oracle Admin and RMAN Backup & Recovery courses first. They’ll give you the solid foundation you need to get the most from this training.
Does the course cover Fast-Start Failover (FSFO)?
Yes. You’ll learn how to configure and manage FSFO using Data Guard Broker, allowing your systems to recover automatically from failures. This is especially valuable for DBAs managing critical systems requiring high availability.
Will I learn how to tune Oracle Data Guard for better performance?
Absolutely. The course includes a full module on tuning standby databases. You’ll cover network performance, Redo Apply tuning, SQL Apply optimisation, and even memory tuning for Logical Standby databases.
Can I practise database failover and switchover operations?
Yes. The course includes hands-on labs where you’ll perform both switchovers and failovers using SQL commands and the Data Guard Broker. This practical experience prepares you to respond confidently to real-time failures.
What our customers say
‘Excellent, very informative and useful.’
Simon, Digital Marketing Manager - Construction / Infrastructure
‘I really enjoyed this course, it was clear the instructor had in-depth knowledge about the subject and was keen on answering questions / explaining problems thoroughly. I also appreciated learning about the principles, best practice standards, and the reasoning behind these.’
Michaela, Data Scientist - 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