Posts

Showing posts with the label #DR

Building an Enterprise-Grade Oracle 19c RAC-to-RAC Data Guard with Broker

Image
A practical, end-to-end walkthrough of standing up a 2-Node RAC physical standby for a 2-Node RAC primary — covering architecture, network and parameter prerequisites, RMAN active duplication, RAC conversion of the standby, redo apply, Data Guard Broker, and switchover/failover readiness. Database: Oracle 19c (19.16) Enterprise Edition Topology: 2-Node RAC → 2-Node RAC Physical Standby Storage: ASM (+DATA, +RECO, +OCRVD)              Container: CDB test with PDB testpdb 1. Why RAC-to-RAC Data Guard? Oracle Data Guard remains Oracle's reference-grade solution for database disaster recovery and high availability. It ships redo from a primary database to one or more standbys, applies it in real time, and orchestrates role transitions so that planned maintenance and unplanned outages do not translate into downtime for the business. When the primary database itself already runs on Real Application Clusters (RAC), pairing it with a RAC physical standby ...

Oracle 26ai Data Guard & Data Guard Broker

Image
  A Complete Step-by-Step Implementation Guide — RAC Primary to Standalone Physical Standby on ASM Oracle Data Guard remains Oracle's flagship enterprise solution for High Availability (HA) and Disaster Recovery (DR). This guide walks through a real, end-to-end Oracle 26ai implementation that connects a 2-node RAC primary running on ASM to a standalone physical standby — including parameter setup, RMAN duplication, Data Guard Broker configuration, and a successful switchover. It also highlights what is genuinely new in 26ai Data Guard. Table of Contents Introduction — Why Data Guard Still Matters Architecture Overview Objectives of This Implementation Prerequisites & Readiness Checklist Primary Database Configuration Initialization Parameters & Standby Redo Logs Network Configuration (hosts, tnsnames, listener) Password File & PFILE Setup Creating the Standby with RMAN Duplicate Starting Redo Apply Verification & Real-Time Apply Test Data Guard Broker Configurat...