We all know the benefits of the Oracle Multitenant cosolidation “Many-as-One”, one container (CDB) operation for wich many Pluggable Databases (PDBs) can take benefit; for example one CDB backup protects all PDBs stored inside the container itself.
While among the DBAs the setup of Oracle Data Guard is become more than a standandard routine, described in thousands of Internet pages and blogs (one example available here), this post explains how to add new Pluggable Databases (PDBs) to an existing Multitenant environment protected by Data Guard.
How to create PDBs in Oracle Multitenant environment protected by Data Guard
There are multiple scenarios of PDB creation and they differently integrate within the Data Guard architecture. The easiest way to proceed consists in creating a new Pluggable Database using the SEED PDB:
- PDB creation from SEED
The creation of a brand new empty pluggable database is automatically replicated to each physical standby database. No additional action is required.
Unfortunately, this option is not always applicable because the new PDB should be a clone of an existing one. Therefore, it is important for the DBA to understand how integrating new non-empty Pluggable Database on a Multitenant and Data Guard environment without impacting the pre-existing setup.
- PDB clone
Cloning a PDB in a Data Guard environment requires few additional steps, which changes across the different Oracle versions and when Active Data Guard option is in use. While remote cloning the PDB the option STANDBYS=NONE should be used to defer the PDB replica to the Standby container. Then it is possible to replicate and protect the newly cloned PDB with Data Guard.
A full example of how to perform those tasks is reported below.
Cloning a PDB via DB Link using the STANDBYS=NONE option
create pluggable database PCJORD from PCLORD@ccls01_PCLORD tempfile reuse STANDBYS=NONE;
Open the newly cloned PDB
alter pluggable database PCJORD open instances=all;
On the Standby Container Restore PDB from Primary
run{
set newname for pluggable database PCJORD to new;
restore pluggable database PCJORD from service CMJP01;
switch datafile all;
}
Connect to the Standby container and STOP the Apply Process
dgmgrl connect sys/xxxxxxxx@CMJP01 edit database 'CMJS01' set state='APPLY-OFF';
If Active Data Guard is in use, re-start the Standby container in MOUNT
srvctl stop database -db CMJS01 sqlplus / as sysdba startup mount
Enable the PDB recovery on the Standby Container
alter session set container=PCJORD; alter pluggable database enable recovery;
Connect to the Standby container and RE-START the Apply Process
dgmdrl connect sys/xxxxxxxx@CMJP01 edit database 'CMJS01' set state='APPLY-ON';
If Active Data Guard is in use Open the Container in Read Only
alter database open;
My Oracle Notes 