dx_get_template

SYNOPSIS

dx_get_template    [ -engine|d <delphix identifier> | -all ]
                   [ -configfile file ]
                   [ -name template_name ]
                   [ -parameters | -compare file]
                   [ -export -outdir dir]
                   [ -format csv|json ]
                   [ -help|? ]
                   [ -debug ]

DESCRIPTION

List or export database template from engine. If no template name is specified all templates will be processed.

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

• -name Template name

OPTIONS

• -parameters Display parameters from template
• -compare file Compare template with init.ora file ignoring restritcted parameters Exit code will be 0 if no difference found.
• -export Export template into JSON file in outdir directory
• -outdir Location of exported templates files
• -format Display output in csv or json format If not specified pretty formatting is used.
• -help Print this screen
• -debug Turn on debugging

EXAMPLES

Display list of VDB templates

dx_get_template -d Landshark43

Appliance            Template name
-------------------- ------------------------------
Landshark43          Training Template
Landshark43          QA Template
Landshark43          Dev Template
Landshark43          new

Export all VDB templates into /tmp/test directory

dx_get_template -d Landshark -export -outdir /tmp/test/
Exporting template into file /tmp/test//Dev Template.template
Exporting template into file /tmp/test//Training Template.template
Exporting template into file /tmp/test//new.template
Exporting template into file /tmp/test//GC Template.template
Exporting template into file /tmp/test//QA Template.template

Compare templare with initSID.ora file

dx_get_template -d Landshark51  -name test123 -compare initTEST.ora

Appliance            Parameter                      value in template              value in init
-------------------- ------------------------------ ------------------------------ ------------------------------
Landshark51          compatible                     11.2.0.4.0                     12.2.0.1
Landshark51          sga_target                     522M                           400M
Landshark51          open_cursors                   300                            NA
Landshark51          pga_aggregate_target           200M                           NA
Landshark51          processes                      700                            NA
Landshark51          remote_login_passwordfile      'EXCLUSIVE'                    NA