Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Variable

Variable Description

CSD_PREFLIGHT_CHECK

If set to Y, Dbvisit will create a standby spfile and attempt to start up the standby instance prior to backing up the primary database, when creating the standby database. Dbvisit will report any invalid standby database parameters, and any errors can be fixed straight away.

Default value Y (YES) highly recommended

 

DBV_POST_PROC

If a different named script should be called, then this variable can be set. If no path name is given the Dbvisit Standby install directory is assumed. 

Default value Windows: dbv_post_processing.cmd

Default value Non Windows: dbv_post_processing.sh

See the Pre- and post-processing section for more information.

Example:

    DBV_POST_PROC = post_procs_all.cmd

 

DBV_PRE_POST_PROC

The name of the pre- and post- processing script.  If a different named script should be called, then this variable can be set. If no path name is given the Dbvisit Standby install directory is assumed. 

Default value Windows: dbv_pre_post_processing.cmd

Default value Non Windows: dbv_pre_post_processing.sh

See the Pre- and post-processing section for more information.

Example:

    DBV_PRE_POST_PROC = rman_backup.cmd

 

DBV_PRE_PROC

The name of the pre-processing script.  If a different named script should be called, then this variable can be set. If no path name is given the Dbvisit Standby install directory is assumed. 

Default value Windows: dbv_pre_processing.cmd

Default value Non Windows: dbv_pre_processing.sh

See the Pre- and post-processing section for more information.

Example:

    DBV_PRE_PROC = rman_backup.cmd

 

ORACLE_HOME_ASM 

Default:

ORACLE_SID_ASM = +ASM

 

ORACLE_SID_ASM

The ASM instance name and the ORACLE_HOME for the ASM instance name.

 

SSH_SKIP_OUTPUT

If the ssh connection contains an ssh banner, then Dbvisit Standby will not be able to interpret the data correctly. This setting can be used to tell Dbvisit Standby to ignore the ssh banner.

For example if the ssh banner is as follows:

*************************************************************************** 
 NOTICE TO USERS 
  
 This computer system is the private property of xxxxx.

 It is for authorized use only. Users (authorized or unauthorized) 
 have no explicit or implicit expectation of privacy. 
  
 By using this system, the user consents to such interception, monitoring, 
 recording, copying, auditing, inspection, and disclosure at the 
 discretion of such personnel or officials. Unauthorized or improper use 
 of this system may result in civil and criminal penalties and 
 administrative or disciplinary action, as appropriate. By continuing to 
 use this system you indicate your awareness of and consent to these terms 
 and conditions of use. LOG OFF IMMEDIATELY if you do not agree to the 
 conditions stated in this warning. 
 ****************************************************************************

Then the following can be set to ignore this:

Example:

SSH_SKIP_OUTPUT=***

This will skip the output lines beginning with *** and ending with ***

 

SSH_SKIP_OUTPUT_LINES

By setting this parameter to a number value, that number of lines will be ignored during ssh connections. 


Example:

If your ssh banner is 5 lines, you can specify:

SSH_SKIP_OUTPUT_LINES=5

 

The first 5 lines of ssh output (which will include the banner) will be skipped.

 

STANDBY_ARCHIVELOG_NAME_EXTENSION

Filename extension for archive logs transferred to the standby.

Default .arc

Dbvisit uses name convention %t_%s[_%r]STANDBY_ARCHIVELOG_NAME_EXTENSION, for example: 1_120_123456.arc

Example:

STANDBY_ARCHIVELOG_NAME_EXTENSION = .log

 

USE_ARCHTMP_TO_COMPRESS

Note: This parameter applies to environments where ASM storage is NOT used for the Oracle Archive Destination (or recovery area)

Default value N (NO)

If this value is set to Y (Yes) Dbvisit Standby will compress the archive logs in ARCHTMP instead of the default location where the archive logs are stored (Oracle Archive Destination / Oracle Recovery Area).

This parameter is especially useful and recommended to be set when Multiple Standby Databases are used, or when RMAN backup is scheduled on the primary

 

WIN_SERVICE_WAIT

How long in seconds to wait for the Windows Oracle service to start or stop before starting or stopping the database.

Default value: 10

Example:

    WIN_SERVICE_WAIT=10

 


 


 

LOG, TRACE and TMP Directory Locations 


Note

Even though these parameters are available, the default locations should be sufficient for most environments. If the parameters are not set in the DDC file, the default locations will be used.

 

The following parameters are specific to the Dbvisit Standby LOG, TRACE and TMP Directory Locations.

 

 

 

In some cases it might be required to move the default LOG, TRACE and TMP locations for the Dbvisit Standby log, trace and temp files.  

 

The default location should be sufficient for most environments, but if you do want to move these directories to a different location, you can use the LOGDIR, TRCDIR and TMPDIR directory parameters in the DDC file.  

There are also standby equivalent parameters with the _DR at the end (LOGDIR_DR, TRCDIR_DR and TMPDIR_DR).

 

 

 

The following parameters can be set in the DDC file to overwrite the default locations of these directories inside DBVISIT_BASE/standby:

No Format
LOGDIR=/your_primary_log_dir_location
TRCDIR=/your_primary_trace_dir_location
TMPDIR=/your_primary_temp_dir_location

LOGDIR_DR=/your_standby_server_log_location
TRCDIR_DR=/your_standby_server_trace_location
TMPDIR_DR=/your_standby_server_temp_location