Course Outline
Introduction
Synopsis of Oracle Data Guard
- An introductory look at Oracle Data Guard and its underlying architecture
- The strategic value of Data Guard in disaster recovery and high availability scenarios
- Core elements: the primary database, standby databases, and the Data Guard broker
Data Guard Framework and Setup
- Exploring Data Guard configuration choices: physical, logical, and snapshot standby databases
- Managing role changes: switchover and failover procedures
- Data Guard services: redo transport, redo application, and query offloading
Deployment and Configuration of Data Guard
- Preparing the primary database to support Data Guard
- Setting up the network environment required for Data Guard
- Establishing and configuring physical and logical standby databases
Administering the Data Guard Broker
- An overview of the Data Guard broker architecture
- Configuring and overseeing the Data Guard broker
- Automating Data Guard tasks via the Data Guard broker
Supervision and Administration of Data Guard
- Tracking Data Guard configurations using the broker and Oracle Enterprise Manager
- Overseeing redo transport and redo application services
- Managing roles and executing switchover and failover actions
Backup and Recovery Strategies in Data Guard Setups
- Backup tactics for both primary and standby databases
- Restoring a primary database utilizing a standby database
- Utilizing RMAN within a Data Guard context
Performance Adjustment and Optimization
- Enhancing the performance of redo transport and application
- Tuning Data Guard settings for peak performance
- Addressing network and storage factors specific to Data Guard
Resolving Data Guard Challenges
- Typical Data Guard issues and their solutions
- Leveraging diagnostic tools and logs for effective troubleshooting
- Recommended practices for maintaining healthy Data Guard environments
Sophisticated Data Guard Capabilities
- Introduction to Active Data Guard and its associated features
- Deploying Data Guard in conjunction with Oracle RAC
- Utilizing Data Guard within multitenant frameworks (CDB and PDBs)
Data Guard and Disaster Recovery Strategy
- Designing and executing disaster recovery plans using Data Guard
- Combining Data Guard with Oracle Cloud for disaster recovery purposes
- Recommended configurations for Data Guard disaster recovery
Protecting Data Guard Environments
- Applying security best practices to Data Guard
- Setting up SSL to secure Data Guard communications
- Controlling user roles and permissions within Data Guard setups
Recommended Practices for Data Guard Administration
- Best practices for high availability and disaster recovery
- Automating Data Guard workflows and monitoring processes
- Guaranteeing data consistency and integrity across Data Guard environments
Recap and Future Directions
Requirements
- A foundational grasp of Oracle database administration principles
- Proficiency in SQL and PL/SQL
Target Audience
- Database Administrators
- IT Specialists
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4350 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
