Posts

ORACLE GOLDENGATE

Image
       ORACLE GOLDENGATE Configuration & Architecture Guide Real-Time Data Replication for Oracle Database 19c   1. Overview Oracle GoldenGate is a real-time, log-based change data capture (CDC) and replication solution that enables high-availability, zero-downtime data integration between Oracle database environments. It works by reading transaction logs on the source database and applying those changes to a target database with minimal latency. This document covers the complete configuration of a GoldenGate replication pipeline including database preparation, Extract, Data Pump, and Replicat setup for the LOGIUSER schema tables.   1.1 Architecture Summary Component Process Name Host Port Extract shipep ipfix01.example.com 8706 (MGR) Data Pump shippump ipfix01.example.com 8706 (MGR) Re...

ORACLE DATA GUARD (Broker Configuration Guide)

ORACLE DATA GUARD Broker Configuration Guide Step-by-Step Setup & Switchover Procedures Primary: ORAP  |  Standby: ORAS 1. Pre-Configuration Checks   Before configuring the DataGuard Broker, verify the database role and switchover status on both the primary and standby databases.   1.1  Query Database Status Run the following SQL query on both PRIMARY and STANDBY:   -- Run on PRIMARY and STANDBY SELECT DB_UNIQUE_NAME, DATABASE_ROLE, SWITCHOVER_STATUS, OPEN_MODE FROM V\$DATABASE;   ℹ️  Confirm DATABASE_ROLE shows PRIMARY on the primary node and PHYSICAL STANDBY on the standby node before proceeding.   2. Enable DataGuard Broker   Enable the DataGuard Broker on both the PRIMARY and STANDBY databases by setting the DG_BROKER_START parameter.   2.1  Set DG_BROKER_START on Both Nodes -- Execute on PRIMARY AND STANDBY ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;...