Removing an Oracle Pluggable Database


Before you begin

  • A container database with at least one Oracle Pluggable Database (PDB) currently managed by BMC Database Automation (BDA) must be up and available.
  • For RAC environments, the instance must be approved and be in the Up state.

To remove an Oracle Pluggable Database

Warning

Note

You can also remove a PDB or multiple PDBs by removing the Oracle Container Database (CDB) that holds the PDB(s).

  1. From the Management Console, navigate to the container database that contains the PDB that you want to remove.
  2. In the Pluggable Databases section of the Database Configuration page, click the PDB that you want to remove.
  3. Select Provision > Remove Pluggable Database.
  4. In the General page, populate the following fields, and click Next.

  5. If you select a template, click Skip Ahead to advance directly to the next step that requires input. An informational message appears on these steps, in green type, listing the fields that require entries before advancing to the next step.
     If you do not select a template, go to the next step.
  6. In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows:

  7. In the Job Options page, specify any of the following Job options, and click Next.

  8. In the Summary page, review the provisioning information.
    To make changes, do the following:
    1. Click Go to to return to the provisioning step that you want to edit.
    2. Make your changes.
    3. Click Save and Review to return to the Summary page.
  9. Specify your verification preferences.
     For additional information, see Understanding pre-verification tests.
    • To continue with removing the pluggable database after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.
    • To remove the pluggable database without having first run the pre-verification steps, select Skip Pre-Verification Tests.

      Warning

      Note

      The Skip Pre-Verification Tests option should only be used when you are certain all tests can succeed. The option skips verification and advances directly to the actual provisioning activity.

  10. Click Remove Oracle Pluggable Database to remove the database.
  11. Type Yes when you are prompted to confirm your decision, and click OK.

    Error
    Warning

    This operation permanently removes the database from the node.

    BDA prepares to remove the pluggable database. A progress page appears.
    When the pluggable database is removed, it no longer appears in the Pluggable Databases section of Database Configuration page for the CDB.

Warning

Note

Detailed current and historical information about this action can be viewed in the Jobs section of the Management Console. See Monitoring-jobs-and-viewing-job-history.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Database Automation 20.20