My Oracle Support Banner

18c & 19c Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 2485237.1)

Last updated on MARCH 20, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and later
Information in this document applies to any platform.

Goal

 This Document explain about switchover steps for 18c and 19c

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 Prerequisites
 Latest psu/bundle patches
 Setup/configuration verification
 Verify Initialization Parameters
 Understand and Test Fallback Options
 Pre-Switchover
 Verify Redo/Archive log apply is good and there are no gaps
 Check the datafiles & Tempfiles status
 Online and standby redo logfile configuration
 Checking the alert logfiles
 Check Archive log GAP & Redo Delay apply
 Switchover
 Verify the switchover
 Switchover steps
 Post Switchover
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.