Oracle Database Manual Switchover: A Comprehensive Guide Database high availability is critical for enterprise applications. Oracle's Data Guard provides robust disaster recovery capabilities, including the ability to perform planned switchovers between primary and standby databases. This blog post walks through the process of manually switching over from a primary database (DC) to a standby database (DR) and then switching back. Environment Details Primary Database (DC): testpri Standby Database (DR): testsby Pre-Switchover Verification Before initiating a switchover, it's essential to verify the current database state and ensure log shipping synchronization. Step 1: Check Active Sessions First, check for active database sessions that might be affected during the switchover: There should not be not active session, if there are any check with application team and kill those sessions. set time on col machine for a30 select MACHINE, count(*), status from v$session gr...