Cloning an Oracle PDB from a Snapshot Backup

You can create a clone of an Oracle pluggable database (PDB) from a snapshot backup without a production database interruption. When you clone a PDB, the Commvault 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 meets the following staging space requirements:

  • Persistent snap engine: 2 x (Size of CDB$ROOT + Size of PDBs to be cloned)
    This amount of staging space is also needed for making a clone from the primary copy.
  • Non-persistent snap engine to restore archive logs: Size of (CDB$ROOT) + size of (PDBs to be cloned) + the space required for the staging logs.
    Assume the space required for the staging logs as: (size of (CDB$ROOT) + size of (PDBs to be cloned) x .2

• Verify 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

1. From the navigation pane, go to Protect > Databases.

   The database overview page appears.

2. On the Instances tab, click the instance.

   The instance properties page appears.

3. On the Overview tab, in the Recovery points section, select the backup to restore, and then click RESTORE.

   The Backup content page appears.

4. Select the PDBs that you want to restore, and then click RESTORE.

   The Restore options dialog box appears.

5. Select the Out of place option.

6. From the Destination server list, select the host to restore to.

7. From the Destination instance list, select the instance to restore to.

8. To change the number of streams to use for the restore, in the Number of streams box, enter the number of streams.

9. To specify the Pfile, in the PFile box type the path to the PFile.

10. Click PDB Clone options.

    The PDB Clone options dialog box appears.

11. In the Staging Path box, enter the full path to the location where you want to store the auxiliary instance.

12. To have the software automatically clean up the instance after it creates the clone, select the Cleanup auxiliary instance check box.

13. 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.

14. Click SAVE.

15. 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.

16. 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.

17. 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.

18. Click SUBMIT.