1. Oracle Enterprise Manager Cloud Control for Oracle Exadata Cloud
  2. Exadata Cloud Lifecycle Management
  3. Database Lifecycle Management in Exadata Cloud
  4. Unplug and Plug a PDB

Unplug and Plug a PDB

To plug and unplug PDBs follow these steps:

Unplug a PDB

  1. From the Enterprise menu, select Provisioning and Patching select Database Provisioning. In the Database Provisioning page under Related Links, click Provision Pluggable Databases.
  2. In the Provision Pluggable Database Console, select the CDB from which you want to unplug the PDBs.
  3. In the PDB Operations section, select Unplug Pluggable Database.
  4. Click Launch.
  5. In the Select PDB page of the Unplug Pluggable Database Wizard, in the Select Pluggable Database section, select the PDB you want to unplug. Note that the PDB once unplugged will be stopped and dropped.
  6. In the CDB Host Credentials section, select or specify the target CDB Oracle Home owner host credentials. Select Preferred, Named or New credentials. For Exadata Cloud RAC use the OPC user for Normal Host credentials.
  7. In the Destination page, select the type of PDB template you want to generate for unplugging the PDB, and the location where you want to store it. The PDB template consists of all datafiles as well as the metadata XML file.
    • Select Target Host File System to store the PDB template on your CDB host (where you are unplugging the PDB)
      • Select Generate PDB File Set to generate an RMAN file set. This creates a DFB file with all the data files and a separate metadata XML file.

        Note:

        Oracle recommends you to select this option if the source and target CDBs are using ASM for storage.
      • Select Generate PDB Metadata File to generate only a metadata XML file, and select a location where the metadata XML file will be created. In this option the PDB datafiles remain on the source PDB location after unplugging.
      • Generate PDB Archive a TAR file with the datafiles and the metadata XML file included in it is not a valid option for Exadata Cloud TDE enabled databases 19c and above. Oracle recommends that you select this option if the source and target CDBs are using file system for storage. This option is not supported for PDBs using ASM as storage.
    • Select Software Library to store the PDB template in the Oracle Software Library.
      • Select Generate PDB File Set to generate an archive file set. This creates a DFB file with all the data files and a separate metadata XML file. This is not a valid option for Exadata Cloud TDE enabled databases 19c and above.
      • Select Generate PDB Metadata File to generate only a metadata XML file, and select a location where the metadata XML file will be created.
      • Generate PDB Archive a TAR file with the datafiles and the metadata XML file included in it is not a valid option for Exadata Cloud. Oracle recommends that you select this option if the source and target CDBs are using file system for storage. This option is not supported for PDBs using ASM as storage.
    • Enter a unique PDB template name. The template is created in the default location: Database Configuration/<db_release>/<platform>/Database Templates
    • Enter a temporary location where the archive can be created by Enterprise Manager before it is uploaded to the Software Library.

    If the CDB is TDE enabled, enter the TDE wallet password. Provide a new wallet transport secret and wallet location where the wallet will be stored after unplug operation. In case of RAC database, ensure that the TDE wallet location is accessible from all nodes.

  8. In the Schedule page, enter a unique deployment procedure instance name and a schedule for the deployment.
  9. Click Next.
  10. In the Review page, review the details you have provided for the deployment procedure. If you are satisfied with the details click Submit.
  11. In the Procedure Activity page, view the status of the procedure. From the Procedure Actions menu select Debug to set the logging level debug. Select Stop to stop the procedure execution.
For more information on unplugging a PDB see Unplugging and Dropping a Pluggable Database in Oracle Enterprise Manager Cloud Control Database Lifecycle Management Administrator's Guide.

Plug a PDB

  1. From the Enterprise menu, select Provisioning and Patching, then select Database Provisioning. In the Database Provisioning page, in the Related Links section of the left menu pane, click Provision Pluggable Databases.
  2. In the Provision Pluggable Database Console, under the Container Database section, select the CDB to which you want to add the unplugged PDBs.
  3. In the PDB Operations section, select Create New Pluggable Databases.
  4. Click Launch.
  5. In the Creation Options page of the Create Pluggable Database Wizard, in the Pluggable Database Creation Options section, select Plug an Unplugged PDB.
  6. In the Container Database Host Credentials section, select or specify the target CDB Oracle home owner host credentials, you can select Preferred, Named, or New .
  7. Click Next.
  8. In the Identification page, enter a unique name for the PDB you are plugging in.

    Select Create As Clone to ensure that Oracle Database generates a unique PDB DBID, GUID, and other identifiers expected for the new PDB.

    For a TDE enabled PDB enter the Wallet Password and Wallet Transport for the PDB plug operation.

  9. If you want to create a brand new admin user account for the PDB you are plugging in select Create PDB Administrator and enter the desired credentials. If not deselect Create PDB Administrator.
  10. In the PDB Template Location section, select the location where the source PDB's template is available, and then select the type of PDB template. Plugging In an Unplugged Pluggable Database displays the PDB Template Location section of the Identification page.
  11. For TDE enabled CDB enter the wallet file, destination CDB wallet password, and Wallet Transport Secret passed during the unplug operation.
  12. Click Next.
  13. In the Storage page, select Use Oracle Managed Files (OMF) or Use Common Location for PDB datafiles depending on your desired configuration.
  14. In the Temporary Working Directory section, enter a location where the temporary files generated during the PDB creation process can be stored.
  15. In the Post-Creation Scripts section, select a custom SQL script you want to run as part of this procedure, once the PDB is plugged in.
  16. Click Next.
  17. In the Schedule page, enter a unique deployment procedure instance name and a schedule for the deployment.
  18. Click Next.
  19. In the Review page, review the details you have provided for the deployment procedure. If you are satisfied with the details, click Submit.
For more information on plugging a PDB see: Plugging In an Unplugged Pluggable Database in Oracle Enterprise Manager Cloud Control Database Lifecycle Management Administrator's Guide.