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. |