There may be situations in which you want to migrate a virtual pluggable database (vPDB) to a new container database on the same or a different target environment, for example when upgrading the host on which the vPDB resides, or as part of a general data center migration. This is easily accomplished by first disabling the vPDB, then using the Migrate vPDB feature to select a new container database.
Pre-requisites
-
You should already set up and have Delphix discover a container database in the same environment as the vPDB currently is or from an environment to which the vPDB will be migrated to.
-
The virtual CDB from/to which vPDB is to be migrated must be already running and open in a read-write mode.
Procedure
Login to your Delphix Management application.
-
Click Manage.
-
Select Datasets.
-
Select the vPDB you want to migrate.
-
From the Actions menu (...) select Disable.
-
Click Disable to confirm.
-
From the Actions menu (...) select Migrate.
-
Select the new container database for the vPDB, the user for that environment, and the database installation where the container database of the vPDB will reside.
-
Click the Migrate to confirm your selections.
-
Manually copy the exported keys to the target hosts toolkit directory. When migrating a TDE enabled vPDB, the disable step results in the vPDB keys being exported to the toolkit. Enabling the vPDB in a different target host will result in plugin violations, therefore when migrating to a new host, the user must manually copy the exported keys to the toolkit directory on the target host.
-
From the Actions menu (...) select Enable.
-
Click Enable to confirm. Your vPDB will re-start in the new environment, and you can continue to work with it as you would any other vPDB.