Data Guard 26ai – #18: PDB Recovery Isolation

This post is part of a blog series.

With Oracle 12c’s introduction of Multitenant architecture, managing Data Guard setups became challenging when adding new databases to the primary CDB. In 12c Release 1, adding a pluggable database (PDB) would crash standby recovery. Release 2 improved this by offering the standbys=none option, letting you skip recovery for new PDBs. However, you then had to manually copy the new PDB to the standby and re-enable recovery. Otherwise, some PDBs ended up unprotected by Data Guard.

My colleague Sinan blogged about the pre-21c behavior here: https://database-heartbeat.com/2022/01/24/hot-clone-remote-pdb-in-data-guard/ 

With Oracle 21c (and in 26ai), creating or cloning a new PDB in the primary CDB now automatically copies it to the standby CDB and includes it in recovery: no interruptions or manual steps needed. Just ensure the standby CDB is open in read-only mode.

https://docs.oracle.com/en/database/oracle/oracle-database/26/sbydb/examples-of-using-oracle-data-guard.html#GUID-45590356-133B-47DC-AD19-3AA37348CD4D

A new PDB on the primary is automatically restored and recovered on the standby

This greatly simplifies working with the Multitenant architecture, which is now mandatory in 26ai.

Note: This feature works only for new or cloned PDBs, created locally or remotely. It does not support plugging in existing PDBs using a manifest file.

The following two tabs change content below.

Ludovico

Principal Product Manager at Oracle
Ludovico is a member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle. He focuses on Oracle Data Guard, Flashback technologies, and Cloud MAA.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.