CLI cookbook: V2P (Virtual to Physical) of a single instance Oracle database with datafiles on separate file systems

This topic describes how to provision a physical single-instance Oracle database, with datafiles on separate file systems, using the Delphix Engine command-line interface.

By default, all of the customizable directories - data, archive, temp, external, and script will be placed under the target directory, with additional config files placed in the target directory itself. This provides no mechanism to place datafiles on separate file systems (i.e. /data1 and /data2, which have the root directory as a common point). In order to allow this, the useAbsolutePathForDataFiles parameter must be specified.

Prerequisites

You will need the following information:

  • The instance name, instance number, and unique name of the Oracle database to create.

  • The source dSource or VDB from which to provision.

  • The semanticLocation, SCN, or timestamp of the point of which to provision from. Run these commands to get the list of snapshots or Timeflow ranges:

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

    Copy 
    delphix> database export

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

    Copy 
    delphix database export *> set timeflowPointParameters.type=TimeflowPointSemanticdelphix 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.

    Copy 
    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, including setAbsolutePathForDataFiles to be true.

    Copy 
    delphix database export *> set filesystemLayout.targetDirectory=/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=tempdelphix 
    database export *> set filesystemLayout.useAbsolutePathForDataFiles=true

  5. Specify the file mapping rules for each datafile and the location to which it should be exported. Each entry should be separated by a newline, and the entire mapping within double quotes.

    Copy 
    set fileMappingRules="/u01/app/oracle/oradata/datafile1.dbf:/data1/datafile1.dbf
    /u01/app/oracle/oradata/datafile2.dbf:/data1/datafile2.dbf
    /u01/app/oracle/oradata/datafile3.dbf:/data2/datafile3.dbf
    /u01/app/oracle/oradata/datafile4.dbf:/data2/datafile4.dbf"

  6. Commit the configuration to execute the job.

    Copy 
    delphix database export *> commit