Introduction: A switchover is a role reversal between the primary database and one of its standby databases. In this article we will see how to do Switchover activity in Logical Standby setup. Prerequisites: Logical standby should be configured and in sync. 30 mins downtime at database end. Environment: Server Primary Standby Hostname dcdb.oraeasy.com drdb.oraeasy.com OS OEL 9 OEL 9 SID ORADBDC ORADBDR Service Name ORADBDC ORADBDR Now proceed to Switchover activity step by step: 1. Check the sync between Primary and Standby. ==> Primary: SQL> select name,db_unique_name,database_role,open_mode from v$database; NAME DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE --------- ------------------------------ ---------------- -------------------- ORADB oradbd...