4.7.1 Thin Cloning a Pluggable Database

Within Oracle Database, you can use the CREATE PLUGGABLE DATABASE SQL command to create a writable snapshot copy (clone) of an existing pluggable database (PDB). For example, the following command creates a clone of pdb1 named pdb1c.

SQL> CREATE PLUGGABLE DATABASE pdb1c
     FROM pdb1 SNAPSHOT COPY;

When Oracle Database uses Exascale storage, the PDB snapshot copy operation automatically uses native Exascale cloning functionality to thinly provision the underlying Oracle Database files.

The thin cloned PDB data files reside in the same Exascale vault as the underlying source PDB data files, and Exascale uses redirect-on-write techniques to create and maintain the cloned data files. As a result, the cloning operation is instantaneous, regardless of the size of the underlying data files. Also, the clone is extremely space-efficient. A cloned data file initially consumes no additional space, and physical storage space is only allocated when new data is written.

Within the Oracle Database, the cloned files function like regular data files and appear in the standard Oracle Database dictionary views, such as DBA_DATA_FILES. Additionally, you can examine various Exascale-specific file details in the V$EXA_FILE Oracle Database dictionary view.

Within Exascale, you can use the ESCLI lssnapshots command to view the association between the cloned data files and their underlying source files.

Note:

If you create a thinly provisioned PDB clone on an Oracle Data Guard primary database, the corresponding standby PDB data files contain a complete (not thinly provisioned) copy of the data, even if the standby database uses Exascale storage. To avoid this, you can prevent the PDB clone from propagating to the standby database by including STANDBYS=NONE in the CREATE PLUGGABLE DATABASE SQL command.