CLI Cookbook: V2P: Virtual to Physical of a Single Instance Oracle Database
Reference / Command Line Interface Guide / CLI Cookbook: Common Workflows, Tasks, and Examples / CLI Cookbook: VDBs / CLI Cookbook: V2P: Virtual to Physical of a Single Instance Oracle Database

This topic describes how to provision a physical single instance Oracle database using the Delphix Engine command line interface.

Prerequisites

You will need the following information:

  • The instance name, instance number and unique name of the Oracle database you wish to create
  • The source dSource or VDB from which you wish to provision. 

  • The semanticLocation, SCN, or timestamp of the point you want to provision from. You can run these commands to get the list of snapshots or timeflow ranges:

    snapshot list database=dexample
timeflow "dexample" timeflowRanges; commit
  • The layout of the filesystems on the target server where data should be exported.

  • The source repository (oracle install)  in which to create the VDB. These can be listed with the /repository list command.

Procedure

  1. Execute the database export command.

    delphix> database export

  2. Set the timeflow point type, source container and location.

    delphix database export *> set timeflowPointParameters.type=TimeflowPointSemantic
delphix database export *> set timeflowPointParameters.container=dexample
delphix database export *> set timeflowPointParameters.location=LATEST_SNAPSHOT

  3. Edit the sourceConfig configuration, specifying the parameters for the database created via V2P.

    delphix database export *> edit sourceConfig
delphix database export sourceConfig *> set type=OracleSIConfig 
delphix database export sourceConfig *> edit instance
delphix database export sourceConfig instance *> ls
delphix database export sourceConfig instance *> set instanceName=v2p_db
delphix database export sourceConfig instance *> set instanceNumber=1
delphix database export sourceConfig instance *> back
delphix database export sourceConfig *> set repository=tserver/'/u01/app/ora11204/product/11.2.0/dbhome_1' 
delphix database export sourceConfig *> set uniqueName=v2p_db
delphix database export sourceConfig *> back

  4. Set the destination locations.

    delphix database export *> set filesystemLayout.targetDirectory=/oradata/v2p_db
delphix database export *> set filesystemLayout.archiveDirectory=archive 
delphix database export *> set filesystemLayout.dataDirectory=datafiles 
delphix database export *> set filesystemLayout.externalDirectory=external 
delphix database export *> set filesystemLayout.scriptDirectory=script 
delphix database export *> set filesystemLayout.tempDirectory=temp

  5. Commit the configuration to execute the job.

    delphix database export *> commit