Oracle Data Guard Administration

Module 1: Introduction to Oracle Data Guard

• Overview of Oracle Data Guard
• Data Guard architecture: Primary and standby databases
• Data Guard protection modes: Maximum protection, availability, performance
• Physical vs. logical standby databases
• Data Guard use cases: Disaster recovery, high availability, reporting

Module 2: Data Guard Architecture

• Redo log shipping mechanism
• Log apply services: MRP and SQL Apply
• Data Guard broker overview
• Observer for fast-start failover
• Data Guard in Oracle RAC environments

Module 3: Setting Up Physical Standby

• Prerequisites for Data Guard setup
• Primary database preparation
• Creating physical standby using RMAN
• Standby redo log configuration
• Initial synchronization and verification

Module 4: Data Guard Broker Configuration

• Data Guard Broker architecture
• DGMGRL command-line interface
• Creating and enabling broker configuration
• Managing primary and standby with broker
• Broker health checks and status

Module 5: Redo Transport Services

• Log writer (LGWR) vs. archiver (ARCn) transport
• Synchronous vs. asynchronous redo transport
• Network configuration for redo transport
• Compression and encryption of redo
• Monitoring redo transport lag

Module 6: Log Apply Services

• Managed recovery process (MRP)
• Real-time apply configuration
• Apply lag monitoring
• Parallel apply for performance
• Resolving apply gaps

Module 7: Logical Standby Databases

• Logical standby architecture and SQL Apply
• LogMiner and dictionary build
• Supported and unsupported data types
• Filtering tables and schemas
• Reporting on logical standby

Module 8: Active Data Guard

• Active Data Guard license features
• Read-only standby with real-time apply
• Far sync instance configuration
• Automatic block repair
• Offloading backups to standby

Module 9: Switchover and Failover

• Planned switchover process
• Graceful failover steps
• Fast-start failover (FSFO) configuration
• Observer setup and management
• Post-failover reinstatement

Module 10: Data Guard Monitoring

• V$ views for Data Guard monitoring
• Data Guard status and lag reports
• Broker show configuration output
• Oracle Enterprise Manager for Data Guard
• Alert log monitoring for Data Guard events

Module 11: Data Guard in Oracle Cloud (OCI)

• Data Guard on OCI VM and Bare Metal
• OCI Data Guard setup automation
• Cross-region Data Guard on OCI
• Autonomous Data Guard overview
• Hybrid Data Guard: On-premises to OCI

Module 12: Real-Time Projects and Case Studies

• Enterprise disaster recovery implementation
• Data Guard switchover testing
• End-to-end Data Guard administration
• Certification and interview preparation

Experience in the Industry Gain knowledge from experts with hands-on Oracle Data Guard administration experience in enterprise disaster recovery and high availability programs.

Backgrounds at the Top Prominent corporations such as HCL, TCS, Accenture, and Oracle Consulting employ our Data Guard trainers.

Clear & Effective Teaching Excellent communication and real-world examples simplify complex redo transport and failover concepts.

Hands-On Learning Focus Students apply skills using live Oracle environments with real Data Guard setup and failover projects.

Up-to-Date Knowledge Trainers stay current with Oracle Data Guard 19c/21c, Active Data Guard, and OCI Data Guard deployments.