Upgrade Oracle 12c with cascaded Standby databases
Hi ,
we plan to upgrade our Oracle 12c database to Oracle version 19c (release 19.8.0.0). In our environment we have the following configuration:
- Primary database PrimDB
- Standby database StbyDB01 (cascading Standby database)
- Standby database StbyDB02 (Active Data Guard, cascaded Standby database)
So StbyDB01 ships the REDOLOGs to StbyDB02 - and PrimDB ships the REDOLOGs to StbyDB01.
We will follow the documentation "Data Guard Concepts and Administration" (chapter B "Patching, Upgrading, and Downgrading Databases in an Oracle Data Guard Configuration"). In this chapter we have found the information "if there are cascaded standbys in your configuration then those cascaded standbys must follow the same rules as any other standby but should be shut down last and restarted in the new home first."