High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

EE Question on rolling upgrade with Logical DB 12.1 to 12.2

I'm trying to do a rolling upgrade as a TEST, using Transient Logical standby. I've done it before with a primary and a standby. Now, the set up is 3 databases:

DEN_PRIMARY

ASH_Physical_stdby

ASH_logical_standby(existing logical standby with slightly different structure)

both Primary and physical_standby point to ASH_logical_standby with log_archive_dest_3. The ASH_logical_standby log_archive_dest_2 goes to Primary, log_archive_dest_3 goes to physical standby.

I've approached this a few ways, but on my latest approach I was able to update all three databases to 12.2, but the SQL apply did not work from the new primary(ASH_Physical_stdby) to the existing logical standby(ASH_logical_standby).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center