Clone a Pluggable Database

Perform the following steps to clone a pluggable database using the Console.

For detailed information about cloning a pluggable database, see About Pluggable Databases.

Note:

To clone the PDB, you must have the TDE wallet password of the PDB's source database.
  1. Open the navigation menu. Select Oracle Database, then select Oracle Base Database Service.
  2. Select your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, find the DB system containing the PDB you want to clone. Click the DB system name to display details about it.
  4. In the list of databases, find the database containing the PDB you want to clone. Click the database name to display details about it.
  5. In the Resources section of the page, click Pluggable Databases.
  6. In the list of PDBs, find the PDB you want to clone. Click the PDB name to display details about it.
  7. From the PDB details page, click Clone.
  8. In the Clone pluggable database window, provide the following details:
  9. Select a clone type according to your requirements from one of the following options:
    • Local clone: Create a copy of the source PDB on the same CDB.
    • Remote clone: Create a copy of the source PDB on a different CDB.
    • Refreshable clone: Create a copy of the source PDB on a different CDB and be able to refresh the cloned DPB.
  10. In the Destination section, provide the following details:
  11. DB System: Select the destination DB System to which the PDB must be cloned.
  12. Database: Select the destination database to which the PDB must be cloned.
  13. In the Configure new PDB section, provide the following details:
  14. PDB name: Enter a name for the PDB. The name must begin with an alphabetic character and can contain a maximum of 30 alphanumeric characters.
  15. Database SYS password: Enter the admin password for the destination CDB.
  16. Database TDE wallet password: Enter the TDE wallet password for the destination CDB.
  17. Unlock PDB admin account: Optional for local clone and remote clone. Not applicable for refreshable clone. Select this option to specify a PDB admin password and configure the PDB to be unlocked at creation.
    • PDB admin password: Create and enter a PDB admin password. The password must contain:
      • A minimum of 9 and a maximum of 30 characters
      • At least two uppercase characters
      • At least two lowercase characters
      • At least two special characters. The valid special characters are: underscore ( _ ), a hash sign (#), and a dash (-). You can use two of the same characters or any combination of two of the same characters.
      • At least two numeric characters (0 - 9)
    • Confirm PDB admin password: Reenter the PDB admin password.
  18. In the Source section, provide the following details. This section is applicable only when the selected clone type is a remote clone or refreshable clone.
  19. Source database SYS password: Enter the database admin password of the source database.
  20. Database link: Required for refreshable clone and optional for remote clone. A common user is created at the CDB level. If you do not provide the details, the system creates the user and deletes it at the end of the operation. If the user name entered already exists in the database, the remote clone will reuse the same username. However, the user's password will be reset to the one you entered.
    • Database link user name: Provide a user name for the database link.
    • Database link password: Provide a password for the database link.
    • Confirm database link password: Reenter the password for the database link.
  21. Take a backup of the PDB immediately: You must enable auto-backup on the CDB to back up a PDB immediately. This check box is checked by default if auto-backup is enabled on the CDB.

    Note:

    If the check box is unchecked, the system displays a warning stating that PDB cannot be recovered until the next daily backup has been successfully completed.
  22. Click Show advanced options to specify advanced options for the database.
  23. In the Tags tab, you can add free-form tags or defined tags to this resource. You must have permission to use the tag namespace for defined tags. For information about using tags to manage your OCI resources, see Resource Tags.
  24. Click Clone pluggable database.

Related Topics