My Oracle Support Banner

Switchover To Physical Standby without broker hangs. (Doc ID 1261877.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.Symptoms

Switchover attempt on a single instance primary to single instance physical standby without broker hangs without any errors.

It was verified that standby is in complete sync with primary.

All the pre-requisites like job_queue_processes was set to zero and scheduler was disabled etc.

alter database commit to switchover to physical standby with session shutdown;

stuck for more than 1 hour which normally takes about 1min at the most. No messages recorded in the alert log.


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

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