My Oracle Support Banner

ORA-16216 Signalled During: ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE NEW PRIMARY (Doc ID 2798915.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

After downgrade the primary database while executing the below statement in the logical standby, it fails

Downgrade database with logical standby in place.

Changes

Upgrade primary database where there are one more logical standby database configured and then downgrade the primary db. Then again upgrade the primary db for testing without making sure the logical standby is in sync with primary and then downgrade the primary again. Now when trying to start the apply on logical standby, it fails.

Cause

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
Symptoms
Changes
Cause
Solution
References


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