Convert a Refreshable Clone to a Regular Pluggable Database

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

You can convert a refreshable clone to a regular pluggable database by disconnecting the refreshable clone (destination pluggable database) from the source pluggable database at any time. If the refresh pluggable database is in a Data Guard association, when it is converted to a regular pluggable database, then the pluggable database will be synced to the standby as part of the conversion process.

Procedure

Perform the following steps to convert a refreshable clone to a regular 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 Convert to regular PDB.
  5. In the Convert to regular PDB panel, provide the following details:
    • TDE wallet password of database: Enter the TDE wallet password for the source container database.
    • 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.
    • Select Convert.

Related Topics