Page Comparison

EMAIL_LOG_GAP_REPORT

Determines if the Dbvisit Standby log gap report will be emailed. When Dbvisit Standby is run with the inspect command (dbvisit -i) the Dbvisit Standby log gap report will be displayed.

Setting this to Yes will email this report to the email address specified by ADMINS. The Dbvisit Standby log gap report will always be written to the Dbvisit Standby database repository (DDR).

Possible Values:

• Yes (Default Value)
  Email the Dbvisit Standby log gap report to the email address specified by ADMINS.
  
  
• No
  Do not email the Dbvisit Standby log gap report.

Example:

    EMAIL_LOG_GAP_REPORT=Yes

MAILCFG_AUTH_USER

This parameter is used to specify a username required for SMTP authentication (username).

Examples:

MAILCFG_AUTH_USER=<your_username>

MAILCFG_AUTH_USER=admin

MAILCFG_AUTH_PASSWD

This variable is used to specify the password required for SMTP authentication (password).

Example:

MAILCFG_AUTH_PASSWD=<your_password>

MAILCFG_AUTH_PASSWD=adminpassword

MAILCFG_CC

Specify email address you want to cc Dbvisit Standby email alerts to.

Example:

MAILCFG_CC=admin@example.com

MAILCFG_BCC

Specify email address you want to bcc Dbvisit Standby email alerts to.

Example:

MAILCFG_BCC=admin@example.com

MAILCFG_ATTACH_TRACEFILE

This parameter is used to specify whether to attach trace files to error emails so that these can be forwarded to Dbvisit support.

Possible Values:

• Yes (Default)
  Attach trace files with error email.
  
  
• No
  Trace files are not attached with error email.

It is advisable to initially set to Yes

Example:

MAILCFG_ATTACH_TRACEFILE=Yes

MAILCFG_ATTACH_TRACEFILE_MAX_SIZE_IN_BYTES

This variable is used to specify a file size limit to attaching the tracefile.

Example:

MAILCFG_ATTACH_TRACEFILE_MAX_SIZE_IN_BYTES = 768000

MAILCFG_SENDMAIL_CLIENT

Note: This parameter is not used from version 7.0.10 and if set will be ignored.

This parameter allows you to specify another sendmail client. Full path must be provided.

Example: ( '\' must be escaped if used on Windows )

MAILCFG_SENDMAIL_CLIENT = C:\\programs\\sendmail.exe

MAILCFG_PORT

This parameter allow you to specify another smtp port if the default is not used.

Example:

MAILCFG_PORT=25

If using GMAIL, make sure that you specify the correct port. The default is MAILCFG_PORT=465 for GMAIL SMTP server.

MAILCFG_DEBUG

Turn on smtp debug messages in the trace files. Possible values are 0 (default) or 1 (enable debug)

Example:

MAILCFG_DEBUG=1

MAILCFG_TIME_OUT

This parameter allow the option to specify smtp timeout in seconds.

Example (default) value:

MAILCFG_TIME_OUT=60

This parameter should only be set if SSL/TLS is used.

Example, for gmail (smtp.gmail.com) you can specify:

MAILCFG_PROTOCOL=SSL

If you are not using SSL/TLS, do not set this parameter in your DDC. If it is set make sure it does not have any values assigned:

MAILCFG_PROTOCOL=

MAILSUBJECT_PREFIX_HEARTBEAT

This variables can be used to set a prefix for the email subject line. This can then be used to set filtering rules for emails.

MAILSUBJECT_PREFIX_HEARTBEAT is for the Dbvisit Standby heartbeat email.

Example:

MAILSUBJECT_PREFIX_LOG_GAP_REPORT=51

The result will be:

"51 - Dbvisit report for PRODB: Transfer log gap: 0 Archive log gap: 0"

MAILSUBJECT_PREFIX_LOG_GAP_REPORT

This variables can be used to set a prefix for the email subject line. This can then be used to set filtering rules for emails.

MAILSUBJECT_PREFIX_HEARTBEAT is for the Dbvisit Standby Log Gap Report email.

Example:

MAILSUBJECT_PREFIX_LOG_GAP_REPORT=52

MAILSUBJECT_PREFIX_SUCCESSFUL

This variables can be used to set a prefix for the email subject line. This can then be used to set filtering rules for emails.

MAILSUBJECT_PREFIX_SUCCESSFUL is for the Dbvisit Standby Succesful email.

Example:

MAILSUBJECT_PREFIX_LOG_GAP_REPORT=53

SEND_HEARTBEAT

(primary server)

SEND_HEARTBEAT_DR

(standby server)

Determines if a daily heart beat message is sent to ensure Dbvisit Standby is still scheduled. 

Possible Values:

• Yes
  Dbvisit Standby sends daily heartbeat email. 
  
  
• No
  Dbvisit Standby will not send daily heartbeat email. 

SEND_HEARTBEAT is used for the primary server.

SEND_HEARTBEAT_DR is used for the standby server.

Default value: Yes

Example:

    SEND_HEARTBEAT=Yes

    SEND_HEARTBEAT_DR=No

SEND_LOG_GAP_WITH_HEARTBEAT

Possible Values:

• Yes
  Include the Dbvisit Standby log gap report in the daily heartbeat email that is sent from the primary server.
  
  
• No
  Do not include the Dbvisit Standby log gap report in the daily heartbeat email.

Default value: No

Example:

    SEND_LOG_GAP_WITH_HEARTBEAT=Yes

SEND_MAIL_FLAG

(primary server)

SEND_MAIL_FLAG_DR

(standby server)

Description: Determines if Dbvisit Standby will use email for alerting.

Default value: YesNo

Possible Values:

• Yes
  Dbvisit Standby will email.
  
  
• No
  Dbvisit Standby will NOT email.

SEND_MAIL_FLAG is for both primary server and standby servers. 

SEND_MAIL_FLAG_DR is only for the standby server.

If SEND_MAIL_FLAG_DR is not set then SEND_MAIL_FLAG will apply to both primary and standby servers.

Default value: YesNo

Example:

    SEND_MAIL_FLAG=Yes

    SEND_MAIL_FLAG_DR=No