Oracle Database 19c: Data Guard Administration Workshop

Course Description

Oracle Database 19c: Data Guard Administration Workshop develops practical capability in administration of Oracle Data Guard 19c including physical standby creation, redo transport, apply, broker, switchover, failover, Active Data Guard, monitoring, troubleshooting, and disaster recovery. The learning path is organized around a mission-critical Oracle Database protected by a physical standby across sites, validated for planned switchover, unplanned failover, data protection, and operational recovery.

Learners progress from architecture, process, or business understanding into configuration, development, analysis, validation, troubleshooting, and operational handoff. Every lesson uses the controls, tools, data structures, risks, failure modes, and decisions relevant to this exact Oracle pathway.

What You Will Learn

• Explain and apply Data Guard roles, protection modes, redo flow, standby redo logs, and services within Oracle Database 19c: Data Guard Administration Workshop.
• Configure, validate, or troubleshoot primary prerequisites, FORCE LOGGING, parameters, listener, and connectivity, RMAN duplicate or backup-based physical standby creation and validation, and redo transport destinations, synchronous and asynchronous modes, gaps, and checks using course-specific evidence.
• Explain and apply managed recovery, real-time apply, archive apply, delay, and apply services within Oracle Database 19c: Data Guard Administration Workshop.
• Configure, validate, or troubleshoot Data Guard Broker configuration, properties, validation, and command-line workflow, transport lag, apply lag, process views, alert logs, and threshold monitoring, and maintenance, parameter changes, patch coordination, and role-aware procedures using course-specific evidence.
• Explain and apply switchover readiness, execution, service movement, and post-role validation within Oracle Database 19c: Data Guard Administration Workshop.
• Configure, validate, or troubleshoot failover scenarios, data loss assessment, activation, and application checks, flashback database, reinstate, rebuild, and recovery after role transition, and observer, fast-start failover, thresholds, services, TAF or FAN awareness using course-specific evidence.
• Explain and apply read-only standby, real-time query, block repair, and license awareness within Oracle Database 19c: Data Guard Administration Workshop.
• Configure, validate, or troubleshoot backup offload, standby backups, recovery catalog, and restore validation, transport errors, gaps, apply failures, divergence, network issues, and diagnosis, and DR exercise planning, RTO and RPO evidence, rollback, lessons, and runbook using course-specific evidence.

SkillDynamo Training Approach

The training follows a mission-critical Oracle Database protected by a physical standby across sites, validated for planned switchover, unplanned failover, data protection, and operational recovery. Activities combine product-specific demonstrations, guided implementation, hands-on exercises, scenario analysis, validation checklists, structured troubleshooting, solution review, and a final improvement plan. Learners document assumptions, settings, commands or transactions, outputs, exceptions, corrective actions, security and governance trade-offs, rollback needs, and operational ownership.