Skip to content

dx_v2p

Jump to bottom
Marcin Przepiorowski edited this page Jan 26, 2023 · 8 revisions

SYNOPSIS

dx_v2p   [ -engine|d <delphix identifier> | -all ] [ -configfile file ]
           -sourcename src_name
           -dbname db_name
           -environment environment_name
           -type oracle|mssql|sybase
           -envinst OracleHome/MSSQLinstance/SybaseInstance
         [ -targetDirectory target_directory ]
         [ -envUser username]
         [ -timestamp LATEST_SNAPSHOT|LATEST_POINT|time_stamp ]
         [ -template template_name ]
         [ -mapfile mapping_file ]
         [ -norecovery ]
         [ -noopen ]
         [ -instname SID ]
         [ -uniqname db_unique_name ]
         [ -archiveDirectory arch_directory ]
         [ -dataDirectory data_dir ]
         [ -externalDirectory external_dir ]
         [ -tempDirectory temp_dir ]
         [ -useabsolute ]
         [ -dspconnections=n ]
         [ -dspusecompression ]
         [ -dspuseencryption ]
         [ -concurrentfiles=n ]
         [ -help]
         [ -debug]

DESCRIPTION

Run virtual to physical process of database specified by sourcename into specified environment

ARGUMENTS

Delphix Engine selection - if not specified a default host(s) from dxtools.conf will be used.

  • -engine|d Specify Delphix Engine name from dxtools.conf file
  • -all Display databases on all Delphix appliance
  • -configfile file Location of the configuration file. A config file search order is as follow:
  • configfile parameter
  • DXTOOLKIT_CONF variable
  • dxtools.conf from dxtoolkit location

V2P arguments

  • -type Type (oracle|mssql)

  • -sourcename dSource/VDB Name of database being move to physical

  • -targetDirectory Target directory (mandatory for an Oracle and MS SQL)

  • -dbname Physical database name

  • -timestamp Time stamp for export format (YYYY-MM-DD HH24:MI:SS) or LATEST_POINT or LATEST_SNAPSHOT Default is LATEST_SNAPSHOT

  • -environment Target environment name

  • -envUser username Use an environment user "username" for provisioning database

  • -envinst Target environment Oracle Home or MS SQL server instance

  • -template Target VDB template name (for Oracle)

  • -mapfile Target VDB mapping file. Use colon as separator for both MS SQL and Oracle Dxtoolkit will use a proper separator for API call.

    Oracle mapfile example:

    # this is comment /u01:/u02

    MS SQL mapfile example:

    # this is comment Biscuit_Data_1.ndf : c:\\tmp\\los1\\slon_Data_1.ndf Biscuit_Bogus_1_data.ndf : c:\\tmp\\los2\\slon_Bogus_1_data.ndf

  • -instname Target VDB instance name (for Oracle)

  • -uniqname Target VDB db_unique_name (for Oracle)

  • -archiveDirectory Archive log directory

  • -dataDirectory Datafiles directory

  • -externalDirectory External directory

  • -temp Temp directory

  • -useabsolute Use absolute paths

  • -norecovery Do not run recovery (for MS SQL and Sybase only)

  • -noopen Do not open a database after migration (for an Oracle only)

  • -dspconnections=n Set number of DSP connections (for an Oracle only)

  • -dspusecompression Enable DSP compression (for an Oracle only)

  • -dspuseencryption Enable DSP encryption (for an Oracle only)

  • -concurrentfiles=n Set number of concurrent files being copy (for an Oracle only)

OPTIONS

  • -help Print this screen
  • -debug Turn on debugging

EXAMPLES

Oracle V2P process

dx_v2p -d Landshark -sourcename testdx -dbname v2p -environment LINUXTARGET -type oracle -envinst "/u01/app/oracle/product/11.2.0/dbhome_1" -targetDirectory /data/u02/v2p
Starting provisioning job - JOB-231
0 - 2 - 3 - 5 - 6 - 7 - 8 - 9 - 10 - 12 - 13 - 14 - 15 - 16 - 17 - 18 - 19 - 20 - 21 - 22 - 23 - 25 - 26 - 27 - 28 - 29 - 30 - 31 - 32 - 33 - 34 - 35 - 36 - 37 - 38 - 39 - 40 - 41 - 42 - 43 - 44 - 46 - 47 - 49 - 50 - 51 - 52 - 54 - 55 - 56 - 57 - 58 - 59 - 60 - 61 - 62 - 63 - 64 - 65 - 66 - 67 - 68 - 69 - 70 - 71 - 72 - 73 - 74 - 75 - 76 - 77 - 78 - 79 - 80 - 81 - 82 - 83 - 84 - 85 - 86 - 87 - 88 - 89 - 90 - 92 - 93 - 94 - 95 - 96 - 97 - 98 - 99 - 100
Job JOB-231 finised with state: COMPLETED
V2P job finished with COMPLETED status.

MS SQL V2P process

dx_v2p -d Landshark43 -sourcename autotest -environment WINDOWSTARGET -type mssql -envinst MSSQL2012 -dbname v2p -targetDirectory "c:\temp"
Starting provisioning job - JOB-832
0 - 1 - 5 - 10 - 20 - 80 - 100
Job JOB-832 finised with state: COMPLETED
V2P job finished with COMPLETED status.

Sybase V2P process ( database SYBV2P has to be precreated with for load option )

dx_v2p -d Landshark51 -type sybase -timestamp LATEST_SNAPSHOT -sourcename testsys -dbname SYBV2P -environment LINUXTARGET -envinst LINUXTARGET
Starting provisioning job - JOB-5025
0 - 8 - 9 - 30 - 60 - 90 - 92 - 100
Job JOB-5025 finished with state: COMPLETED
V2P finished..

Delphix

Clone this wiki locally