Skip to content

dx_get_db_env

Marcin Przepiorowski edited this page Oct 10, 2016 · 12 revisions

SYNOPSIS

dx_get_db_env.pl [-engine|d <delphix identifier> | -all ] 
                 [-group group_name | -name db_name | -host host_name | -type dsource|vdb ] 
                 [-save]
                 [-parentlast l|p] 
                 [-config]
                 [-backup path] 
                 [-hostenv h|e] 
                 [-format csv|json ] 
                 [-help|? ] [ -debug ]

DESCRIPTION

Get the information about databases.

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

Filters

Filter databases using one of the following filters

  • -group Group Name
  • -name Database Name
  • -host Host Name
  • -type Type (dsource|vdb)
  • -envname Environment name
  • -dsource dsourcename Dsource name

Instance option

Specify a instance number (only with combination with host)

  • -instance inst_no Instance number

OPTIONS

  • -config Display a config of databases (db type, version, instance / Oracle home) plus others
  • -backup path Gnerate a dxToolkit commands to recreate databases ( Oracle / MS SQL support ) into path
  • -parentlast l|p Change a snapshot column to display : l - a last snapshot time (default) p - parent snapshot for VDB
  • -hostenv h|e Change a hostname/env column to display : h - target host name (default) e - target environment name
  • -format Display output in csv or json format If not specified pretty formatting is used.
  • -help Print this screen
  • -debug Turn on debugging
  • -save <filename > Save enabled column into JSON file <filename.engine_name> to restore it later using dx_ctl_db.pl
  • -nohead Turn off header output

Delphix

Clone this wiki locally