Oracle 19c Active Data Guard Switchover Procedure
Oracle 19c Active Data Guard Switchover Procedure Oracle Active Data Guard provides high availability and disaster recovery by allowing seamless role transitions between the primary and standby databases. A switchover is a planned role reversal where the primary database becomes the standby, and the standby takes over as the new primary without data loss. This guide covers the step-by-step procedure for switchover in Oracle 19c Active Data Guard . 1. Pre-Checks Before initiating a switchover, ensure both databases are synchronized and healthy. On both primary and standby : SELECT DATABASE_ROLE, OPEN_MODE FROM V$DATABASE; Primary should show: PRIMARY , READ WRITE Standby should show: PHYSICAL STANDBY , READ ONLY WITH APPLY or MOUNTED Also, confirm there are no active sessions or long-running transactions on the primary. 2. Verify Log Transport and Apply Ensure redo logs are being shipped and applied correctly. On Primary : SELECT DEST_ID, STATUS, ERRO...