Skip to main content
Skip table of contents

CLI cookbook: V2P: virtual to physical of a single instance non-multitenant Oracle database

This topic describes how to provision a physical single instance non-multitenant 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:

    ACTIONSCRIPT3
    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. 

    CODE
    delphix> database export
  2. Set the Timeflow point type, source container, and location.

    CODE
    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.

    CODE
    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 *> set databaseName=v2p_db
    delphix database export sourceConfig *> back
  4. Set the destination locations.

    CODE
    delphix database export *> set filesystemLayout.targetDirectory=//u01/app/oracle/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.

    ACTIONSCRIPT3
    delphix database export *> commit
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.