CLI cookbook: Oracle VDB migration

This topic describes moving a VDB from one environment or installation to another.

VDBs can be moved (or migrated) between hosts by changing the source repository associated with the VDB source config.

Restrictions

The following restrictions apply when migrating a VDB between repositories:

When migrating a RAC VDB, the host of each OracleRACInstance must be updated as well.
The mount point of the VDB source cannot be changed.
The database_unique_name and db_name cannot be changed.
The new environment and repository must be a compatible target environment.

Procedure

Select the source associated with the VDB. By default, sources are named the same as the VDB.
CODE
```
delphix> source "vexample"
```

Disable the source by running the disablecommand and committing the operation.

CODE

delphix source "vexample"> disable
delphix source "vexample" disable *> commit
    Dispatched job JOB-171
    SOURCE_DISABLE job started for "vexample".
    Starting disable of virtual database.
    Unexporting storage.
    Virtual database disable successful.
    SOURCE_DISABLE job for "vexample" completed successfully. 
delphix source "vexample">

Select the source config associated with the source. By default this is also the same name as the VDB.
Update the repository and repository user associated with the source config.
CODE
```
delphix source "vexample"> get config
    vexample
delphix source "vexample"> /sourceconfig "vexample"
delphix sourceconfig "vexample">
```
Update the repository and repository user associated with the source config.

Warning: You must use the Environment name of the Environment because the repository requires the environment name and Oracle home location. Enable the source.

CODE

delphix sourceconfig "vexample"> update
delphix sourceconfig "vexample" update *> set repository=192.168.100.247/'/opt/oracle/product/10.2.0.4/db_1'
delphix sourceconfig "vexample" update *> set environmentUser=192.168.100.247/ora1024
delphix sourceconfig "vexample" update *> commit
delphix sourceconfig "vexample">

Enable the source.

CODE

delphix sourceconfig "vexample"> /source "vexample" enable
delphix source "vexample" enable *> commit
    Dispatched job JOB-18
    SOURCE_ENABLE job started for "vexample".
    Enabling dataset "vexample".
    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 "vexample".
    Virtual database "vexample" was successfully started.
    Dataset "vexample" enabled.
    SOURCE_ENABLE job for "vexample" completed successfully.
delphix sorceconfig "vexample">