Loading...

Cloning an Oracle RAC 12c Pluggable Database (PDB)

You can create a clone of an Oracle RAC12c PDB database without a production database interruption, so that you can:

  • Create test environments
  • Move a PDB to an additional CDB

You can create a clone from the latest backup, or from a point-in-time backup.

When you clone a PDB, the Commvault software duplicates the 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.

 The following rules apply to the destination CDB:

  • It must match the source CDB.
  • There are no limitations on the Catalog Connect String, but if you want to use an account other than 'sys', you must grant the SYSDBA or SYSBACKUP privilege to the user account.

Before You Begin

  • Perform a full backup, or an incremental backup with a subclient configured for Oracle pluggable databases.
  • Verify that the staging path has enough free space for the datafiles for both the CDB and the PDB$SEED that you want to restore and that the destination path has enough free space for the PDBs that you clone.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > Oracle RAC.
  2. Right-click the instance, point to All Tasks, and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select the backup to use for the clone.
    • To create the clone from the latest backup, select Latest Backup, and then click View Content.
    • To create the clone from a point-in-time backup, make the following selections:
      • Select Latest Backup and click Time Range.
      • Select the Absolute Time, and then in the  End Time area, enter the date and time.
  4. From the browse window, select the PDBs to restore in the right pane, and then click Recover All Selected.

    The Restore Options dialog box appears.

  5. On the General tab, specify the destination details.
    1. Under Restore Options, select the PDB Clone check box
    2. In the Destination Client list, select the destination client that has the CDB that will contain the clone PDBs.
    3. in the Catalog Connect String boxes, type the
    4. Click Advanced.

      The Advanced Restore Options dialog box appears.

  6. On the Auxiliary instance tab, specify the auxiliary instance information:
    1. Optional: In the PFile box, type the full path to the PFile that the software uses when it creates the instance.
    2. In the Staging Path box, type the full path to the location where the software creates the auxiliary instance.
    3. To have the software automatically clean up the instance after it creates the clone, select the Cleanup Auxiliary check box.
  7. On the PDB Clone tab, specify the PDB clone information.
    1. To redirect all the clone tablespaces and datafiles to a new location, select the select the Redirect All Table Spaces/Database to check box, and then in the box, type the full path to the new location.
    2. To rename a PDB, in the row for the PDB, in the Clone PDB Name box, type the new PDB name.
    3. To redirect PDB datafiles, in the row for the PDB, in the Datafiles Directory box, type full path to the new PDB datafiles directory.
    4. Repeat the steps for all PDBs.
  8. To set the Commvault software to automatically move the database to the correct mode before the restore, select the Switch Database Mode for Restore check box.
  9. Click OK to close the Advanced Restore Options dialog box.
  10. Click OK to close the Restore Options dialog box .

Result

The selected PDBs are cloned to the new CDB.

Last modified: 5/31/2019 10:51:15 PM