PDB and Application Switchover in a Data Guard configuration
We are running RAC Oracle 19.16 database on active physical data guard configuration.
When we switchover the database from primary to standby (dgmgrl), we want the applications to automatically reconnect to the new primary database.
We have a CDB database with several PDBs.
How the 'role-based" services work for PDB databases?
Do we need to create a PRIMARY and PHYSICAL_STANDBY service for each PDB?
Thanks in advance, Bread