# Cloning an Oracle PDB from an RMAN Streaming Backup

You can create a clone of a Oracle pluggable database (PDB) from an RMAN streaming backup without interrupting the production database. When you clone a PDB, the Commvault software restores the container database ROOT and PDB$SEED to the staging path (CDB), and restores the data files for the PDBs that you want to clone to the path specified in the redirect-restore option. The software then stages a temporary CDB, unplugs the PDBs from the staged CDB, and plugs them into the destination 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.

- The `SYSBACKUP` administrative privilege does not have unplug privileges for PDBs, neither does it have privileges to plug a PDB into a CDB. For more information, see the Oracle Database Security Guide.

## Procedure

1. From the Command Center 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 list select the type of recovery and enter any related values.

16. To override the Control file backup piece selected by the system, under Advanced options enter your value in the box.

17. To use the recovery catalog, move the Use recovery catalog toggle to the right, and then select a saved credential.

18. 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 then select a saved credential.

19. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

    1. Click Schedule.

       The Add schedule dialog box appears.

    2. In the Name box, type a name for the schedule.

    3. Configure the Frequency and Repeat parameters.

    4. To specify exceptions to the schedule, click Exceptions.

       The Exceptions dialog box appears.

    5. Configure the exception parameters:

       - You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

       - Click Save when you have finished configuring the exception parameters.

    6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

    7. To save the schedule and return to the restore dialog box, click Schedule.

20. Click SUBMIT.

## Related Topics

Viewing and Editing a Database Restore Schedule for Oracle

×

Loading...