PDB snapshot standby

Franck Pachot

In non-CDB, we use a standby database to start quickly an exact copy of the production, to test an application bug fix, test a new release or even a database upgrade. Now in multitenant, what was a database before is now a PDB and we need the same operations at that level. When consolidating multiple PDBs in a CDB we need to be able to convert to snapshot standby a single PDB without impacting the recovery of the other PDBs. I can imagine the technical difficulty because CDB$ROOT is read-only in a standby CDB but this is a must in a consolidated CDB: we cannot convert to snapshot standby a whole CDB just because we need to test something in one PDB.

Mufalani

This feature could save a lot of time and some jobs.

Thomas Teske-Oracle

There are several use-cases for this potential feature. I see a clear need.