Edit with care = it is possible to adjust this variable, you can however experience issues if this variable isn’t set correctly. Contact Dbvisit support if not sure.

Table of Contents

style	none

1. Default DDC Parameters

These parameters are present in DDC by default after its creation.

ZIP_EXTENSION

The extension of the compressed file.

This depends on the compression method used. In most cases this is either:

.gz (for gzip and Dbvisit Standby internal compression)

.Z (for compress)

Example (default):

ZIP_EXTENSION = .gz

DB_NAME

This parameter must match Oracle database parameter db_name.

Example:

DB_NAME = PROD

Variable Name

Variable Description

Possible Values

Notes

GENERIC SETTINGS

LICENSE_KEY

License key value

Automatically Specified During DDC creation

Not recommended to edit

DDC_VERSION

DDC Version.

Automatically Specified During DDC creation

Not recommended to edit

ORATAB

Location of oratab file on the system

/etc/oratab

Not supported to edit

COMPRESS

Specifies whether compression method is used to compress the (archive) log files and online redo file during switchover.

Enable only if network speed isn’t sufficient for transferring archivelogs generated by your primary database in time to sync the standby database.

The COMPRESS and UNCOMPRESS variables should both be configured to same compression values.

Note: It is recommended to disable any other compression routines used outside Dbvisit Standby that compress the Oracle (archive) log files.

N (default = disabled)

dbvisit
This uses the zlib compression library. Dbvisit Standby will compress the archives on disk first before transferring to the standby server.
This will leave the files on the server in a compressed state. Set COMPRESS=dbvisit for Dbvisit Standby internal compression.

/bin/gzip

Note: This option is Linux (Unix) only.
For Unix and Linux and alternate external compression method (like gzip or compress) can also be specified.

Examples:
COMPRESS = /bin/gzip
COMPRESS = /usr/bin/compress

Enable only in slow network environments

UNCOMPRESS

See COMPRESS Description

N

Enable only in slow network environments

ZIP_EXTENSION

The extension of the compressed file. This depends on the compression method used.

.gz (default)

Not recommended to edit

DB_NAME

db_name of your primary database as shown by “SQL> sho parameter db_name;”.

Primary and standby db_name must always match.

Automatically Specified During DDC creationUsually not needed to edit

PRIMARY SERVER SETTINGS

OS

Unused

Not supported to edit

PATH

Default Path value for Linux and Windows

Automatically Specified During DDC creation

Not supported to edit

DBVISIT_BASE

Installation path of Dbvisit StandbyMP software on primary host. Typically /usr/dbvisit or C:\Program Files\Dbvisit

Automatically Specified During DDC creation

Edit with care

SOURCE

Hostname of PRIMARY server. The value must exactly match with “HostAddress” parameter in dbvagentmanager.ini on the host

Automatically Specified During DDC creation

Edit with care

ORACLE_SID

ORACLE_SID of your primary database instance

Note that incorrect setting may cause Dbvisit to not recognize the database

Automatically Specified During DDC creation

ORACLE_HOME

ORACLE_HOME on your primary server

Automatically Specified During DDC creation

ORACLE_SID_ASM

ORACLE_SID of your primary ASM instance, empty if no ASM is used and empty for SEHA/RAC deployments

+ASM, +ASM1

NETPORT

Port for dbvagentmanager transfer, as specified by FileTransferListenPort in dbvagentmanager.ini on primary server

7890

ARCHSOURCE

Staging archivelog location on primary server used for archivelog transfer to standby. For example when copying archivelogs from ASM to local filesystem. All files are deleted after the transfer is finished. As result, this directory should be always empty on primary server

Automatically Specified During DDC creation

LOGSWITCH

Determines if a database log switch - "alter system switch logfile" should be performed every time Dbvisit Standby ASU run is executed (defined by ASU interval) on primary database

Example:

LOGSWITCH = N

N (default)

Dbvisit Standby will perform a database log switch ONLY when there are no new archive logs to transfer. If Dbvisit Standby is executed and an Archive log was generated since the last run, no log switch will be performed and the already created archive log will be transferred to the standby database. If no archive logs have been created since the last Dbvisit Standby execution, a log switch will be forced to start the generation of an archive log to be transferred.

Y
Dbvisit Standby will perform a database log switch every time it executes.

I
(Ignore) Dbvisit Standby will never perform a database log switch. Use this option with caution as Dbvisit Standby will not be able to guarantee how far behind in time the standby database is.
Only when Oracle performs a database log switch will Dbvisit Standby transfer the current archived redo log to the standby database.

DB_UNIQUE_NAME

This parameter must match Oracle database parameter db_unique_name set in the primary database.

Note that incorrect setting may cause Dbvisit to not recognize the database.

Automatically Specified During DDC creation

BCKDIR

When adding new PDB on primary (and while PDB_SYNC is set to Y) this parameter defines in which directory Dbvisit will create PDB backup which is used for synchronizing the PDB to standby database.

[DBVISIT_BASE]/standbymp/oracle/backup

PRIMARY RAC SETTINGS

RAC1,2,3,4,5

Defines structure of primary Oracle Cluster. Hostnames of RAC or SEHA node as shown in oracle grid together with oracle instance, thread number and corresponding ASM Instance:

thread_num:host name:oracle sid:oracle sid asm

Example for 2 node RAC ASM database:

RAC1 = 1:proddb1:PROD1:+ASM1

RAC2 = 2:proddb2:PROD2:+ASM2

SEHA ACFS database example:

RAC1 = 1:proddb1:PROD1:

RAC2 = 1:proddb2:PROD1:

NEVER use IP addresses.

Automatically Specified During DDC creation

Edit with care

STANDBY SERVER SETTINGS

OS_DR

Unused

Not supported to edit

PATH_DR

Default Path value for Linux and Windows

Automatically Specified During DDC creation

Not supported to edit

DBVISIT_BASE_DR

Installation path of Dbvisit StandbyMP software on standby host. Typically /usr/dbvisit or C:\Program Files\Dbvisit

Automatically Specified During DDC creation

Edit with care

DESTINATION

Hostname of STANDBY server. The value must exactly match with “HostAddress” parameter in dbvagentmanager.ini on the host

Automatically Specified During DDC creation

Edit with care

ORACLE_SID_DR

ORACLE_SID of your standby database instance

Automatically Specified During DDC creation

ORACLE_HOME_DR

ORACLE_HOME on your standby server

Automatically Specified During DDC creation

ORACLE_SID_ASM_DR

ORACLE_SID of your standby ASM instance, empty if no ASM is used and empty for SEHA/RAC deployments

+ASM, +ASM1

NETPORT_DR

Port for dbvagentmanager transfer, as specified by FileTransferListenPort in dbvagentmanager.ini on primary server

7890

ARCHDEST

Staging archivelog location on standby server which hold archivelogs transferred by Dbvisit StandbyMP from primary server.

Automatically Specified During DDC creation

LEAVE_COMPRESS_DR

Specifies whether the archive log files should be left compressed or not on the standby server AFTER being applied on the standby database.

This variable is effective only with COMPRESS and UNCOMPRESS parameters set

Example:

LEAVE_COMPRESS_DR = Y

Y
Compress log AFTER being applied

N (default)
Leave log uncompressed AFTER being applied

DB_UNIQUE_NAME_DR

This parameter must match Oracle database parameter db_unique_name set in the standby database

Note that incorrect setting may cause Dbvisit to not recognize the database.

Automatically Specified During DDC creation

BCKDIR_DR

When adding new PDB on primary (and while PDB_SYNC is set to Y) this parameter defines in which directory Dbvisit will receive the PDB backup on standby

[DBVISIT_BASE]/standbymp/oracle/backup

STANDBY RAC SETTINGS

RAC1,2,3,4,5_DR

Defines structure of standby Oracle Cluster. See “PRIMARY RAC SETTINGS”

Automatically Specified During DDC creation

Edit with care

MAIL SETTINGS

Note

These settings enable additional dbvctl mail notifications on top of notification set in controlcenter (global mail notifications). We recommend following approach:

set & enable mail notifications in dbvcontrol
set following variables ONLY:

Code Block
SEND_MAIL_FLAG = Y SEND_MAIL_FLAG_DR = Y SUCCESSMAIL = N SUCCESSMAIL_DR = N

If only these 4 variables are set, all other necessary details such as SMTP server, port and recipients are used from global mail notifications settings and you don’t need to specify them in the DDC file

SEND_MAIL_FLAG

Enables additional Dbvctl Mail Notifications from primary server.

Dbvctl Notifications are additional module on top of notifications specified in dbvcontrol.

Examples:

SEND_MAIL_FLAG = Y

N (default)

Y

Enables sending additional Dbvctl Mail Notifications

SEND_MAIL_FLAG_DR

Enables additional Dbvctl Mail Notifications from standby server.

Dbvctl Notifications are additional module on top of notifications specified in dbvcontrol.

Examples:

SEND_MAIL_FLAG = Y

N (default)

Y

Enables sending additional Dbvctl Mail Notifications

SUCCESSMAIL

Defines whether dbvctl notification is set every time action is successful on primary server.

If set to N, dbvctl notifications are sent only for failed actions

N

Dbvctl Mail Notifications are sent for failed actions only

Y (default)

Dbvctl Mail Notifications are sent for all actions

SUCCESSMAIL_DR

Defines whether dbvctl notification is set every time action is successful on standby server.

If set to N, dbvctl notifications are sent only for failed actions

N

Dbvctl Mail Notifications are sent for failed actions only

Y (default)

Dbvctl Mail Notifications are sent for all actions

ADMINS

List of email addresses separated by comma, to receive dbvctl notifications.

We recommend to NOT set this value

Edit with careNot recommended to edit

MAILCFG_FROM

Specifies the FROM email address of the primary server.

We recommend to NOT set this value

Edit with careNot recommended to edit

MAILCFG_FROM_DR

Specifies the FROM email address of the standby server.

We recommend to NOT set this value

Edit with careNot recommended to edit

MAILCFG_SMTP_SERVER

Specifies the SMTP server to send the email to

We recommend to NOT set this value

Edit with careNot recommended to edit

MAILCFG_SMTP_SERVER_DR

Specifies the SMTP server to send the email to from standby server

We recommend to NOT set this value

Edit with careNot recommended to edit

ADVANCED_MAIL_SETTINGS

Note

These are additional settings for dbvctl mail notifications on top of notification set in controlcenter (global mail notifications). As with previous settings, we recommend to:

set & enable mail notifications in controlcenter (global mail notifications)
if needed, modify following variables ONLY: (their modification is optional)

Code Block
EMAIL_LOG_GAP_REPORT IGNORE_MAIL_ERROR MAILCFG_ATTACH_TRACEFILE MAILCFG_ATTACH_TRACEFILE_MAX_SIZE_IN_BYTES MAILCFG_DEBUG

all other necessary details such as SMTP

MAILSUBJECT_PREFIX_LOG_GAP_REPORT
MAILSUBJECT_PREFIX_SUCCESSFUL
MAILSUBJECT_PREFIX_HEARTBEAT

all other necessary details such as SMTP passwords are used from global mail notifications settings and you don’t need to specify them in the DDC file

EMAIL_LOG_GAP_REPORT

If user initiates log gap report (GUI, dbvctl, dbvcli) this variable controls whether email will be sent with log gap report summary.

This variable controls whether summary of log gap report action initiated by the user

N

Email with Log gap report summary is not sent after log gap report is initiated by the user.

Y (Default value)

Email with Log gap report summary is sent after log gap report is initiated by the user.

IGNORE_MAIL_ERROR

This variable set behavior which follows encountering error during sending of email (for example SMTP server is not reachable). With default value, any dbvctl process will stop & fail if there’s any problem with sending email.

N (Default value)

Any email errors will cause processing to stop at the email processing step.

Y

Email errors will be ignored and just logged to trace file, instead of error out on email related errors - this ensures that processing can still continue even if there are issues with email configuration.

_MAILCFG_ALWAYS_ATTACH_TRACEFILE

This parameter is used to specify whether to attach trace files to all emails

N (Default)

Tracefile is not attached to mail notification

Y

Tracefile is always attached to mail notification

MAILCFG_ATTACH_TRACEFILE

This parameter is used to specify whether to attach trace files to error emails

N

Tracefile is not attached to mail notification

Y (Default)

Tracefile is always attached to mail notification

MAILCFG_ATTACH_TRACEFILE_MAX_SIZE_IN_BYTES

This variable is used to specify a file size limit in bytes to attaching the trace file.

768000 (Default)

MAILCFG_AUTH_USER

This parameter is used to specify a username required for SMTP authentication (username) on the primary server.

We recommend to NOT set this value

Edit with careNot recommended to edit

MAILCFG_AUTH_USER_DR

This parameter is used to specify a username required for SMTP authentication (username) on the standby server.

We recommend to NOT set this value

Edit with careNot recommended to edit

_MAILCFG_AUTH_PASSWD

This parameter is used to specify a password required for SMTP authentication (username) on the primary server.

We recommend to NOT set this value

Edit with careNot recommended to edit

_MAILCFG_AUTH_PASSWD_DR

This parameter is used to specify a password required for SMTP authentication (username) on the standby server.

We recommend to NOT set this value

Edit with careNot recommended to edit

MAILCFG_BCC

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

Edit with careNot recommended to edit

MAILCFG_CC

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

Edit with careNot recommended to edit

MAILCFG_DEBUG

Turn on smtp debug messages in the dbvctl trace files. Possible values are 0 (default) or 1 (enable debug). Usually only set after Dbvisit Support instructions.

0 (Default)

No debug in the trace for sent mails

1

debug information of SMTP Server communication is written to the trace

MAILCFG_PORT

This parameter allows you to specify SMTP port on the primary server.

We recommend to NOT change this value

25 (Default)

Edit with careNot recommended to edit

MAILCFG_PORT_DR

This parameter allows you to specify SMTP port on the standby server.

We recommend to NOT set this value

Edit with careNot recommended to edit

MAILCFG_FORMAT

Specifies the format of mail messages sent by dbvctl notifications

We recommend to NOT change this value

HTML (Default)

Mails are sent in new HTML format introduced in Dbvisit version 10

TEXT

Mails are sent in text format

Edit with careNot recommended to edit

MAILCFG_FORMAT_DR

Specifies the format of mail messages sent by dbvctl notifications

We recommend to NOT change this value

HTML (Default)

Mails are sent in new HTML format introduced in Dbvisit version 10

TEXT

Mails are sent in text format

Edit with careNot recommended to edit

MAILCFG_TIME_OUT

This parameter allows the option to specify SMTP timeout in seconds.

We recommend to NOT change this value

60 (Default)

Not recommended to edit

MAILSUBJECT_PREFIX_LOG_GAP_REPORTMAILSUBJECT_PREFIX_SUCCESSFUL

This variable 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

SUCCESS_MAILTO

PRIMARY ARCHIVE LOG MANAGEMENT SETTINGS

ARCHSOURCE_MANAGEMENT

DAYS_TO_KEEP_ARCHSOURCE

NUM_ARCHSOURCE_TO_KEEP

ARCHSOURCE_BACKUP_COUNT

THRESHOLD_ARCHSOURCE

FRA_THRESHOLD_ARCHSOURCE

DELETE_ARCHSOURCE_THRESHOLD

STANDBY ARCHIVE LOG MANAGEMENT SETTINGS

ARCHDEST_MANAGEMENT

DAYS_TO_KEEP_ARCHDEST

NUM_ARCHDEST_TO_KEEP

THRESHOLD_ARCHDEST

DELETE_ARCHDEST_THRESHOLD

DAEMON SETTINGS

DMN_DBVISIT_INTERVAL

DMN_MONITOR_INTERVAL

DMN_DBVISIT_TIMEOUT

DMN_MONITOR_TIMEOUT

DMN_MONITOR_LOG_NUM

DMN_MAX_FAIL_NOTIFICATIONS

DMN_BLACKOUT_STARTTIME

DMN_BLACKOUT_ENDTIME

DMN_DBVISIT_INTERVAL_DR

DMN_MONITOR_INTERVAL_DR

DMN_DBVISIT_TIMEOUT_DR

DMN_MONITOR_TIMEOUT_DR

DMN_MONITOR_LOG_NUM_DR

DMN_MAX_FAIL_NOTIFICATIONS_DR

DMN_BLACKOUT_STARTTIME_DR

DMN_BLACKOUT_ENDTIME_DR

ADVANCED SETTINGS

SYS_LOGON

SYS_USER

_SYS_PASSWD

SYS_LOGON_STRING

APPLY_DELAY_LAG_MINUTES

ARCHTMP

ARCHIVE_LOG_GAP_THRESHOLD

TRANSFER_LOG_GAP_THRESHOLD

COMPARE_CHECKSUM

CP

RSH

DAYS_TO_KEEP_TRACE

NUM_TRACE_TO_KEEP

HOSTNAME_CMD

HOSTNAME_CMD_DR

SEND_HEARTBEAT

SEND_HEARTBEAT_DR

SEND_HEARTBEAT_TIME24

APPLY_ARCHIVE_RMAN

CASCADE

DBVISIT_DEBUG

NTF_TASKS_SHOW

DBV_PRE_POST_PROC_NAME

PDB_SYNC

ODA KVM DB SPECIFIC

Variable Name

Variable Description

DDC_VERSION

Dbvisit Software version number in format 9.x.x

The version number is set automatically when creating a new DDC file or when upgrading an existing DDC file to a higher version

Example:

DDC_VERSION = 9.0.0

ORATAB

If Linux (UNIX) based installations are used this parameter should be configured to point to your Oracle “oratab” file.

This file is used by Dbvisit Standby to obtain the Oracle Software installation home (ORACLE_HOME) for the specified ORACLE_SID.

On Linux, the default location for this file is /etc/oratab but on other variations of UNIX such as Solars this location can be /var/opt/oracle/oratab

Example (Default) value:

ORATAB = /etc/oratab

COMPRESS

The compression method is used to compress the (archive) log files. It is recommended to make use of COMPRESS and UNCOMPRESS options, as this can assist with faster network transfer time as fewer data will be transferred between the primary and standby servers.

Setting compression using this variable only affects the Archive logs being shipped between the primary and standby servers.

The COMPRESS and UNCOMPRESS variables should both be configured to similar compression options. For more details see the UNCOMPRESS variable below

Possible values:

COMPRESS=dbvisit

COMPRESS=/bin/gzip

COMPRESS=N

Recommended (default) values:

Linux:

COMPRESS=/bin/gzip

Windows:

COMPRESS=dbvisit

The following compression options are available:

Internal Dbvisit Standby Compression (dbvisit)
This uses the zlib compression library. Dbvisit Standby will compress the archives on disk first before transferring to the standby server.
This will leave the files on the server in a compressed state. Set COMPRESS=dbvisit for Dbvisit Standby internal compression.
External Options (/bin/gzip)
Note: This option is Linux (Unix) only.
For Unix and Linux and alternate external compression method (like gzip or compress) can also be specified.
Examples:
COMPRESS = /bin/gzip
COMPRESS = /usr/bin/compress
Note: It is recommended to disable any other compression routines used outside Dbvisit Standby that compress the Oracle (archive) log files.
Compression Disabled
Use this option if the network speed is sufficiently fast to transfer uncompressed (archive) log files and disk space is sufficient to hold uncompressed files.
Set COMPRESS=No for no compression. This is a default value.

UNCOMPRESS

The UNCOMPRESS variable specifies the method that should be used to "uncompress" the archive logs.

The method specified for UNCOMPRESS should match similar compression setting as specified for the COMPRESS variable.

Possible values:

UCOMPRESS=dbvisit

UNCOMPRESS=/bin/gunzip

UNCOMPRESS=N

Recommended (default) values:

Linux:

COMPRESS=/bin/gunzip

Windows:

COMPRESS=dbvisit

The following un-compress options are available:

Internal Dbvisit Standby Compression (dbvisit)
This uses the zlib compression library is used to uncompress the archive log files. If COMPRESSION=dbvisit was set, it is required to set the UNCOMPRESS value to "dbvisit" as well.
External Options (/bin/gunzip)
Note: This option is Linux (Unix) only.
For Unix and Linux and alternate external compression methods (like gzip/gunzip or compress/uncompress) can also be specified.
Examples:
if you specified COMPRESS = /bin/gzip then UNCOMPRESS= /bin/gunzip
if you specified COMPRESS = /usr/bin/compress then UNCOMPRESS=/usr/bin/uncompress
Compression Disabled
Use this option if the network speed is sufficiently fast to transfer uncompressed (archive) log files and disk space is sufficient to hold uncompressed files.
Set COMPRESS=N and UNCOMPRESS=N for no compression/uncompression. This is a default value.

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_SUCCESSFUL	This variable 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
MAILSUBJECT_PREFIX_HEARTBEAT	This variable 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
SUCCESS_MAILTO	This is used to separate the success emails from the failure emails. If set, then all successful Dbvisit Standby emails will be sent to this email address. Failure or unsuccessful emails will be sent to the email address specified by ADMINS. If not set, then all emails will go to ADMINS. We recommend to NOT change this value	Not recommended to edit
PRIMARY ARCHIVE LOG MANAGEMENT SETTINGS
ARCHSOURCE_MANAGEMENT
DAYS_TO_KEEP_ARCHSOURCE
NUM_ARCHSOURCE_TO_KEEP
ARCHSOURCE_BACKUP_COUNT
THRESHOLD_ARCHSOURCE
FRA_THRESHOLD_ARCHSOURCE
DELETE_ARCHSOURCE_THRESHOLD
STANDBY ARCHIVE LOG MANAGEMENT SETTINGS
ARCHDEST_MANAGEMENT
DAYS_TO_KEEP_ARCHDEST
NUM_ARCHDEST_TO_KEEP
THRESHOLD_ARCHDEST
DELETE_ARCHDEST_THRESHOLD
DAEMON SETTINGS
DMN_DBVISIT_INTERVAL
DMN_MONITOR_INTERVAL
DMN_DBVISIT_TIMEOUT
DMN_MONITOR_TIMEOUT
DMN_MONITOR_LOG_NUM
DMN_MAX_FAIL_NOTIFICATIONS
DMN_BLACKOUT_STARTTIME
DMN_BLACKOUT_ENDTIME
DMN_DBVISIT_INTERVAL_DR
DMN_MONITOR_INTERVAL_DR
DMN_DBVISIT_TIMEOUT_DR
DMN_MONITOR_TIMEOUT_DR
DMN_MONITOR_LOG_NUM_DR
DMN_MAX_FAIL_NOTIFICATIONS_DR
DMN_BLACKOUT_STARTTIME_DR
DMN_BLACKOUT_ENDTIME_DR
ADVANCED SETTINGS
SYS_LOGON
SYS_USER
_SYS_PASSWD
SYS_LOGON_STRING
APPLY_DELAY_LAG_MINUTES
ARCHTMP
ARCHIVE_LOG_GAP_THRESHOLD
TRANSFER_LOG_GAP_THRESHOLD
COMPARE_CHECKSUM
CP
RSH
DAYS_TO_KEEP_TRACE
NUM_TRACE_TO_KEEP
HOSTNAME_CMD
HOSTNAME_CMD_DR
SEND_HEARTBEAT
SEND_HEARTBEAT_DR
SEND_HEARTBEAT_TIME24
APPLY_ARCHIVE_RMAN
CASCADE
DBVISIT_DEBUG
NTF_TASKS_SHOW
DBV_PRE_POST_PROC_NAME
PDB_SYNC
ODA KVM DB SPECIFIC

2. Additional DDC Parameters

These parameters are not present in DDC file after creation. They are useful in number of specific situations and to resolve specific problems.

Version	Old Version 2	New Version 3
Changes made by	Jan Klinke	Jan Klinke
Saved on	Feb 20, 2025	Feb 20, 2025

Versions Compared

Key

1. Default DDC Parameters

2. Additional DDC Parameters

Content Comparison

Versions Compared

Key

1. Default DDC Parameters

2. Additional DDC Parameters