dx_provision_dsource

SYNOPSIS

dx_provision_dsource.py --type <name> --dsource_name <name> \
                        --ip_addr <name> --db_name <name> --env_name <name> \
                        --db_install_path <name> --dx_group <name> --db_passwd <name> \
                        --db_user <name>
                        [--port_num <name> --num_connections <name> --link_now <name>]
                        [--files_per_set <name> --rman_channels <name>]
                        [--engine <identifier>]
                        [--poll <n> --config <path_to_file> --logdir <path_to_file>]

dx_provision_dsource.py --type <name> --dsource_name <name> \
                        --ase_user <name> --ase_passwd <name> --backup_path <name> \
                        --source_user <name> --stage_user <name> --stage_repo <name> \
                        --src_config <name> --env_name <name> --dx_group <name>
                        [--bck_file <name> --create_bckup]
                        [--engine <identifier>]
                        [--poll <n> --config <path_to_file> --logdir <path_to_file>]

dx_provision_dsource.py --type <name> --dsource_name <name> \
                        --dx_group <name> --db_passwd <name> --db_user <name> \
                        --stage_instance <name> --stage_env <name> --backup_path <name>
                        [--backup_loc_passwd <passwd> --backup_loc_user <name> --logsync]
                        [--sync_mode <mode> --load_from_backup --single_thread <bool>]
                        [--engine <identifier>]
                        [--poll <n> --config <path_to_file> --logdir <path_to_file>]

dx_provision_dsource.py -h | --help | -v | --version

DESCRIPTION

This script can be used to create a dSource.

ARGUMENTS

--typeRequired
dSource type. mssql | sybase | oracle
--db_nameRequired
Name of the dSource database
--db_nameRequired
Name of the dSource in Delphix
--ip_addrRequired
IP address of the dSource
--env_nameRequired
Name of the environment where the dSource installed
--dx_groupOptional
Group where the dSource will reside
--db_install_pathRequired
Install location of the DB instance
--db_userRequired
Database user to connect to the source DB
--db_passwdRequired
Database user password to connect to the source DB
--port_numOptional
Port where Oracle listener is running. Default is 1521
--num_connectionsOptional
Number of connections for Oracle RMAN. Default is 5
--link_nowOptional
Whether to link the dSource now or not. Default is True
--files_per_setOptional
Configures how many files per set for Oracle RMAN. Default is 5
--rman_channelsOptional
Number of connections for Oracle RMAN. Default is 2
--stage_envRequired for mssql
Name of the stage environment for SQL Server
--stage_instanceRequired for mssql
Name of the staging instance
--backup_pathRequired for ase, mssql
Path to the ASE/MSSQL backups
**--backup_loc_passwd **Required for mssql
Password of the shared backup path
--backup_loc_userRequired for mssql
User of the shared backup path
--load_from_backupOptional
If set, Delphix will try to load the most recent full backup (MSSQL only)
--sync_modeRequired for mssql
MSSQL validated sync mode TRANSACTION_LOG|FULL_OR_DIFFERENTIAL|FULL|NONE. [default: FULL]
--create_bckupOptional for ase
Create and ingest a new Sybase backup. default: False
--back_fileOptional for ase
Fully qualified name of the sybase backup file
--ase_userRequired for ase
ASE DB user name
--ase_passwdRequired for ase
ASE DB user password
--src_configRequired for ase
Name of the configuration environment
--stage_userRequired for ase
Stage environment OS user
--source_userRequired for ase
Source environment OS user

COMMON ARGUMENTS

-engineOptional
Specify name of the Delphix Engine from dxtools.conf file. To run on all engines, provide 'all' as engine name.
--config Optional
Location of the configuration file.
A config file search order is as follows:
config parameter
dxtools.conf inside /conf/ folder
--logdir Optional
Location of the log file.
A log file search order is as follows:
Logdir parameter which includes the filename
File with the same name as the script under /conf/ folder
--single_thread Optional
Defines whether the operations on an engine is run synchronously or asynchronously.
Default is False
--poll Optional
Defines the # of seconds to sleep before polling for the status of a job.

EXAMPLES

Provision an Oracle dSource:

dx_provision_dsource.py --type oracle --dsource_name oradb1 \
--ip_addr 192.168.166.11 --db_name srcDB1 --env_name SourceEnv \
--db_install_path /u01/app/oracle/product/11.2.0.4/dbhome_1 \
--db_user delphixdb --db_passwd delphixdb --single_thread False

Provision a Sybase dSource by specifying a backup location:

dx_provision_dsource.py --type sybase --dsource_name dbw1 --ase_user sa \
--ase_passwd sybase --backup_path /data/db --source_user aseadmin \
--stage_user aseadmin --stage_repo ASE1570_S2 --src_config dbw1 \
--env_name aseSource --dx_group Sources --single_thread False

Provision a Sybase dSource by specifying backup files:

dx_provision_dsource.py --type sybase --dsource_name dbw2 --ase_user sa \
--ase_passwd sybase --backup_path /data/db --source_user aseadmin \
--stage_user aseadmin --stage_repo ASE1570_S2 --src_config dbw2 \
--env_name aseSource --dx_group Sources --bck_file "dbw2data.dat"

Provision a Sybase dSource by creating and ingesting a new backup:

dx_provision_dsource.py --type sybase --dsource_name dbw2 --ase_user sa \
--ase_passwd sybase --backup_path /data/db --source_user aseadmin \
--stage_user aseadmin --stage_repo ASE1570_S2 --src_config dbw2 \
--env_name aseSource --dx_group Sources --create_bckup

Provision a dSource from MSSQL source with a backup path:

dx_provision_dsource.py --type mssql  --dsource_name mssql_dsource \
--dx_group Sources --db_passwd delphix --db_user sa \
--stage_env mssql_target_svr --stage_instance MSSQLSERVER \
--backup_path \\bckserver\path\backups --backup_loc_passwd delphix \
--backup_loc_user delphix

Provide feedback

Saved searches