Skip to content

dx_provision_vdb

Jump to bottom
Marcin Przepiorowski edited this page Oct 12, 2016 · 18 revisions

SYNOPSIS

dx_provision_vdb.pl [ -engine|d <delphix identifier> | -all ]  
-group group_name 
-sourcename src_name 
-targetname targ_name 
-dbname db_name | -path vfiles_mountpoint 
-environment environment_name 
-type oracle|mssql|sybase|vFiles 
-envinst OracleHome/MSSQLinstance/SybaseServer
[-creategroup]
[-srcgroup Source group]
[-timestamp LATEST_SNAPSHOT|LATEST_POINT|time_stamp]
[-template template_name] 
[-mapfile mapping_file]  
[-instname SID] 
[-uniqname db_unique_name] 
[-mntpoint mount_point ]
[-noopen]
[-truncateLogOnCheckpoint]
[-archivelog yes/no]
[-postrefresh pathtoscript ]
[-configureclone pathtoscript ]
[-prerefresh  pathtoscript ]  
[-prescript pathtoscript ]
[-postscript pathtoscript ]
[-recoveryModel model ]
[-additionalMount envname,mountpoint,sharedpath]
[-rac_instance env_node,instance_name,instance_no ]
[-redoGroup N]
[-redoSize N]
[-listeners listener_name]
[-hooks path_to_hooks]
[-envUser username]
[-help] [-debug]

DESCRIPTION

Provision VDB from a defined source on the defined target 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

VDB arguments

  • -type type Type (oracle|mssql|sybase|vFiles)

  • -group name Group Name

  • -creategroup Specify this option to create a new group on Delphix Engine while proviioning a new VDB

  • -sourcename name dSource Name

  • -targetname name Target name

  • -dbname name Target database name

  • -path path Mount point location for vFiles

  • -srcgroup Source group Group name where source is located

  • -timestamp timestamp Time stamp formats:

    YYYY-MM-DD HH24:MI:SS or LATEST_POINT for point in time,

    @YYYY-MM-DDTHH24:MI:SS.ZZZ , YYYY-MM-DD HH24:MI or LATEST_SNAPSHOT for snapshots. @YYYY-MM-DDTHH24:MI:SS.ZZZ is a snapshot name from dx_get_snapshot, while YYYY-MM-DD HH24:MI is a snapshot time in GUI format

    Default is LATEST_SNAPSHOT

  • -location location Point in time defined by SCN for Oracle and LSN for MS SQL

  • -environment environment_name Target environment name

  • -envinst environment_instance Target environment Oracle Home, MS SQL server instance, Sybase server name, etc

  • -template template_name Target VDB template name (for Oracle)

  • -mapfile filename Target VDB mapping file (for Oracle)

  • -instname instance_name Target VDB instance name (for Oracle)

  • -uniqname db_unique_name Target VDB db_unique_name (for Oracle)

  • -mntpoint path Set a mount point for VDB (for Oracle)

  • -noopen Don't open database after provision (for Oracle)

  • -archivelog yes/no Create VDB in archivelog (yes - default) or noarchielog (no) (for Oracle)

  • -truncateLogOnCheckpoint Truncate a log on checkpoint. Set this parameter to enable truncate operation (for Sybase)

  • -postrefresh pathtoscript Post refresh hook

  • -configureclone pathtoscript Configure Clone hook

  • -prerefresh pathtoscript Prerefresh hook

  • -prescript pathtoscript Path to prescript on Windows target

  • -postscript pathtoscript Path to postscript on Windows target

  • -recoveryModel model Set a recovery model for MS SQL database. Allowed values BULK_LOGGED,FULL,SIMPLE

  • -additionalMount envname,mountpoint,sharedpath Set an additinal mount point for vFiles - using a syntax environment_name,mount_point,sharedpath

    ex. -additionalMount target1,/u01/app/add,/

  • -rac_instance env_node,instance_name,instance_no Comma separated information about node name, instance name and instance number for a RAC provisioning Repeat option if you want to provide information for more nodes

    ex. -rac_instance node1,VBD1,1 -rac_instance node2,VBD2,2

  • -redoGroup N Create N redo groups

  • -redoSize N Each group will be N MB in size

  • -listeners listener_name Use listener named listener_name

  • -hooks path_to_hooks Import hooks exported using dx_get_hooks

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

OPTIONS

  • -help
    Print usage information
  • -debug Turn on debugging

EXAMPLES

Provision an Oracle VDB using latest snapshot

dx_provision_vdb -d Landshark -sourcename "Employee Oracle DB" -dbname autoprov -targetname autoprov -group Analytics -environment LINUXTARGET -type oracle -envinst "/u01/app/oracle/product/11.2.0/dbhome_1"
Starting provisioning job - JOB-232
0 - 7 - 11 - 13 - 18 - 40 - 48 - 52 - 56 - 58 - 59 - 60 - 62 - 63 - 75 - 100
Job JOB-232 finised with state: COMPLETED VDB created.

Provision a Sybase VDB using a latest snapshot

dx_provision_vdb -d Landshark -group Analytics -sourcename 'ASE pubs3 DB' -targetname testsybase -dbname testsybase -environment LINUXTARGET -type sybase -envinst LINUXTARGET
Starting provisioning job - JOB-158139
0 - 11 - 15 - 75 - 100
Job JOB-158139 finised with state: COMPLETED

Provision a Sybase VDB using a snapshot name "@2015-09-08T08:46:47.000" (to list snapshots use dx_get_snapshots)

dx_provision_vdb -d Landshark -group Analytics -sourcename 'ASE pubs3 DB' -targetname testsybase -dbname testsybase -environment LINUXTARGET -type sybase -envinst LINUXTARGET -timestamp "@2015-09-08T08:46:47.000" 
Starting provisioning job - JOB-158153
0 - 11 - 15 - 63 - 100
Job JOB-158153 finised with state: COMPLETED VDB created.

Privision a vFiles using a latest snapshot

dx_provision_vdb -d Landshark43 -group Analytics -sourcename "files" -targetname autofs -path /mnt/provision/home/delphix -environment LINUXTARGET -type vFiles
Starting provisioning job - JOB-798
0 - 7 - 11 - 75 - 100
Job JOB-798 finised with state: COMPLETED VDB created.

Privision a empty vFiles

dx_provision_vdb -d Landshark5 -type vFiles -group "Test" -creategroup -empty -targetname "vFiles" -dbname "/home/delphix/de_mount" -environment "LINUXTARGET" -envinst "Unstructured Files"  -envUser "delphix"
Starting provisioning job - JOB-900
0 - 7 - 11 - 75 - 100
Job JOB-900 finised with state: COMPLETED VDB created.

Privision a MS SQL using a latest snapshot

dx_provision_vdb -d Landshark -group Analytics -sourcename AdventureWorksLT2008R2 -targetname autotest - dbname autotest -environment WINDOWSTARGET -type mssql -envinst MSSQLSERVER
Starting provisioning job - JOB-158159
0 - 3 - 11 - 18 - 75 - 100
Job JOB-158159 finised with state: COMPLETED VDB created.

Privision a MS SQL using a snapshot from "2015-09-23 10:23"

dx_provision_vdb -d Landshark -group Analytics -sourcename AdventureWorksLT2008R2 -targetname autotest - dbname autotest -environment WINDOWSTARGET -type mssql -envinst MSSQLSERVER -timestamp "2015-09-23 10:23" 
Starting provisioning job - JOB-158167
0 - 3 - 11 - 18 - 67 - 75 - 100
Job JOB-158167 finised with state: COMPLETED VDB created.

Delphix

Clone this wiki locally