Oracle Database 19c: Data Guard Administration Workshop — Lesson 4: Active Data Guard, Backup Offload, Troubleshooting, DR Testing, and Runbook

Technical Scope

• read-only standby, real-time query, block repair, and license awareness
• backup offload, standby backups, recovery catalog, and restore validation
• transport errors, gaps, apply failures, divergence, network issues, and diagnosis
• DR exercise planning, RTO and RPO evidence, rollback, lessons, and runbook

Instructor Demonstration

Demonstrate read-only standby, real-time query, block repair, and license awareness within a mission-critical Oracle Database protected by a physical standby across sites, validated for planned switchover, unplanned failover, data protection, and operational recovery, then capture the exact configuration, command, transaction, report, trace, or code evidence that proves the expected result.

Applied Workshop

Implement a controlled workshop covering backup offload, standby backups, recovery catalog, and restore validation and transport errors, gaps, apply failures, divergence, network issues, and diagnosis, then test a failure, exception, or business-control scenario involving DR exercise planning, RTO and RPO evidence, rollback, lessons, and runbook.

1. Confirm the environment, identities, data, dependencies, controls, and expected result.
2. Complete the product-specific configuration, development, analysis, or business-process task.
3. Capture commands, configuration, output, logs, transactions, reports, or test evidence.
4. Explain the operational, security, performance, data-quality, or business trade-off.

Validation Standard

The Active Data Guard, Backup Offload, Troubleshooting, DR Testing, and Runbook result must be reproducible, traceable to approved inputs, and consistent with expected Oracle product or business-process behavior.

• The intended target, scope, and ownership are verified.
• The result is supported by reproducible evidence and expected-value checks.
• Security, performance, reliability, data quality, and support impact are reviewed.
• Unexpected behavior is investigated before acceptance or release.

Failure Analysis

Diagnose issues in read-only standby, real-time query, block repair, and license awareness, backup offload, standby backups, recovery catalog, and restore validation, transport errors, gaps, apply failures, divergence, network issues, and diagnosis, or DR exercise planning, RTO and RPO evidence, rollback, lessons, and runbook without making an unverified production change.

Learners isolate the smallest proven cause, apply a reversible correction, rerun validation, and record the preventive action.

Practical Outcome

Complete a validated implementation or analysis for Active Data Guard, Backup Offload, Troubleshooting, DR Testing, and Runbook and defend the result with documented evidence.