Skip to main content
Delphix

How to Migrate vCDB + vPDB To a New Host (KBA7183)

 

KBA

KBA# 7183

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

How to Migrate vCDB + vPDB to a new host

Delphix versions listed above does not support migrating a vPDB provisioned to a vCDB to a new host using the GUI. Attempts to perform this migration will fail with the error:

clipboard_e15cf80755c8a972091b34046bc1cd28f.png

To perform this task the CLI must be used.

To complete vCDB + vPDB non-RAC migration using CLI

Complete the following procedure to migrate a vCDB + vPDB to a new host.

tip

Tip:

In the example below, the vPDB "myPDB" with vCDB "myCDB" is migrated from host mwrh74-ora19000-src to host mwrh77-ora19000-src.

 

  1. Login to CLI via ssh.
    ~ ssh admin@mwdlpx-6.0.7.0.dcol1
    Warning: Permanently added 'mwdlpx-6.0.7.0.dcol1,10.43.66.20' (ECDSA) to the list of known hosts.
    mwdlpx-6.0.7.0.dcol1>
    
  2. Disable the vPDB.
    mwdlpx-6.0.7.0.dcol1> /source
    mwdlpx-6.0.7.0.dcol1 source> select myPDB
    mwdlpx-6.0.7.0.dcol1 source 'myPDB'> disable
    mwdlpx-6.0.7.0.dcol1 source 'myPDB' disable *> commit
        Dispatched job JOB-35
        SOURCE_DISABLE job started for "myPDB".
        Disabling virtual database "myPDB".
        Unexporting storage containers.
        Virtual database "myPDB" disabled.
        SOURCE_DISABLE job for "myPDB" completed successfully.
    mwdlpx-6.0.7.0.dcol1 source 'myPDB'>
    
  3. Change the environment user and repository ( ORACLE_HOME ) for the vPDB to the appropriate user from the new host.
    mwdlpx-6.0.7.0.dcol1> /sourceconfig
    mwdlpx-6.0.7.0.dcol1 sourceconfig> select myPDB
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myPDB'> update
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myPDB' update *> set repository=mwrh77-ora19000-src/'/u01/app/oracle/product/19.0.0.0/dbhome_1'
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myPDB' update *> set environmentUser=mwrh77-ora19000-src/oracle
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myPDB' update *> commit
        Dispatched job JOB-38
        SOURCE_CONFIG_UPDATE job started for "myPDB".
        SOURCE_CONFIG_UPDATE job for "myPDB" completed successfully.
    
  4. Change the environment user and repository ( ORACLE_HOME ) for the vCDB to the appropriate user from the new host. This must match the settings in step 3.
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myPDB'> /sourceconfig/
    mwdlpx-6.0.7.0.dcol1 sourceconfig> select myCDB
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myCDB'> update
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myCDB' update *> set repository=mwrh77-ora19000-src/'/u01/app/oracle/product/19.0.0.0/dbhome_1'
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myCDB' update *> set environmentUser=mwrh77-ora19000-src/oracle
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myCDB' update *> commit
        Dispatched job JOB-39
        SOURCE_CONFIG_UPDATE job started for "myCDB".
        SOURCE_CONFIG_UPDATE job for "myCDB" completed successfully.
    
  5. Enable the vPDB.
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'myCDB'> /source
    mwdlpx-6.0.7.0.dcol1 source> select myPDB
    mwdlpx-6.0.7.0.dcol1 source 'myPDB'> enable
    mwdlpx-6.0.7.0.dcol1 source 'myPDB' enable *> commit
        Dispatched job JOB-40
        SOURCE_ENABLE job started for "myPDB".
        Enabling dataset "myPDB".
        Exporting storage containers from the Delphix Engine.
        Mounting datasets.
        Mounting filesystems for the virtual database instance "1".
        Starting virtual database.
        Starting instance 1 on virtual database "myCDB".
        Virtual database "myCDB" was successfully started.
        Starting virtual database.
        Starting instance 1 on virtual database "myPDB".
        Plugging in Oracle pluggable database.
        Opening Oracle pluggable database.
        Setting OMF destination for Oracle pluggable database.
        Creating PDB tempfiles.
        Checking Oracle pluggable database plugin violations.
        Virtual database "myPDB" was successfully started.
        Dataset "myPDB" enabled.
        SOURCE_ENABLE job for "myPDB" completed successfully.
    mwdlpx-6.0.7.0.dcol1 source 'myPDB'>
    

To complete vCDB + vPDB RAC migration using CLI

Complete the following procedure to migrate a vCDB + vPDB to a new RAC host.

tip

Tip:

In the example below, the vPDB "racPDB" with vCDB "racCDB" is migrated from cluster "clust1" to cluster "clust2". The process is essentially the same as Non-RAC, with the extra step to update instance node configuration.

 

  1. Login to CLI via ssh.
    ~ ssh admin@mwdlpx-6.0.7.0.dcol1
    Warning: Permanently added 'mwdlpx-6.0.7.0.dcol1,10.43.66.20' (ECDSA) to the list of known hosts.
    mwdlpx-6.0.7.0.dcol1>
    
  2. Disable the vPDB.
    mwdlpx-6.0.7.0.dcol1> /source
    mwdlpx-6.0.7.0.dcol1 source> select racPDB
    mwdlpx-6.0.7.0.dcol1 source 'racPDB'> disable
    mwdlpx-6.0.7.0.dcol1 source 'racPDB' disable *> commit
        Dispatched job JOB-74
        SOURCE_DISABLE job started for "racPDB".
        Disabling virtual database "racPDB".
        Unexporting storage containers.
        Virtual database "racPDB" disabled.
        SOURCE_DISABLE job for "racPDB" completed successfully.
    mwdlpx-6.0.7.0.dcol1 source 'racPDB'>
    
  3. Change the environment user and repository ( ORACLE_HOME ) for the vPDB to the appropriate user from the new host.
    mwdlpx-6.0.7.0.dcol1 source 'racPDB'> /sourceconfig/
    mwdlpx-6.0.7.0.dcol1 sourceconfig> select racPDB
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racPDB'> update
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racPDB' update *> set repository=mwtestz/'/u01/app/oracle/product/12.1.0.2/dbhome_1'
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racPDB' update *> set environmentUser=mwtestz/oracle
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racPDB' update *> commit
        Dispatched job JOB-76
        SOURCE_CONFIG_UPDATE job started for "racPDB".
        SOURCE_CONFIG_UPDATE job for "racPDB" completed successfully.
    
  4. Change the environment user and repository ( ORACLE_HOME ) for the vCDB to the appropriate user from the new host. This must match the settings in step 3. The instance configuration must also be configured to the new hosts.
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racPDB'> /sourceconfig/
    mwdlpx-6.0.7.0.dcol1 sourceconfig> select racCDB
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB'> update
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB' update *> set repository=mwtestz/'/u01/app/oracle/product/12.1.0.2/dbhome_1'
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB' update *> set environmentUser=mwtestz/oracle
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB' update *> edit instances
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB' update instances *> ls
    Properties
        0:
            type: OracleRACInstance
            instanceName: racCDB1
            instanceNumber: 1
            node: mwtestx1
        1:
            type: OracleRACInstance
            instanceName: racCDB2
            instanceNumber: 2
            node: mwtestx2
    
    Use the "add" command to add an element to this array.
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB' update instances *> set 0.node=mwtestz1
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB' update instances *> set 1.node=mwtestz2
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB' update instances *> commit
        Dispatched job JOB-77
        SOURCE_CONFIG_UPDATE job started for "racCDB".
        SOURCE_CONFIG_UPDATE job for "racCDB" completed successfully.
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB'>
    
  5. Enable the vPDB.
    mwdlpx-6.0.7.0.dcol1 sourceconfig 'racCDB'> /source
    mwdlpx-6.0.7.0.dcol1 source> select racPDB
    mwdlpx-6.0.7.0.dcol1 source 'racPDB'> enable
    mwdlpx-6.0.7.0.dcol1 source 'racPDB' enable *> commit
        Dispatched job JOB-78
        SOURCE_ENABLE job started for "racPDB".
        Enabling dataset "racPDB".
        Exporting storage containers from the Delphix Engine.
        Mounting datasets.
        Mounting filesystems for the virtual database instance "2".
        Starting virtual database.
        Starting instance 2 on virtual database "racCDB".
        Virtual database "racCDB" was successfully started.
        Starting virtual database.
        Starting instance 2 on virtual database "racPDB".
        Plugging in Oracle pluggable database.
        Opening Oracle pluggable database.
        Setting OMF destination for Oracle pluggable database.
        Creating PDB tempfiles.
        Checking Oracle pluggable database plugin violations.
        Virtual database "racPDB" was successfully started.
        Mounting datasets.
        Mounting filesystems for the virtual database instance "1".
        Starting virtual database.
        Starting instance 1 on virtual database "racCDB".
        Virtual database "racCDB" was successfully started.
        Starting virtual database.
        Starting instance 1 on virtual database "racPDB".
        Opening Oracle database.
        Checking Oracle pluggable database plugin violations.
        Virtual database "racPDB" was successfully started.
        Dataset "racPDB" enabled.
        SOURCE_ENABLE job for "racPDB" completed successfully.
    mwdlpx-6.0.7.0.dcol1 source 'racPDB'>