Oracle 19c Data Guard Switchover Procedure – Step-by-Step Guide
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...