Oracle Database 19c: Data Guard Training

This comprehensive training on Oracle Database 19c: Data Guard equips you with the skills needed to protect your Oracle database from both planned and unplanned downtime. Delivered by expert Oracle instructors, the course demonstrates how Data Guard ensures high availability, disaster recovery, and data protection.

Key Learning Outcomes:

– Build highly available database systems using Data Guard.
– Offload business processing and backup tasks to standby systems.
– Gain insight into Oracle Database Exadata Cloud Service.

Benefits to You:

By the end of this course, you’ll understand how to leverage Oracle Data Guard to create and manage standby databases. These databases can support various production functions like reporting, querying, and testing. You will also learn about the latest features in Oracle Data Guard 19c, including Active Data Guard, Far Sync, rolling upgrades, and snapshot standby databases, empowering you to manage and troubleshoot Data Guard configurations efficiently.

Course Overview:

1. Introduction to Data Guard:

– What is Oracle Data Guard?
– Maximum Availability Architecture (MAA)
– Standby Database Types: Physical, Logical, and Snapshot
– Data Guard Architecture, Services, and Protection Modes

2. Creating a Physical Standby (SQL & RMAN):

– Preparing the Primary Database
– Configuring Standby Redo Logs and Log Files
– Setting up the Standby Database using SQL and RMAN
– Real-Time Apply and Lost Write Detection

3. Data Guard Broker Overview:

– Data Guard Broker Components and Architecture
– Benefits of Using Data Guard Broker
– DGMGRL Commands and Enterprise Manager Integration

4. Data Guard Broker Configuration:

– Configuration Files and Log File Management
– Setting and Changing Database Properties

5. Configuring Data Protection Modes:

– Maximum Protection, Availability, and Performance Modes
– Using Enterprise Manager to Set Protection Modes

6. Monitoring Data Guard Configuration:

– Monitoring Data Guard Status and Performance
– Viewing Diagnostic Information and Log Files

7. Optimizing Data Guard Configuration:

– Optimizing Redo Transport and Transmission
– Using Flashback Database in a Data Guard Environment

8. Performing Role Transitions:

– Switchover and Failover Procedures Using DGMGRL and Enterprise Manager
– Troubleshooting Role Transitions and Re-enabling Disabled Databases

9. Backup and Recovery Considerations:

– Offloading Backups to a Physical Standby
– RMAN Recovery for Data Guard Configurations

10. Managing Client Connectivity:

– Automating Client Failover and Managing Services
– OCI, OLE DB, and JDBC Client Connections in Data Guard

11. Patching & Upgrading in a Data Guard Environment:

– Upgrading with Physical Standby and Rolling Upgrade Workflow