Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
Overview of Oracle Data Guard
- Introduction to Oracle Data Guard and its architecture
- Benefits of using Data Guard for disaster recovery and high availability
- Key components: primary database, standby database, and Data Guard broker
Data Guard Architecture and Configuration
- Understanding Data Guard configuration options: physical, logical, and snapshot standby databases
- Role transitions: switchover and failover operations
- Data Guard services: redo transport, redo apply, and query offloading
Installing and Configuring Data Guard
- Preparing the primary database for Data Guard
- Configuring the network environment for Data Guard
- Creating and configuring physical and logical standby databases
Managing Data Guard Broker
- Introduction to Data Guard broker architecture
- Configuring and managing Data Guard broker
- Automating Data Guard operations with Data Guard broker
Monitoring and Managing Data Guard
- Monitoring Data Guard configuration using Data Guard broker and Oracle Enterprise Manager
- Managing redo transport and redo apply services
- Role management and performing switchover and failover operations
Backup and Recovery in Data Guard Environments
- Backup strategies for primary and standby databases
- Recovering a primary database using a standby database
- Using RMAN in a Data Guard environment
Performance Tuning and Optimization
- Optimizing redo transport and apply performance
- Configuring Data Guard for optimal performance
- Managing network and storage considerations for Data Guard
Troubleshooting Data Guard Issues
- Common Data Guard issues and resolutions
- Using diagnostic tools and logs for troubleshooting
- Best practices for maintaining Data Guard environments
Advanced Data Guard Features
- Introduction to Active Data Guard and its features
- Implementing Data Guard with Oracle RAC
- Using Data Guard in multitenant environments (CDB and PDBs)
Data Guard and Disaster Recovery Planning
- Planning and implementing disaster recovery strategies with Data Guard
- Integrating Data Guard with Oracle Cloud for disaster recovery
- Best practices for Data Guard disaster recovery configurations
Securing Data Guard Environments
- Implementing security best practices for Data Guard
- Configuring SSL for secure Data Guard communications
- Managing user roles and privileges in Data Guard environments
Best Practices for Data Guard Administration
- High availability and disaster recovery best practices
- Automating Data Guard operations and monitoring
- Ensuring data consistency and integrity in Data Guard environments
Summary and Next Steps
Requirements
- Basic understanding of Oracle database administration
- Familiarity with SQL and PL/SQL
Audience
- Database administrators
- IT professionals
21 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from £5700 online delivery, based on a group of 2 delegates, £1800 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
The exercises were explained very good.
Monica - DB Global Technology
Course - PL/SQL in Oracle 19c
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
It was quite hands-on, not too much theory.
