My Oracle Support Banner

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

Last updated on JANUARY 26, 2024

Applies to:

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


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


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
 Latest psu/bundle patches
 Setup/configuration verification
 Verify Initialization Parameters
 Understand and Test Fallback Options
 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
 Verify the switchover
 Switchover steps
 Post Switchover

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