Relocate a Pluggable Database

This article provides the details and procedure to relocate a pluggable database.

You can relocate a pluggable database from one container database to another container database within the same availability domain (AD) to the same or a later database version across compartments, DB systems, or VCNs. If two different VCNs are used, then both VCNs must be peered before relocating. During relocation, the pluggable database will be removed from the source container database and moved to the destination container database that is up and running. In a Data Guard association, a pluggable database relocated to the primary will be synchronized with the standby as well.

Procedure

Perform the following steps to relocate a 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 Relocate.
5. In the Relocate pluggable database panel, provide the following details:

Destination

• Compartment: Select the required compartment.
• DB System: Select the destination DB system to which the pluggable database must be migrated.
• Database: Select the destination database to which the pluggable database must be migrated.

New PDB

• 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.
• Database SYS password: Enter the admin password for the source container database.
• Database TDE wallet password: Enter the TDE wallet password for the source container database.

• Unlock the PDB admin account: Optional. 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.

Source

• Source database SYS password: Enter the database admin password of the source database.

• Database link: Optional. Enter the user name and password for the database link. 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, relocate will reuse the same user name. 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.

• 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.

Advanced options

Expand Advanced options to provide the advanced options for this resource.

Tags

Expand Tags to provide tag details for this resource.

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.

Tip: Tags can be applied later or at any time to a resource.

Relocate

Select Relocate.

• After the relocation is successful, the state of the pluggable database will change from Available to Relocated in the source container database.
• In the destination container database, the new pluggable database will be added, and its state will be displayed as Available.
• Relocation will incur downtime during the process, and the time required is based on the size of the pluggable database.