dx_snapshot_db

SYNOPSIS

dx_snapshot_db    [ -engine|d <delphix identifier> | -all ] [ -configfile file ]
                  < -group group_name | -name db_name | -host host_name | -type dsource|vdb >
                  [ -usebackup yes|no ]
                  [ -backupfileslist backupfile1,backupfile2,...]
                  [ -backupfilesfile /path/to/file_with_backup ]
                  [ -backupuuid uuid ]
                  [ -fullbackup ]
                  [ -doublesync ]
                  [ -help|? ]
                  [ -debug ]
                  [ -parallel p ]

DESCRIPTION

Run the snapshot for all database(s) selected by filter on selected engine(s)

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

Filters

• -group Group Name
• -name Database Name
• -host Host Name
• -type Type (dsource|vdb)
• -dsource name Name of dSource

OPTIONS

• -usebackup yes|no For MS SQL / Sybase dSource only - if this flag is set to yes - snapshot will to loaded from last known backup, if flag is set to no Delphix Engine will run full backup Default value is no
• -backupfileslist backupfile1,backupfile2,... For Sybase dSource only - specify a list of backup files as a list of comma separated backup file names
• -backupfilesfile /path/to/file_with_backup For Sybase dSource only - specify a file contains a list of backup files. One file per line
• -backupuuid uuid For MS SQL only - UUID of backup to ingest
• -fullbackup For Oracle only - Force full an Oracle backup
• -doublesync For Oracle only - Enable double sync
• -resync For plugins supporting resync
• -help Print this screen
• -debug Turn on debugging
• -parallel maxjob Run action on all targets in parallel. Limit number of jobs to maxjob.

EXAMPLES

Take snapshot of database "autoprov"

dx_snapshot_db -d Landshark -name autoprov
Starting job JOB-251 for database autoprov.
0 - 95 - 100
Job JOB-251 finised with state: COMPLETED

Take snapshot of all databases provisioned from dSource "Sybase dsource"

dx_snapshot_db -d Landshark51 -dsource "Sybase dsource"
Starting job JOB-191 for database testsybase.
0 - 100
Job JOB-191 finished with state: COMPLETED
Starting job JOB-192 for database testvdb.
0 - 100
Job JOB-192 finished with state: COMPLETED

Take full backup snapshot of dSource "test121"

dx_snapshot_db -d Landshark5 -name test121 -fullbackup
Starting job JOB-7554 for database test121.
0 - 3 - 8 - 15 - 17 - 22 - 29 - 33 - 39 - 45 - 50 - 54 - 58 - 62 - 65 - 70 - 75 - 78 - 100
Job JOB-7554 finished with state: COMPLETED