Skip to content
Marcin Przepiorowski edited this page Dec 9, 2016 · 8 revisions

SYNOPSIS

dx_v2p   [ -engine|d <delphix identifier> | -all ] 
           -sourcename src_name  
           -dbname db_name 
           -environment environment_name 
           -type oracle|mssql 
           -envinst OracleHome/MSSQLinstance
           -targetDirectory target_directory 
         [ -timestamp LATEST_SNAPSHOT|LATEST_POINT|time_stamp]
         [ -template template_name] 
         [ -mapfile mapping_file]  
         [ -instname SID] 
         [ -uniqname db_unique_name] 
         [ -archiveDirectory arch_directory] 
         [ -dataDirectory data_dir]
         [ -externalDirectory external_dir] 
         [ -tempDirectory temp_dir]
         [ -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

V2P arguments

  • -type Type (oracle|mssql)
  • -sourcename dSource/VDB Name
  • -targetDirectory Target directory
  • -dbname Target 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
  • -envinst Target environment Oracle Home or MS SQL server instance
  • -template Target VDB template name (for Oracle)
  • -mapfile Target VDB mapping file (for Oracle)
  • -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

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 proces

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.

Delphix

Clone this wiki locally