Main Generic Settings

Main Generic Settings

Variable Name

Meaning

ORACLE_SID

Name of the Oracle database for which these configuration variables apply. In a RAC environment, this will be the name of the instance.

Example:

    ORACLE_SID = w102n

OWNER

Windows account owner that will run Dbvisit Standby. 

It is recommended that this be the same user as the Oracle database owner.

This account must also exist on the standby database server.

Example: 

    OWNER = oracle

ORATAB

Only used for Unix/Linux

This file lists the databases present on this server. For Solaris and for some Linux this can be /var/opt/oracle/oratab

For others this is /etc/oratab

Example:

    ORATAB = /etc/oratab

CP

External copy method, to transfer the (archive) log files from the source server to the standby server.

It is recommended to use a secure copy method (scp) or secure ftp (sftp).

The external copy method must be configured so that no password or pass phrase is required.

Example:

    CP = C:\Program Files\Bitvise Tunnelier\sftpc.exe

RSH

External remote shell method for Dbvisit Standby operation.

It is recommended to use SSH (secure shell).

The external remote shell method must be configured so that no password or pass phrase is required.

Example:

    RSH = C:\Program Files\Bitvise Tunnelier\sexec.exe

COMPRESS

The compression method used to compress the (archive) log files.

The following compression options are available:

1.     Dbvisit Standby internal compression.  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.

2.     SSH compression. This uses the zlib compression library to compress the files as they are being transferred to the standby server. This option is only available if ssh (secure shell) is being for the transfer method. This will leave the files uncompressed on the server.

Set COMPRESS=ssh

for ssh compression.

3.     This turns compression off. 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.

 

Unix/Linux:

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 to compress the Oracle (archive) log files.

If unsure set compression method to Dbvisit Standby internal compression:

Example:

COMPRESS = dbvisit

UNCOMPRESS

The uncompress method used to uncompress the (archive) log files.

The following options are available:

1.     Dbvisit Standby internal compression.  This uses the zlib compression library. Dbvisit Standby will uncompress the archives on disk first before applying to the standby server. After applying to the standby server, the files will be compressed again to save disk space.

 Set UNCOMPRESS=dbvisit 

for Dbvisit Standby internal uncompression.

2.     SSH compression. This uses the zlib compression library to uncompress the files as they are being received on the standby server. This option is only available if ssh (secure shell) is being for the transfer method. This will leave the files uncompressed on the server.

Set UNCOMPRESS=ssh

for ssh uncompression.

3.     This turns compression off.  If compression is turned off, Dbvisit Standby will still recognize if a file is compressed and uncompress the file (using the Dbvisit Standby internal method).

Set UNCOMPRESS=No

for no uncompression.

 

Unix/Linux:

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 to compress the Oracle (archive) log files.

If unsure set uncompression method to Dbvisit Standby internal compression:

Example:

UNCOMPRESS = dbvisit

Note: The UNCOMPRESS method must match the COMPRESS method.

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:

    ZIP_EXTENSION = .gz

SEND_HEARTBEAT_TIME24

The time that the daily heartbeat alert (email) will be sent.

This is a daily email to ensure that emailing from Dbvisit Standby is active. This will be sent from the primary and standby server.

The time is in 24 hour format and should be between 0000 and 2359 and must be 4 digits. If this variable is not present, an email will be sent at the start of each day (midnight). Multiple times separated by colon can be set.

Also see the  E-Mail setup section.

Example:

    SEND_HEARTBEAT_TIME24 = 0700

    SEND_HEARTBEAT_TIME24 = 0700:1300:1800

TMP

The directory where the Dbvisit Standby temporary and trace files will be located. 

Example:

    TMP = C:\temp

    TMP = /usr/tmp

PATH

Path to the server environment.

Windows:

Set to the Windows and Windows command directories.

Example:

    PATH = C:\WINDOWS;C:\WINDOWS\system32 

Unix/Linux:

Set to the usual bin directories.

Example:

    PATH = /usr/bin:/bin:/usr/sbin:/usr/local/bin:/sbin

ORACLE_HOME

Specify the Oracle Home of the database. 

In most cases this setting is not required as Dbvisit Standby can determine the ORACLE_HOME.