Virtual to Physical (V2P) operation on a non-multitenant virtual Oracle database to ASM or Physical Filesystem

This topic describes how to perform the V2P operation or in-place conversion on a non-multitenant virtual database to a physical database using the Delphix Engine command-line interface. This procedure will work irrespective of the VDB being a single instance configuration or RAC.

Prerequisites

You must have the following configuration before starting the in-place V2P operation:

For the V2P operation to ASM – the target Data diskgroup, or the diskgroup that will contain all the database files, or if exporting to a physical filesystem – the filesystem path where all the datafiles will be exported and the filesystem path where all the redo log files will be exported.
For the V2P operation to physical filesystem:
- the filesystem path where all the datafiles will be exported, and the filesystem path where all the redo log files will be exported.
- both the delphix_os user and the Oracle software owner user (typically oracle) must have full access to the provided directories where all the datafiles and redo/archived log files will be exported.
The VDB from which the V2P operation to ASM or physical filesystem will be initiated.
Optionally, the target ASM disk group for redo log files (for the V2P operation on ASM), database unique name for the resulting physical database and the number of RMAN channels.

Ensure that a database instance with the same unique name as the VDB is not running on the target host before starting the below procedure, otherwise the V2P operation will fail.

Procedure

Execute the database export command.
```
delphix> database export
```

Set the database export parameters type, transfer strategy type, storage strategy type, default target data diskgroup, data directory, archive directory and virtual source.

For the V2P operation to ASM:

delphix database export *> set type=OracleDBExportParameters
delphix database export *> set storageStrategy.type=OracleExportASMStorageStrategy
delphix database export *> set storageStrategy.asmLayout.defaultDataDiskgroup=+DATA
delphix database export *> set transferStrategy.type=OracleExportDBInPlaceTransferStrategy
delphix database export *> set transferStrategy.virtualSource=v2p_db

The above values are just examples. Replace the default data diskgroup and virtual source name to match your needs.

For the V2P operation to Physical Filesystem:

delphix database export *> set type=OracleDBExportParameters  
delphix database export *> set storageStrategy.type=OracleExportFilesystemStorageStrategy 
delphix database export *> set storageStrategy.filesystemLayout.type=OracleFilesystemLayout  
delphix database export *> set storageStrategy.filesystemLayout.dataDirectory=/v2p_db/data 
delphix database export *> set storageStrategy.filesystemLayout.archiveDirectory=/v2p_db/archive  
delphix database export *> set transferStrategy.type=OracleExportDBInPlaceTransferStrategy 
delphix database export *> set transferStrategy.virtualSource=v2p_db

The above values are just examples. Replace the dataDirectory, archiveDirectory and virtual source name to match your needs. both the delphix_os user and the Oracle software owner user (typically oracle) must have full access to the provided dataDirectory and archiveDirectory.

Optionally set the following parameters:
1. Set the storageStrategy.asmLayout.redoDiskgroup value for target ASM disk group for redo log files (for the V2P operation on ASM).
2. Set the transferStrategy.dbUniqueName to add a database unique name for the resulting physical database.
  1. If no database unique name is specified, the default is the unique name of the VDB.
  2. If a database unique name is specified, as noted in step 2 of this procedure, you need to ensure that a database instance with the same database unique name is not running on the target host.
3. Set the transferStrategy.rmanChannels to define the number of RMAN channels. Default value for the RMAN channels is 8.
4. Set the transferStrategy.rmanFileSectionSizeInGb. Default value is 0 (i.e. RMAN file section size is not set).
5. Set the storageStrategy.ignoreInsufficientSpaceCheck to ignore any validation error if sufficient space is not available on ASM diskgroup. By default, the value is set to false.
```
delphix database export *> set storageStrategy.asmLayout.redoDiskgroup=+REDO
delphix database export *> set transferStrategy.dbUniqueName=v2asm_db
delphix database export *> set transferStrategy.rmanChannels=10
delphix database export *> set transferStrategy.rmanFileSectionSizeInGb=64
delphix database export *> set storageStrategy.ignoreInsufficientSpaceCheck=true 
```
  The above values are just examples. Replace the redo diskgroup, database unique name, number of RMAN channels and RMAN file section size to match your needs. For more details on RMAN channels and RMAN file section size, refer to Performance tuning considerations for Oracle databases with bigfile tablespaces.
Commit the configuration to execute the job.
```
delphix database export *> commit
```

The V2P operation takes a snapshot of the VDB before proceeding with the file transfer. After a successful V2P operation, the original VDB will be left in a DISABLED state. If the VDB needs to be re-enabled, the VDB needs to be migrated to a different host. Ensure there is no instance running with the same name as the VDB on the target host. Subsequently, you must rewind the VDB to the latest snapshot, after which the VDB will be back up and running. Since the V2P operation takes a snapshot before the actual file transfer, the rewind can be performed to the point just before the start of the V2P operation.

Refer to the Perform V2P operation on Oracle VDBs or vPDBs in-place to ASM or Perform V2P operation on Oracle VDBs or vPDBs in-place to physical filesystems for additional considerations after a successful V2P.

Last updated

Oct 9, 2026