Clone a Pluggable Database

This article provides the details and procedure to clone a pluggable database.

A clone is an independent and complete copy of the given database as it existed at the time of the cloning operation. You can create clones of your pluggable database within the same container database or a different container database and refresh the cloned pluggable database.

The following types of clones are supported:

• Local clone: A copy of the pluggable database is created within the same container database.

• Remote clone: A copy of the pluggable database is created on a different container database.

  You can perform a remote clone of a pluggable database from one container database to another container database within the same availability domain (AD) to the same or a later database version across compartments, DB systems, or VCNs. If two different VCNs are used, then both VCNs must be peered before cloning.

• Refreshable clone: A copy of the pluggable database is created on a different container database, and you will be able to refresh the cloned pluggable database.

  You can perform a refreshable clone of a pluggable database from one container database to another container database within the same availability domain (AD) to the same or a later database version across compartments, DB systems, or VCNs. If two different VCNs are used, then both VCNs must be peered before cloning.

Prerequisite

To clone the pluggable database, you must have the TDE wallet password of the pluggable database’s source database.

Procedure

Perform the following steps to clone a pluggable database using the OCI Console:

1. On the DB Systems list page, select the DB system that contains the pluggable database that you want to work with. If you need help finding the list page or the DB system, see List the DB Systems.
2. On the Databases tab, select the database that contains the pluggable database that you want to work with.
3. On the Pluggable Databases tab, select the pluggable database that you want to work with.
4. On the pluggable database details page, from the Actions menu, select Clone.
5. In the Clone pluggable database panel, provide the following details:

Basic details

• Select a clone type according to your requirements from one of the following options:

  • Local clone: Create a copy of the source pluggable database on the same container database.
  • Remote clone: Create a copy of the source pluggable database on a different container database.
  • Refreshable clone: Create a copy of the source pluggable database on a different container database and be able to refresh the cloned DPB.

Destination

• Compartment: Select a compartment.
• DB System: Select the destination DB system to which the pluggable database must be cloned.
• Database: Select the destination database to which the pluggable database must be cloned.
• PDB name: Enter a name for the pluggable database. The name must begin with an alphabetic character and can contain a maximum of 30 alphanumeric characters.
• Database SYS password: Enter the admin password for the destination container database.
• Database TDE wallet password: Enter the TDE wallet password for the destination container database.

• Unlock PDB admin account: Optional for local clone and remote clone. Not applicable for refreshable clone. Switch on this toggle to specify a pluggable database admin password and configure the pluggable database to be unlocked at creation.

  • PDB admin password: Create and enter a pluggable database 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 pluggable database admin password.

Source

This section is applicable only when the selected clone type is a remote clone or refreshable clone.

• Source database SYS password: Enter the database admin password of the source database.

• Database link: Required for refreshable clone and optional for remote clone. A common user is created at the container database 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.

• Take a backup of the PDB immediately: You must enable auto-backup on the container database to back up a pluggable database immediately. This toggle is switched on by default if auto-backup is enabled on the container database.

  Note: If the toggle is switched off, the system displays a warning stating that the pluggable database cannot be recovered until the next daily backup has been successfully completed.

Advanced options

Expand Advanced options to provide the advanced options for this resource.

Tags

Expand Tags to provide tag details for this resource.

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.

Tip: Tags can be applied later or at any time to a resource.

Clone

Select Clone.