Oracle 19c Active Data Guard Configuration on Linux – Step by Step
Oracle 19c Active Data Guard Configuration on Linux – Step by Step Oracle Active Data Guard provides high availability, data protection, and disaster recovery by maintaining a synchronized copy of the primary database on a standby system. In this guide, we will configure Oracle 19c Active Data Guard between two Linux servers. 1. Environment Setup Primary Database : primary.localdomain (192.168.0.187) Standby Database : standby.localdomain (192.168.0.188) Update /etc/hosts on both servers: 192.168.0.187 primary.localdomain primary 192.168.0.188 standby.localdomain standby Disable firewall & SELinux (if required): systemctl stop firewalld setenforce 0 2. Enable FORCE LOGGING & ARCHIVELOG Mode on Primary On the Primary Database : ALTER DATABASE FORCE LOGGING; ARCHIVE LOG LIST; If not in ARCHIVELOG mode: SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN ; 3. Configure Primary Initialization Parameters Update the paramete...