Cloning an Oracle RAC PDB from an RMAN Streaming Backup

You can create a clone of an Oracle RAC pluggable database (PDB) from an RMAN streaming backup without a production database interruption. When you clone a PDB, the Commvault Cloud software duplicates the container database (CDB) and PDBs that you want to clone to an auxiliary instance in a staging path that you specify. The software stages the CDB, and then unplugs the PDBs from the staged CDB, and plugs them in to the new CDB.

Before You Begin

Verify that the staging path has enough free space for the datafiles for both the root CDB and the PDB$SEED of the source database, and that the destination path has enough free space for the PDBs that you clone.
Oracle supports CDBs in Oracle version 12c and more recent versions.

Procedure

From the navigation pane, go to Protect > Databases.

The database overview page appears.
On the Instances tab, click the instance.

The instance properties page appears.
On the Overview tab, in the Recovery points section, select the backup to restore, and then click RESTORE.

The Backup content page appears.
Select the PDBs that you want to restore, and then click RESTORE.

The Restore options dialog box appears.
Select the Out of place option.
From the Destination server list, select the host to restore to.
From the Destination instance list, select the instance to restore to.
To change the number of streams to use for the restore, in the Number of streams box, enter the number of streams.
To specify the Pfile, in the PFile box type the path to the PFile.
Click PDB Clone options.

The PDB Clone options dialog box appears.
In the Staging Path box, enter the full path to the location where you want to store the auxiliary instance.
To have the software automatically clean up the instance after it creates the clone, select the Cleanup auxiliary instance check box.
Choose how you want to redirect the clone's tablespaces and datafiles:
- To redirect all the clone tablespaces and datafiles to a new location, select All PDBs.
  1. To specify the new location, in the box, enter the full path.
  2. In the Clone PDB Name box, enter a unique name for the new PDB.
- To redirect a single PDB to a new datafile directory, select Individual PDB.
  1. In the Clone PDB Name box, enter a unique name for the new PDB.
  2. In the Datafiles Directory box, enter the full path to the new PDB datafiles directory.
Click SAVE.
To apply the archive files to the data files for the Recover to selection, from the Recover to type list select the type of recovery and enter any related values.
To use the source catalog, under Advanced options move the Use source catalog toggle to the right, and then type the Connect string user ID, password, and service name.
To specify pre or post recovery scripts, do the following under Pre or Post options:
1. Type the path to the script.
2. To run a script as a specific user, move the Run as user toggle to the right and type the username and password.
Click SUBMIT.