Oracle GoldenGate 12c: Advanced Configuration for Oracle Ed 1 — Lesson 3: High Availability, Planned Role Changes, and Recovery

Technical Scope

• Manager and process resilience, AUTOSTART, AUTORESTART, and watchdog patterns
• shared storage, cluster integration concepts, VIP, DNS, and endpoint continuity
• planned database role transition, GoldenGate repositioning, and service sequencing
• checkpoint safeguards, trail preservation, failover rehearsal, and fallback gates

Instructor Demonstration

The instructor will analyze and reconcile Manager and process resilience, AUTOSTART, AUTORESTART, and watchdog patterns in the context of a multi-database replication estate requiring scalable apply, selective routing, planned failover, and zero-guesswork recovery. The demonstration captures commands, configuration, transactions, output, logs, plans, or screenshots that prove both the intended behavior and the control boundary.

Applied Workshop

Learners complete a controlled exercise covering shared storage, cluster integration concepts, VIP, DNS, and endpoint continuity and planned database role transition, GoldenGate repositioning, and service sequencing, then introduce a realistic exception involving checkpoint safeguards, trail preservation, failover rehearsal, and fallback gates. They record assumptions, exact steps, expected and observed results, a reversible correction, and the evidence required for operational acceptance.

1. Confirm scope, identities, data, dependencies, controls, and expected result.
2. Perform the product-specific configuration, development, analysis, or business-process task.
3. Capture reproducible technical or transaction evidence and compare it with the expected value.
4. Explain the operational, security, performance, data-quality, or business trade-off.

Validation Standard

Acceptance for High Availability, Planned Role Changes, and Recovery requires the result to be reproducible, traceable to approved inputs, consistent with the relevant Oracle or platform behavior, and supported by checks for security, data integrity, reliability, performance, and recoverability.

• The intended target, scope, and ownership are verified.
• Expected-value and negative-path checks pass.
• Security, reliability, performance, data quality, and support impacts are reviewed.
• Unexpected behavior is resolved before acceptance.

Failure Analysis

When the result differs from expectation, learners isolate the smallest proven cause across Manager and process resilience, AUTOSTART, AUTORESTART, and watchdog patterns, shared storage, cluster integration concepts, VIP, DNS, and endpoint continuity, planned database role transition, GoldenGate repositioning, and service sequencing; they avoid speculative production changes, preserve evidence, apply the lowest-risk correction, rerun the test, and document prevention.

Practical Outcome

Complete and defend a validated result for High Availability, Planned Role Changes, and Recovery with a reusable implementation record or runbook.