Oracle Database 19c Data Guard - 4 days Online Classroom
3.450,00 EUR
- 4 days
Protect your Oracle databases against planned and unplanned downtime with the Oracle Database 19c Data Guard course. Designed for database professionals responsible for high availability and disaster recovery, this hands-on training teaches you how to build, configure, monitor, and manage Oracle Data Guard environments. You'll gain practical experience creating physical, logical, and snapshot standby databases, performing switchovers and failovers, using the Data Guard Broker, and implementing backup and recovery strategies with RMAN. By the end of the course, you'll have the skills to maintain resilient Oracle database environments that minimise downtime and ensure business continuity
Key Features
Language
Course and materials are in English
Level
Intermediate level
4 days (8 hours / day) live classroom
with accredited trainers
50+ recommended study hours
Exercises and solutions
Downloadable PDF documents with detailed content (slides, explanations)
Certificate
Certificate of completion available
Learning Outcomes
At the end of this course, you will be able to:
Learn
Learn how to safeguard Oracle databases using RMAN backup and recovery techniques.
Configure
Configure recovery catalogues, perform network-based restores, and implement reliable backup strategies. The course also covers Flashback Database, enabling you to quickly recover databases to an earlier point in time and minimise downtime caused by user errors or system failures.
Optimize
Develop the skills to optimize Oracle Data Guard performance by configuring redo transport, managing SQL Apply, and monitoring standby databases.
Perform
Practise performing switchovers and failovers, ensuring smooth role transitions between primary and standby databases while maintaining high availability and business continuity.
Discover
Discover how to deploy Oracle Data Guard efficiently using guided configuration tools and best practices.
Maintain
Perform rolling upgrades with logical and physical standby databases, allowing you to keep Oracle environments current while reducing downtime and maintaining database availability throughout the upgrade process.
Course timeline
Day 1: Oracle Data Guard Foundations
Lesson 01
- Understand Oracle Data Guard architecture, components, standby database types, and protection modes.
- Configure Data Guard environments, including primary and standby database requirements.
- Create and validate a physical standby database using SQL commands and network configuration.
- Manage standby database startup, recovery modes, and Active Data Guard features.
- Configure redo transport services with synchronous, asynchronous, and Fast Sync options.
- Implement redo apply services, cascading standby databases, and archive gap management.
Day 2: Building and Managing Data Guard
Lesson 02
- Manage database changes, including tablespaces, datafiles, redo logs, and nonlogged operations.
- Create standby databases using RMAN, Active Database duplication, and Oracle DBCA.
- Configure and administer Oracle Data Guard Broker using DGMGRL and Enterprise Manager.
- Build and validate Data Guard Broker configurations for primary and standby databases.
- Monitor Data Guard environments using diagnostic tools, validation commands, and performance views.
- Enable, manage, and automate Data Guard configurations for simplified administration.
Day 3: Backup, Recovery, and Role Transitions
Lesson 03
- Implement backup and recovery strategies for Oracle Data Guard using RMAN and Recovery Catalog.
- Configure Flashback Database to simplify recovery and support standby database operations.
- Manage Data Guard Broker settings, protection modes, Fast-Start Failover, and monitoring.
- Perform switchovers, failovers, and primary database reinstatement using SQL commands.
- Preserve application availability during role transitions with Application Continuity features.
- Create, convert, and manage Snapshot Standby databases for testing and reporting.
Day 4: Advanced Data Guard Administration
Lesson 04
- Create and manage logical standby databases with SQL Apply and real-time synchronization.
- Tune standby database performance by optimising redo transport, SQL Apply, memory, and network settings.
- Improve logical standby efficiency through statistics management and process optimisation.
- Perform rolling upgrades using logical or physical standby databases with minimal downtime.
- Configure Oracle Data Guard using Quick Setup best practices for rapid deployment.
- Manage switchovers, failovers, Active Data Guard, and snapshot standby environments for high availability.
Who Should Enroll in this Program?
Oracle Database Administrators (DBAs)
Database Infrastructure Engineers
Oracle Database Support Specialists
Disaster Recovery and High Availability Engineers
Oracle System Administrators
Technical professionals responsible for Oracle business continuity solutions
Prerequisites
- A good understanding of Oracle Database administration
- Basic Linux or UNIX administration knowledge
- Experience managing Oracle databases
- Knowledge equivalent to Oracle Database 19c Administration or Oracle Database 19c Backup and Recovery with RMAN
- Familiarity with Oracle networking and database architecture is beneficial.
Licensing
and equality policy
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.