Relocate a Pluggable Database
Perform the following steps to relocate a Pluggable Database (PDB) using the Console.
- Open the navigation menu. Select Oracle Database, then select Oracle Base Database Service.
- Select your Compartment. A list of DB systems is displayed.
- In the list of DB systems, find the DB system containing the PDB you want to relocate. Click the DB system name to display details about it.
- In the list of databases, find the database containing the PDB you want to relocate. Click the database name to display details about it.
- In the Resources section of the page, click Pluggable Databases.
- In the list of PDBs, find the PDB you want to relocate. Click the PDB name to display details about it.
- From the PDB details page, click More actions, and then click Relocate.
- In the Relocate pluggable database window, provide the following details:
- In the Destination section, provide the following details:
- DB System: Select the destination DB system to which the PDB must be migrated.
- Database: Select the destination database to which the PDB must be migrated.
- In the Configure new PDB section, provide the following details:
- PDB name: Enter a name for the PDB. 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 CDB.
- Database TDE wallet password: Enter the TDE wallet password for the source CDB.
- Unlock PDB admin account: Optional. Select this option to
specify a PDB admin password and configure the PDB to be unlocked at creation.
- PDB admin password: Create and
enter a PDB 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 PDB admin password.
- PDB admin password: Create and
enter a PDB admin password. The password must contain:
- In the Source section, provide the following details:
- 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 CDB
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 re-use 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 CDB to back up a PDB immediately. This check
box is checked by default if auto-backup is enabled on the CDB.
Note:
If the check box is unchecked, the system displays a warning stating that PDB cannot be recovered until the next daily backup has been successfully completed. - Click Show advanced options to specify advanced options for the database.
- In the Tags tab, 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.
- Click Relocate pluggable database.
Note:
- After the relocation is successful, the state of the PDB will change from Available to Relocated in the source CDB.
- In the destination CDB, the new PDB will be added, and its state will be displayed as Available.
- Relocate will incur downtime during the process, and the time required is based on the size of the PDB.
Related Topics