Skip to content

dx_rewind_db

Marcin Przepiorowski edited this page Jan 10, 2019 · 4 revisions

SYNOPSIS

dx_rewind_db  [ -engine|d <delphix identifier> | -all ] [ -configfile file ]
              < -group group_name | -name db_name | -host host_name | -type dsource|vdb >
              [ -timestamp timestamp]
              [ -help|? ]
              [ -debug ]
              [-parallel p]

DESCRIPTION

Rewind database(s) selected by filter on selected engine(s) to the spefified point in time.

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 dsourcename Dsource name

OPTIONS

  • -timestamp Time stamp for export format (YYYY-MM-DD HH24:MI:SS in VBD timezone) or LATEST_POINT or LATEST_SNAPSHOT or bookmark name Default is LATEST_SNAPSHOT
  • -location Point in time defined by SCN for Oracle and LSN for MS SQL
  • -help Print this screen
  • -debug Turn on debugging
  • -parallel maxjob Run action on all targets in parallel. Limit number of jobs to maxjob.

EXAMPLES

Single VDB rewind to the last snapshot

dx_rewind_db -d Landshark -name autoprov
Starting job JOB-244 for database autoprov.
0 - 25 - 32 - 36 - 38 - 43 - 65 - 73 - 77 - 81 - 83 - 85 - 86 - 87 - 88 - 100
Job JOB-244 finised with state: COMPLETED

Single VDB rewind to the snapshot take at 2015-10-14 00:41

dx_rewind_db -d Landshark43 -name testsybase -timestamp '2015-10-14 00:41'
Starting job JOB-820 for database testsybase.
1 - 2 - 6 - 25 - 36 - 40 - 100
Job JOB-820 finised with state: COMPLETED
You can’t perform that action at this time.