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.

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. From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
2. Select your Compartment. A list of DB systems is displayed.
3. On the DB systems list page, select the DB system that contains the pluggable database that you want to manage. The DB system details page is displayed.
4. On the DB system details page, select the database that contains the pluggable database that you want to manage. The database details page is displayed.
5. On the database details page, under Resources, select Pluggable Databases, and then select the pluggable database that you want to manage. The pluggable database details page is displayed.
6. On the pluggable database details page, select Clone.
7. In the Clone pluggable database panel, provide the following details:
8. 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.
9. In the Destination section, provide the following details:
10. DB System: Select the destination DB system to which the pluggable database must be cloned.
11. Database: Select the destination database to which the pluggable database must be cloned.
12. In the New PDB section, provide the following details:
13. 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.
14. Database SYS password: Enter the admin password for the destination container database.
15. Database TDE wallet password: Enter the TDE wallet password for the destination container database.
16. 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.
17. 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.
18. Source database SYS password: Enter the database admin password of the source database.
19. 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.
20. Take a backup of the PDB immediately: You must enable auto-backup on the container database to back up a pluggable database immediately. This check box is checked by default if auto-backup is enabled on the container database.

    Note:

    If the check box is unchecked, the system displays a warning stating that the pluggable database cannot be recovered until the next daily backup has been successfully completed.
21. Select Show advanced options to specify advanced options for this resource.
22. 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. Tags can be applied later or at any time to a resource.
23. Select Clone.