Moving a pluggable database between containers on the same node

Before you begin

• An Oracle Container Database (CDB) with at least one Oracle Pluggable Database (PDB) with status as Normal currently managed by BMC Database Automation (BDA) must be available.
• Another Oracle CDB where the PDB can be moved to must be available.

To move an Oracle Pluggable Database

1. From the Management Console, navigate to the container database that contains the PDB that you want to move.
2. In the Pluggable Databases section of the Database Configuration page, click the PDB that you want to move.

3. Select Management > Move Pluggable Database.

4. In the General page, populate the following fields, and click Next.

   Field	Description
   Domain	Displays the BMC Database Automation multitenant domain within which this PDB is contained.
   Container Database Name	Displays the name of the CDB that contains this PDB.
   Pluggable Database Name	Displays the name of this PDB.
   Template	(Optional) Select a template from the Template list box. For more information about templates, see Managing templates for Oracle on Linux and UNIX.

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.
   In the Destination page, populate the following fields, and click Next.

   Field	Description
   Source Container Database	Displays the name of the CDB that contains this PDB.
   Destination Container Database	Select a CDB from the list of CDBs approved on the same node.
   Destination Pluggable Database Name	Displays the new name of this PDB when it is moved to the new destination (this name can be different from the original PDB name specified in Step 4).
   Metadata Filename	Type the xml file name and full path for the configuration file. The recommended value is /oradata/<your initials>export.xml. Make sure the oracle user has write permissions to the selected directory.

6. In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows:

   Section	Description
   Pre-Provisioning Script Directory	(Optional) Select the scripts that you want to run before this event and click to move them to the Selected list box. The scripts in Selected are run in the order listed. Use Move Up and Move Down to re-order the scripts when necessary. See also Managing pre-provisioning and post-provisioning script files.
   Post-Provisioning Script Directory	(Optional) Select the scripts that you want to run after this event and click to move them to the Selected list box. See also Managing pre-provisioning and post-provisioning script files.

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

   Type	Option	Description
   Notification Emails	Email List	(Optional) Click Add Email to add email addresses to the notification list.
   Job Administration	Cleanup Agent Logs	(Optional) Select to automatically remove logs that are generated by BMC Database Automation on the Agent after the Job is complete.

8. If the Change Control page displays, populate the following fields, and click Next.

   Section	Field	Description
   	Bypass Change Control	(Optional) Select to bypass using BMC Remedy ITSM to control the change process. Selecting this option removes the rest of the fields from this page.
   	Change Control Options	Select to determine whether to open a new BMC Remedy ITSM change ticket, or to use an existing BMC Remedy ITSM change ticket to control the change process. Selecting Use Existing Change Ticket displays the fields in the Use Existing Change Ticket section on this page. Selecting Create New Change Ticket displays the fields in the Create New Change Ticket section on this page.
   Use Existing Change Ticket	ITSM Change ID	Specify the BMC Remedy ITSM change ticket number to associate with this change process.
   	ITSM Task ID	Specify the BMC Remedy ITSM task ID number to associate with this change process.
   Create New Change Ticket	Change Type	Assign the type of change for the new BMC Remedy ITSM change ticket.
   	Change Impact	Assign the impact level of this change process for the new BMC Remedy ITSM change ticket.
   	Change Urgency	Assign the urgency level for the new BMC Remedy ITSM change ticket.
   	Change Risk-Level	Assign the risk level of this change process for the new BMC Remedy ITSM change ticket.
   	Change Class	Assign the change class for the new BMC Remedy ITSM change ticket.
   	Change Summary	Type a summary of the change process.

   Note

   The Change Control page appears only when change control is configured for your environment. See Configuring change control.

9. 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.
10. Specify your verification preferences.
    For additional information, see Understanding pre-verification tests.
    • To continue with database creation after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.

    • To create the database without having first run the pre-verification steps, select Skip Pre-Verification Tests.

      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.

11. Click Move Oracle Pluggable Database to unplug the database.

12. Enter Yes when you are prompted to confirm your decision, and click OK.
    BDA prepares to move the pluggable database to the specified destination. A progress page appears.