Modern Oracle DBA

s This guide explains how to stop and start Oracle GoldenGate Extract, Replicat, and Manager processes using the GGSCI command-line interface in a classic architecture setup. Checking Current GoldenGate Process Status Use the following command to view the status of all GoldenGate processes: GGSCI> info all Example output: Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT19EBS 00:00:04 00:00:08 EXTRACT RUNNING EXT19TST 00:00:03 00:00:07 EXTRACT RUNNING PMP19EBS 00:00:00 00:00:00 EXTRACT RUNNING PMP19TST 00:00:00 00:00:09 Stopping Extract Processes Syntax GGSCI> stop extract <extract_name> Example GGSCI> stop EXTRACT EXT19EBS GGSCI> stop EXTRACT PMP19EBS Verify GGSCI> info all Example output: Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EXT19E...

Purpose This guide describes a step-by-step approach to perform a switchover in an Oracle Data Guard configuration. Prerequisites Primary and Standby are healthy and synchronized. Both databases are under clusterware control. SYSDBA connectivity is available. Application services are stopped before switchover. Environment Details Primary Database  PRD_CDB Standby Database  STBY_CDB Primary Server  PRD_NODE1 Standby Server  STBY_NODE1 Switchover Procedure (With Actual Output) 1. Remove DelayMins (if configured) DGMGRL> connect sys/<password> DGMGRL> show database PRD_CDB delaymins; DGMGRL> edit database PRD_CDB set property 'DelayMins'='0'; DGMGRL> show database PRD_CDB delaymins; Sample Output: DelayMins = '180' Property "DelayMins" updated...