Introduction
Oracle Data Guard plays a pivotal role in ensuring business continuity by maintaining synchronized standby databases that can seamlessly take over when the primary database is unavailable. Among its capabilities, the manual switchover process allows database administrators to transition roles between the primary and standby systems without data loss, ensuring minimal downtime during planned maintenance or load balancing. In this guide, we’ll walk through the step-by-step procedure to perform a manual switchover, discuss prerequisites, and share best practices to ensure a smooth transition.
ON PRIMARY DATABASE
ON STANDBY DATABASE
Prechecks before performing switchover
SELECT sequence#, first_time, next_time, applied FROM v$archived_log ORDER BY sequence#;
Changing the primary database to standby
Once take the database offline then again take the database in mount mode
