Pluggable Database (PDB) configuration

For all Oracle RDBMS releases 12c Release 2 (12.2) to 21c, configure the CDB with local undo mode

See Undo Modes in 12.2 Multitenant Databases - Local and Shared Modes (Doc ID 2169828.1)

PDB service management

Mandatory MAA best practices for any Oracle databases with Oracle Clusterware (for example, Oracle RAC and single instance databases with Oracle Clusterware installed)

1. Never use PDB default services, nor SAVED STATE (except during relocate operations), nor database triggers to manage role-based services.
2. Use clusterware-managed distinct services per PDB for your application service, and leverage that application service to connect to the database.
3. When defining a clusterware-managed application service, define which PDB and services will be started and in which RAC instance and database role.
4. For Data Guard, always use role-based services by assigning a role to each clusterware-managed service.

If the above practices are applied, you will have predictable service management during PDB open and Data Guard role transitions. This will lead to higher application service availability and avoid application errors.

For single instance databases without MAA-recommended Oracle clusterware setup, follow these practices:

1. Never use PDB default services.
2. Use distinct services per PDB for your application service, and leverage that application service to connect to the database.
3. For non-Data Guard, use only SAVED state to open PDBs and start up explicit application services OR for Data Guard, use only AFTER STARTUP database triggers to programmatically manage which application services should be started depending on primary, READ ONLY, or snapshot standby database role.

See Best Practices for Pluggable Database End User and Application Connection and Open on Database Startup (Doc ID 2833029.1)

Using Data Guard with Oracle Multitenant

The following My Oracle Support notes provide operational best practice recommendations when using Oracle Multitenant in an Oracle Data Guard configuration.

• Data Guard Impact on Oracle Multitenant Environments (Doc ID 2049127.1)

• Making Use Deferred PDB Recovery and the STANDBYS=NONE Feature with Oracle Multitenant (Doc ID 1916648.1) during use cases: PDB creation, PDB migration, and PDB cloning

• Reusing the Source Standby Database Files When Plugging a PDB into the Primary Database of a Data Guard Configuration (Doc ID 2273829.1) for PDB migration

• Reusing the Source Standby Database Files When Plugging a non-CDB as a PDB into the Primary Database of a Data Guard Configuration (Doc ID 2273304.1) for PDB migration

• Using standby_pdb_source_file_dblink and standby_pdb_source_file_directory to Maintain Standby Databases when Performing PDB Remote Clones or Plugins (Doc ID 2274735.1) for PDB remote clone or PDB plug-in

• Parameter enabled_pdbs_on_standby and STANDBYS Option With Data Guard Subset Standby (Doc ID 2417018.1) to support subset standby

Data Guard: PDB switchover and failover use cases

Using Data Guard Broker to Migrate a Pluggable Database to a New Data Guard Configuration Document 2887844.1

PDB Failover in a Data Guard environment: Using Data Guard Broker to Unplug a Single Failed PDB from a Standby Database and Plugging into a New Container or Migrate a Single PDB into a New Container Document 2088201.1

PDB migration

The following My Oracle Support notes provide operational best practices for different types of PDB migration with minimal downtime:

• Use Zero Downtime Migration if your target is Exadata platform or cloud. See https://www.oracle.com/database/technologies/rac/zdm.html

• Step by Step Process of Migrating non-CDBs and PDBs Using ASM for File Storage (Doc ID 1576755.1)

• Cloning a Pluggable Database from an RMAN Container Database Backup (Doc ID 2042607.1)

• Using Data Guard Broker to Migrate a Pluggable Database to a New Data Guard Configuration Document 2887844.1

PDB relocation

• Using PDB Relocation to Upgrade an Individual PDB (Doc ID 2771716.1)

• Using PDB Relocation to Move a Single PDB to Another CDB Without Upgrade (Doc ID 2771737.1)

The following My Oracle Support note provides operational use cases for Oracle Multitenant resource management:

How to Control and Monitor the Memory Usage (Both SGA and PGA) Among the PDBs in Mutitenant Database- 12.2 New Feature (Doc ID 2170772.1)

Recoverable node or instance failures

Real Application Cluster (RAC)

Application Continuity (AC)

Database, cluster, and site failures

Active Data Guard fast-start failover

Data corruptions

Active Data Guard that includes auto block repair of physical corruptions

PDB unrecoverable failure or "sick" PDB

PDB failover using Data Guard migrate command

Another target CDB on the same cluster is required

See PDB Failover in a Data Guard environment: Using Data Guard Broker to Unplug a Single Failed PDB from a Standby Database and Plugging into a New Container or Migrate a Single PDB into a New Container (Doc ID 2088201.1)

PDB failover to active replica

Option 1: Failover entire CDB with Primary and Standby CDB Data Guard architecture

Option 2: Create PDB replica with Oracle GoldenGate. Perform PDB active failover using PDB replica in a different CDB.

Use Global Data Services and practices from Application Checklist for Continuous Service for MAA Solutions help with the application failover

Software and hardware updates

Real Application Cluster (RAC)

Application Checklist for Continuous Service for MAA Solutions

Major database upgrade for entire CDB

Active Data Guard DBMS_ROLLING

Major database upgrade for single PDB within CDB

PDB Relocate + Upgrade

See Using PDB Relocation to Upgrade an Individual PDB (Doc ID 2771716.1)

Migration to remote CDB

PDB Relocate

See Using PDB Relocation to Move a Single PDB to Another CDB Without Upgrade (Doc ID 2771737.1)

Migration to remote CDB (logical migration)

Data Pump and Oracle GoldenGate or Zero Downtime Migration