Configuration Variable Reference

When a table is prepared, should the name from MINE be kept as-is, made uppercase, or lowercase? This is honored for case-sensitive databases only (MySQL and MSSQL).
Default is UPPER. 

Parameter change needs a process restart: No

Allows global rename of columns. Translates column names on source database to new column names on target database. This is handy if replicating from one database to another type of database (eg MySQL) where a specific column cannot be used because it is a reserved word.

Example: set APPLY_COLUMN_NAMES_MAP PRIMARY=PRIMARY_VALUE

This will rename the column PRIMARY to PRIMARY_VALUE on the target database. 

Multiple columns pairs can be separated with commas: 

set APPLY_COLUMN_NAMES_MAP PRIMARY=PRIMARY_VALUE, ALTER=ALT

Default is an empty string.

Parameter change needs a process restart: APPLY

Connection definition for the APPLY database. This is TNS connection string for Oracle, connection string for MySQL or DSN (Data Source Name) for MS SQL.

Should not be changed once replication is configured.

DBID (see v$database) of databases where apply connects. The default is empty and the variable is optional; however, it's always set by setup wizard. This helps to check that the connection strings resolve to correct databases as the apply server.

Default: (empty)

Should not be changed once replication is configured.

• NO
• YES (default)

LOAD feature uses array binding if this variable is set to YES.

Parameter change needs a process restart: No

The size of Array Bind when it is switched on for LOAD feature.

Default: 500

Parameter change needs a process restart: No

• NO
• YES (default)

Parameter change needs a process restart: No

The number of rows sent to parallel threads at once, to minimize Perl thread copy overhead when using LOAD feature.

Default: 25

Parameter change needs a process restart: No

APPLY_FILEOUT_FILE_BATCH_SIZE

This parameter governs the total size of intermediary files in the APPLY_FILEOUT_STAGING_DIR BEFORE they are flushed to final CSV output, and delivered to APPLY_FILEOUT_TARGET_DIR. This work is done in batches, rather than writing new CSV files for each operation which would be inefficient, and can be tuned according to your requirements.

If only a single table is replicated then this value would correlate closely to the file size for the actual output file. The file will be closed then this size is reached and the transaction is completed.

Values: integer

Default: 10485760 (10mb)

Parameter change needs a process restart: APPLY

APPLY_FILEOUT_FILE_CSV_COMMA

The field separator for CSV output files.

Default: (empty)

Value: string, with support for escaped chars:

\0 \a \b \t \n \v \f \r \x00 (arbitrary hex number ) \\ (backslash)

Parameter change needs a process restart: APPLY

APPLY_FILEOUT_FILE_CSV_NEWLINE

The row separator for CSV output files.

Default: (empty)

Value: string, with support for escaped chars:

\0 \a \b \t \n \v \f \r \x00 (arbitrary hex number ) \\ (backslash)

Parameter change needs a process restart: APPLY

APPLY_FILEOUT_FILE_FORMAT

The file type for the output file.

• OFF (default)
• NONE (OFF)
• CSV

Parameter change needs a process restart: APPLY

APPLY_FILEOUT_FILESYSTEM

The type of filesystem to be written to.

• FS (Filesystem) (default)
• HDFS (Hadoop)

Parameter change needs a process restart: APPLY

The namenode of the Hadoop HDFS. This is the standard protocol how HDFS clients connect.

Default: localhost:9000

Values: host:port

Parameter change needs a process restart: APPLY

The directory where output files are stored while they are in progress.

Default: OFF

Value: directory + file mask.

Wildcards:

%O table owner

%A table name

%C transaction start SCN

%I object=table id

%X transaction id

%N apply process name

%T process type (=APPLY)

%H thread id

%S plog id

%D ddc name

%E file type (csv/avro)

Note that one file can contain multiple transactions. So %C/%X/%H/%S are determined based on first transaction in the file.

We recommend to use %C to order the output files and add %X for cases when %C is non-unique.

Parameter change needs a process restart: APPLY

APPLY_FILEOUT_TARGET_DIR 

The directory where output files are stored when they are completed.

Default: OFF

Value: directory + file mask.

Wildcards:

%O table owner

%A table name

%C transaction start SCN

%I object=table id

%X transaction id

%N apply process name

%T process type (=APPLY)

%H thread id

%S plog id

%D ddc name

%E file type (csv/avro)

Note that one file can contain multiple transactions. So %C/%X/%H/%S are determined based on first transaction in the file.

We recommend to use %C to order the output files and add %X for cases when %C is non-unique.

Parameter change needs a process restart: APPLY

APPLY_IGNORE_ERROR_CODES

Automatically ignore specified Oracle errors (ORA- ).

Values: string (delimited by :)

Default: (empty) (Internally ORA-10655 is pre set)

For example, if there is a parent-child relationship and only the parent table is being replicated because the child table does not exist on target, any foreign key constraints being created on the parent-child relationship will be replicated and will result in an ORA-942 table or view does not exist error because the add constraint command doesn't find child table it wants to reference to.

Example:

APPLY_IGNORE_ERROR_CODES 942

This will make Apply ignore all ORA-00942 error codes.

Multiple error codes can be delimited by :

Example:

APPLY_IGNORE_ERROR_CODES 942:955

Parameter change needs a process restart: No

Network interface on which APPLY listens for commands (hostname:port).
Default will depend on what was entered in the Setup Wizard.  

Parameter change needs a process restart: No

If set to YES apply process checks originating dbid of the transaction (on which db it was first mined). If it's same as dbid of apply database, apply skips the change. This is useful for two way replications.

• YES (default)
• NO

Parameter change needs a process restart: APPLY

APPLY_MSSQL_USER_DB

Deprecated.

Values: string

Default: (empty)

Enables parallel load for LOAD feature.

• YES (default)
• NO

Parameter change needs a process restart: No

Encrypted APPLY database password. (Use ENCRYPT command to get encrypted password from the plain text password.)
Default will be encrypted and will depend on what was entered in the Setup Wizard. 

Parameter change needs a process restart: APPLY

What is the corresponding APPLY for this process? If SIMPLE_CONFIG = YES, this is simply set to APPLY.

Parameter change needs a process restart: MINE

• NO 
• YES (default)

If set to YES, then APPLY will postponing the last LCR or SQL until the next SQL for the same object is found. This can sometimes help with (deadlock) locking issues or "APPLY hung" issues. This can also assist if there are killed sessions on the source database and the APPLY is waiting on the detection of the killed process to rollback (or commit).

By setting to YES it means that APPLY is always one SQL behind. This means APPLY always keeps one SQL in each open transaction unapplied. It processes the changes it gets from MINE, but stops short of the last one available so far.

As soon as APPLY receives the commit, it applies even the last SQL. So there is never any data loss, although it can be noticed that APPLY lags behind MINE until the commit arrives. But this is probably most visible for manual test cases (like insert 10.000 rows and see that 9.999 has been applied) because in production systems there is always some activity from the source (and with commits), so this situation is rarely seen.

Parameter change needs a process restart: APPLY

APPLY database type:

• Oracle
• MySQL
• MSSQL

Default will depend on what was entered in the Setup Wizard.

Parameter change needs a process restart: No

Where to connect to reach this APPLY process. This is usually same as APPLY_LISTEN_INTERFACE, but may be changed if the name resolution works differently among the machines, listen binds to selected interfaces only, etc. Note that this settings is used by the console, too.
Default will depend on what was setup in the Setup Wizard. 

Parameter change needs a process restart: No

How to make triggers to not fire in APPLY sessions (YES/NO/AUTO).

• YES enable the set-trigger-firing property (to honor dbms_ddl.set_trigger_firing_property) and abort if fail.
• AUTO (default) try to enable it, if possible.
• NO disable it, even the package/variable way.

Parameter change needs a process restart: APPLY

APPLY database schema (Oracle, usually same as APPLY_USER), schema=database (MySQL), database (MS SQL).
Default will depend on  what was setup in the Setup Wizard.

Should not be changed once replication is configured.

APPLY database schema (SQL Server only).

Default empty string unless MS SQL is the target. Then it will depend on what was setup in the Setup Wizard.

Should not be changed once replication is configured.

Directory to store received PLOGS on APPLY server.

Default is the directory set up in the Setup Wizard and then a subfolder of /apply.

Parameter change needs a process restart: No

The trace file contains all SQL applied as well as further debugging info.

 Wildcards:

 %N apply process name

 %S plog sequence

 %E file type extension

Example:

APPLY_TRACE=/home/oracle/d112f/log/trace/%N_%S.%E

• OFF (default)
• path

Parameter change needs a process restart: APPLY

If set to YES the APPLY process will only use the primary key in the WHERE clause. If NO, the APPLY process will also use all supplemental columns in the WHERE clause.

• NO (default)
• YES 

Parameter change needs a process restart: APPLY

APPLY database login username.

Default will depend on  what was setup in the Setup Wizard.

Should not be changed once replication is configured.

Disable/enable checking of variable values.

• ON (default)
• OFF
• comma separated list of variable NOT to check

Parameter change needs a process restart: No

DBID is the Oracle Database ID that is storing the DDC metadata tables for Dbvisit Replicate. This is checked to make sure that Dbvisit connects to the correct database.

Values: string (something that a user would not normally set)

Should not be changed once replication is configured.

If DDC DB, on every startup of a process a backup of all DDC settings is made into this directory as a backup, e.g. for use with CREATE DDCDB FROM DDCFILE, or just for reference.
Values: string. Usually /ddc_backup from the main directory. Chosen during the Setup Wizard.

Parameter change needs a process restart: No

TNS identifier for the database when the DDC DB is stored. (Setup wizard sets it to MINE database for this by default.) Note that just setting this variable will not create the DDC DB tables, these are contained in every dictionary.

Change to the variable doesn't affect an already configured replication.

Unique id of the DDC. This must not change after configuration is complete.

Default: 1.

Name of the configuration (%d in filemask). This can change as you want, as internally only the DDC_ID matters, but beware of all %d references.
Default will depend on  what was setup in the Setup Wizard. 

Parameter change needs a process restart: No

Encrypted ddc db database password. (Use ENCRYPT command to get encrypted password from the plain text password.)

Default will depend on  what was setup in the Setup Wizard.

Parameter change needs a process restart: No

DDC database schema, usually same as DDC_USER.

Default will depend on  what was setup in the Setup Wizard.

Change to the variable doesn't affect an already configured replication.

DDC DB database login username.

Default will depend on  what was setup in the Setup Wizard.

Change to the variable doesn't affect an already configured replication.

Any DDL issued by this user will be ignored. Users are separated by colons.

Default: empty.

Parameter change needs a process restart: No

If set to YES all grants on the prepared tables will be replicated to the target database. Note that dbvrep user on the target database needs to have sufficient privileges to replicate grants, e.g. GRANT ANY OBJECT PRIVILEGE.

• NO (default)
• YES

Parameter change needs a process restart: No

Controls the extent of the debugging level in the Replicate C code.
The debugging level is controlled by the following areas (Bit fields) that can be switched on/off to decide to what extent messages will be printed in the log and trace files.

DEBUG_READ 1
DEBUG_PARSE_RB 2
DEBUG_PARSE_CH 4
DEBUG_READ_DICT 8
DEBUG_ACCESS_DICT 0x10
DEBUG_PARSE_TRANSACTIONS 0x20

DEBUG_ERRORS 0x200
DEBUG_PTRACE 0x100

/*apply*/
DEBUG_PLOG_DUMP 0x1000
DEBUG_SQL_VALUES 0x2000
DEBUG_SQL_COMMANDS 0x4000
DEBUG_APPLY_COORDINATE 0x8000
DEBUG_APPLY_APPLIER 0x10000
DEBUG_ERROR_PLOG 0x20000
DEBUG_MINE_LWN 0x40000
DEBUG_APPLY_BINDS 0x80000

/*error messages, should not be supressed*/
DEBUG_MANDATORY 0x200

Example:

DEBUG_LEVEL = 0x4000 (16384) . Then all messages up to DEBUG_SQL_COMMANDS will be printed.

Default: 0 ( As a default it is always set 0x200 even when DEBUG_LEVEL is set to  0x00 )

Parameter change needs a process restart: APPLY/MINE

depending of this setting in the process specific *.ddc file

When PLOGS are applied and no longer needed even after APPLY restart, they are eligible for deletion. In addition, they must be at least DELETE_OBSOLETE_PLOGS_AGE days old.

DELETE_OBSOLETE_PLOGS_SIZE_MB takes precedence over this age setting.
Format: specify number of days, hours, minutes and seconds, e.g. 1d20h30m40s (each component is
optional, but at least one is mandatory.

Delete PLOGS after specific time period. Time period can be days (d) or hours(h).

Default: 3d

Parameter change needs a process restart: APPLY/MINE

When PLOGS are applied and no longer needed even after APPLY restart, they are eligible for deletion. Dbvisit Replicate deletes PLOGS exceeding this size in MB.

Default: 1024

Parameter change needs a process restart: APPLY/MINE

Compress the PLOGS as soon as they are not needed by Dbvisit Replicate anymore.

Default: Yes

Parameter change needs a process restart: APPLY/MINE

When redo logs are mined and no longer needed even after mine restart, they are eligible for deletion. In addition, they must be at least DELETE_OBSOLETE_RLOGS_AGE days old.

NOTE: this applies only for redolog copies shipped to mine from fetcher. If mine reads them directly, they are left to be managed by database administrator, using RMAN, backup scripts etc. DELETE_OBSOLETE_RLOGS_SIZE_MB takes precedence over this age setting.

Format: specify number of days, hours, minutes and seconds, e.g. 1d20h30m40s (each component is
optional, but at least one is mandatory.

Default: 3d

Parameter change needs a process restart: MINE

When redologs are parsed and no longer needed even after mine restart, they are eligible for deletion. Dbvisit Replicate deletes RLOGS exceeding this size in MB. This applies only to the copies of redologs sent from fetcher to mine.

Default: 1024

Parameter change needs a process restart: MINE

Compress the redo logs transferred from FETCHER as soon as they are not needed by Dbvisit Replicate anymore.

Default: Yes

Parameter change needs a process restart: MINE

DISKSPACE_CHECK_BYTE_LIMIT

Sends a email notification as well as a warning message in the log file when free space on the filesystem goes below this threshold.

Values: integer

Default: 1073741824 (1GB)

Parameter change needs a process restart: APPLY/MINE

Show all objects. By default only tables will be shown.

• NO (default)
• YES (This may cause all objects to display. Certain objects may still not appear in the console)

Parameter change needs a process restart: No

What table name to show when rename is used. The valid values are:

• BOTH (default)
• SOURCE
• TARGET

Parameter change needs a process restart: No

Colon-separated list of users whose DML operations should not be replicated. Use to filter out transactions.

Default (empty)

Parameter change needs a process restart: APPLY/MINE

When generating the scripts for export this parameter allows the option to exclude or include statistics.

• NO (default)
• YES

Parameter change needs a process restart: No

• YES (default)
• NO

Parameter change needs a process restart: No

MINE database TNS (when connecting from FETCHER).
Default will depend on  what was setup in the Setup Wizard. Will be an empty string if FETCHER is not used. 

Parameter change needs a process restart: FETCHER

DBID (see v$database) of databases where fetcher connects. The default is empty and the variable is optional; however, it's always set by setup wizard. This helps to check that the connection strings resolve to correct databases = the same ones as the fetcher server.

Default will depend on  what was setup in the Setup Wizard. Will be an empty string if FETCHER is not used. 

Parameter change needs a process restart: FETCHER

Mine dictionary database TNS (when connecting from fetcher).

Default (empty)

Parameter change needs a process restart: FETCHER

Optional DBID for the mine dictionary database. Checks that fetcher connects to the correct database.

Default (empty)

Parameter change needs a process restart: FETCHER

Encrypted fetcher dictionary database password. (Use " ENCRYPT " command to get encrypted password from the plain text password.)

Default (empty)

Parameter change needs a process restart: FETCHER

Schema of mine dictionary repository (when connecting from fetcher). Virtually always same as MINE_DICTIONARY_SCHEMA .

Default (empty)

Parameter change needs a process restart: FETCHER

Mine dictionary database login username (when connecting from fetcher).

Default (empty)

Parameter change needs a process restart: FETCHER

• YES
• NO (default)

Parameter change needs a process restart: FETCHER/MINE

Network interface on which FETCHER listens for commands (hostname:port).

Default will depend on  what was setup in the Setup Wizard.

Parameter change needs a process restart: FETCHER

Encrypted FETCHER database password. (Use ENCRYPT command to get encrypted password from the plain text password.)

Default will depend on  what was setup in the Setup Wizard. Will be an empty string if FETCHER is not used. 

Parameter change needs a process restart: FETCHER

What is the corresponding FETCHER for this process? If SIMPLE_CONFIG = YES, this is simply set to FETCHER.

Parameter change needs a process restart: No

Where to connect to reach this FETCHER process. This is usually same as FETCHER_LISTEN_INTERFACE, but may be changed if the name resolution works differently among the machines, listen binds to selected interfaces only, etc. Note that this settings is used by the console, too.

Parameter change needs a process restart: FETCHER

Schema of MINE repository (when connecting from FETCHER). Virtually always same as MINE_SCHEMA.

Default will depend on  what was setup in the Setup Wizard. Will be an empty string if FETCHER is not used. 

Parameter change needs a process restart: FETCHER

On RAC, specify a subset of redo log threads that a particular FETCHER should handle; it is necessary to send all threads to MINE, but it is possible to use multiple FETCHERS. Use "ALL" (default) or colon-separated list of threads (e.g. "1:3:5").

Default: ALL

Parameter change needs a process restart: FETCHER

MINE database login username (when connecting from FETCHER).

Default will depend on what was setup in the Setup Wizard. Will be an empty string if FETCHER is not used. 

Parameter change needs a process restart: FETCHER

If set to YES plog names can use placeholders that can generate different filenames on every mine run when using Java Plog Extractor. Allowed placeholders are %Z (seconds since epoch) and %Q (process uuid (changes after restart)) and must be the last in the filename and must follow %E (extension).

• NO (default)
• YES

Parameter change needs a process restart: APPLY/MINE

IGNORE_APPLY_DDL_DIFFERENCES

Will ignore differences in the table definition (or if it is missing) between source and target during the prepare phase.

• NO (default) However this can changed to YES depending on options used in the Setup Wizard
• YES

Parameter change needs a process restart: No

• NOW
• RESETLOGS (selects the SCN from v$database.resetlogs_scn on the target database)
• Manually entered SCN number

Parameter change needs a process restart: APPLY

Show license info and product version in console

• ON (default)
• OFF

Parameter change needs a process restart: No

License key, as obtained by your purchase.

Default: Your license key or a random trial license good for 30 days.

Parameter change needs a process restart: No

General process log file location template.

Default will depend on  what was setup in the Setup Wizard. Generally it is 'home'/log

Parameter change needs a process restart: APPLY/MINE/FETCHER depending on the process specific setting (e.g. APPLY.LOG_FILE)

General trace file location template.

Default will depend on  what was setup in the Setup Wizard. Generally it is 'home'/log/trace

Parameter change needs a process restart: APPLY/MINE/FETCHER depending on the process specific setting (e.g. APPLY.LOG_FILE_TRACE)

The number of copies of the log that should be kept. The active log will always be called *.log. Once the file is full (see LOG_FILE_SIZE parameter) then a copy of the log will be rotated and saved as *log.1. Any contents saved in *log.1 will be saved as *log.2. The process will continue determined by the value that this parameter is set to. When the default number is reached the last one will be rotated off.

Default: 2

Parameter change needs a process restart: APPLY/MINE/FETCHER depending on the process specific setting (e.g. APPLY.LOG_FILE_COUNT)

• yyyy-MM: every month
• yyyy-ww: every week
• yyyy-MM-dd: every day at midnight
• yyyy-MM-dd-a: every day at noon
• yyyy-MM-dd-HH: every hour
• yyyy-MM-dd-HH-MM: every minute

Note: The values provided above are CASE SENSITIVE, so make sure you provide the values same as above.

Parameter change needs a process restart: APPLY/MINE/FETCHER depending on the process specific setting (e.g. APPLY.LOG_FILE_ROTATE)

Approximate maximum log size in bytes. Once the log exceeds this size the log file will rotate.
Default: 100MB  Set in bytes.

Parameter change needs a process restart: APPLY/MINE/FETCHER depending on the process specific setting (e.g. APPLY.LOG_FILE_SIZE)

Obsolete, don’t use

Values: integer (days)

Default: 0

Parameter change needs a process restart: APPLY/MINE

Obsolete, don’t use.

Values: integer (days)

Default: 0

Parameter change needs a process restart: MINE

LOG_PACKAGE_CSV_MAX_AGE

Limits the amount of data from metadata tables for the support package. Data older than (N) days will not be included.

Values: integer (days)

Default: 10

Parameter change needs a process restart: No

LOG_PACKAGE_TRC_MAX_AGE 

Limits the amount of data from trace files for the support package. Trace files older than (N) days will not be included.

Values: integer (days)

Default: 30

Parameter change needs a process restart: No

The password to be used if the SMTP server requires authentication.

Values: Any string with at least one character.

Default: OFF

Parameter change needs a process restart: No

The username to be used if the SMTP server requires authentication.

Values: Any string with at least one character.

Default: OFF

Parameter change needs a process restart: No

The From address to be used in outgoing emails.

Values: String, that represents one valid email address.

Default: nobody@example.com

Parameter change needs a process restart: No

The SMTP port to be used (for SMTP server it is usually 25; however, the usual value for SSL-enabled SMTP server is 465).

Values: Any integer number greater or equal to zero.

Default: 25

Parameter change needs a process restart: No

Sets SMTP mail server to be used for sending emails.

Values: Any string with at least one character.

Default: localhost

Parameter change needs a process restart: No

Use SSL protocol for the SMTP server

Values: YES/NO/TLS. (case insensitive)

Default: NO

Parameter change needs a process restart: No

Memory limit for MINE, specified in megabytes. Note that these figures do not include overhead of Perl and of system malloc(), thus do not set it to consume all of your available memory. It does not use ulimit or other OS-based limits. Settings this too low will cause MINE to abort.

Values: Any integer number greater or equal to zero.

Default: 2048

Parameter change needs a process restart: MINE

Memory limits for APPLY, specified in megabytes. Note that these figures do not include overhead of Perl and of system malloc(), thus do not set it to consume all of your available memory. It does not use ulimit or other OS-based limits. Setting this low may cause performance degradation, setting it too low will cause APPLY to abort.

Values: Any integer number greater or equal to zero.

Default: 2048

Parameter change needs a process restart: APPLY

MINE will ONLY look in this directory for archivelogs. This parameter will be used in conjunction with the REDO_READ_METHOD set to ARCHONLY.

Values: Any string (even empty one).

Default: "" (empty string).

Parameter change needs a process restart: No

This parameter is used together with MINE_ARCH_DEST. Available options: %T_%S_%R %E for standby.

Values: Any string (even empty one).

Default: "" (empty string).

Parameter change needs a process restart: No

SID for ASM (usually +ASM). Note that on RAC, this must be set to the local ASM node name (e.g. +ASM2).

Values: "", "AUTO", "OFF", SOME_OTHER_STRING

Value "" meaning: This instructs Dbvisit Replicate to detect if there is ASM of there is no ASM. If ASM was detected → detect SID for ASM automatically and use it, if ASM was not detected → use redo logs on the filesystem.

Value "AUTO" meaning: This instructs Dbvisit Replicate to use ASM, but it should detect the SID for ASM automatically and use it.

Value "OFF" meaning: This instructs Dbvisit Replicate to ignore redo logs in ASM and uses the redo logs on the file system (when they are multiplexed). This is useful when using older versions of ASM such as 10.1 as Dbvisit Replicate only supports ASM version 10.2 and higher. 

Value SOME_OTHER_STRING meaning: This instructs Dbvisit Replicate to use ASM, and use SOME_OTHER_STRING as SID.

Default: "" (empty string).

Parameter change needs a process restart: MINE/FETCHER

Converts the Timezone to UTC time.

For use with the Kahiti project. Used in Conjunction with MINE.SOURCE_TIMEZONE parameter that is set automatically with the Setup Wizard. If you are using with regular APPLY, you have to set APPLY.SOURCE_TIMEZONE=UTC (so APPLY does not recalculate the TZ with LTZ values once again).

Values: NO/YES

Default: NO

Parameter change needs a process restart: MINE

MINE database TNS connection string.
Default will depend on what was setup in the Setup Wizard

Parameter change needs a process restart: MINE

DBID (see v$database) of databases where mine connects. It always set by setup wizard. This helps to check that the connection strings resolve to correct databases = the same ones from mine server.

Default is an empty string.

Parameter change needs a process restart: MINE

Mine dictionary database TNS connection string.
Is the MINE repository stored in another db than the MINE db?

Default (empty)

Parameter change needs a process restart: MINE

Optional DBID for the mine dictionary database. Checks that mine connects to the correct database.

Default (empty)

Parameter change needs a process restart: MINE

Encrypted fetcher dictionary database password. (Use ENCRYPT command to get encrypted password from the plain text password.)

Default (empty)

Parameter change needs a process restart: MINE

Database schema containing the repository tables (usually same as MINE_DICTIONARY_USER)

Default (empty)

Parameter change needs a process restart: MINE

Mine dictionary database login username.

Default (empty)

Parameter change needs a process restart: MINE

Mine pauses if PLOGs + REDOlogs take more disk space than is the limit set by this variable. The default value 0 disables the feature.

Default: 0

Parameter change needs a process restart: No

This parameter determines the frequency of how often an update happens to the DBRSCOMMON_HEARTBEAT table in the dbvrep schema. This table can be used to monitor the state of replication. Value is in seconds. If you want to disable this feature set to 0.

Values: Any integer number equal or greater than zero.

Default: 10 (seconds)

Parameter change needs a process restart: No

Network interface on which MINE listens for commands (hostname:port).

Default will depend on what was setup in the Setup Wizard.

Parameter change needs a process restart: MINE

If set to YES mine skips all changes done by apply process. It does not care about which ddc it was, which dbvrep user etc. This is useful for two way replication.

• YES
• NO (default)

Parameter change needs a process restart: MINE/APPLY

Encrypted FETCHER database password. (Use ENCRYPT command to get encrypted password from the plain text password.)

Default will depend on what was setup in the Setup Wizard

Parameter change needs a process restart: MINE

What is the corresponding MINE for this process? If SIMPLE_CONFIG = YES, this is simply set to MINE.

Parameter change needs a process restart: FETCHER

%S.%E is the default in the Setup Wizard (list of all possible placeholders see at the end of this page)

and the directory is usually /install/mine/

Parameter change needs a process restart: MINE

Where to connect to reach this MINE process. This is usually same as MINE_LISTEN_INTERFACE, but may be changed if the name resolution works differently among the machines, listen binds to selected interfaces only, etc. Note that this settings is used by the console, too.

Default will depend on what was setup in the Setup Wizard

Parameter change needs a process restart: MINE

A TRUNCATE TABLE statement is replicated to target rewritten as simple "TRUNCATE TABLE schema.table", dropping any Oracle-specific options. This enables Replicate to replicate to non-Oracle targets and thus support this command, although it's formally a DDL statement.
Set it to NO if you use Oracle-specific options and need them to be preserved, e.g. CASCADE for Oracle 12c truncating of tables with foreign keys.

Default: YES

Parameter change needs a process restart: No

Database schema containing the repository tables (usually same as MINE_USER).

Default will depend on what was setup in the Setup Wizard

Parameter change needs a process restart: MINE

Directory where to store redo logs received from FETCHER.
Default empty string.

Parameter change needs a process restart: No

Trace file can be compared with trace file generated by Oracle alter system dump logfile.

• OFF (default)
• ON

Parameter change needs a process restart: No

If set to YES mine will replicate TRUNCATE operations even when DDL replication is off.

• YES (default)
• NO

Parameter change needs a process restart: MINE

Unique ID of MINE, regenerated every time the MINE dictionary is recreated, e.g. when scripts created by setup wizard are re-run. This ID uniquely identifies the PLOGS, so they do not get mixed up between different replications.

MINE database login username.

Parameter change needs a process restart: MINE

This is the national character set of the source database. This is relevant only for NCHAR/NVARCHAR2 columns. Only UTF8 and AL16UTF16 values are supported; Oracle expects Unicode values to be specified in UTF16, so if the source database is using UTF8 (specified by this setting), APPLY does the necessary conversion to UTF16. Any other (legacy) mutlibyte character sets are currently not supported.
Default: AL16UTF16

Parameter change needs a process restart: MINE

Common key for network authorization among FETCHER, MINE, APPLY and console.
Default: key varies

Parameter change needs a process restart: MINE/APPLY/FETCHER/CONSOLE

The NLS_LANG variable is set at the APPLY environment and behaves like the NLS_LANG environment does: it sets the language, territory and character set of the APPLY session. The language and territory are not very important (they affect things like Oracle error messages shown), the character set must be set to the source database character set, so the any character strings applied are treated correctly according the character set they are in.

Apart from setting the NLS_LANG to a character set. The values of NLS_LANG can also be:

• KEEP_UNDEF - ignore the NLS_LANG environment setting
• KEEP - use the NLS_LANG environment setting

Note: These above 2 settings should be set using the "memory_set" and not the "set" command. Example:

memory_set MINE.NLS_LANG=KEEP_UNDEF

This can be set in the MINE ddc file.

Also see NLS Considerations.

Default will depend on NLS settings of the environment the dbvrep executable was run on.

Parameter change needs a process restart: MINE/APPLY

The error notification emails (=all except list progress and heartbeat) are sent to these addresses. Separate multiple addresses by comma.
Default = OFF 

Parameter change needs a process restart: Yes

All notifications emails are sent to these addresses. Separate multiple addresses by comma.

Default = OFF 

Parameter change needs a process restart: No

NOTIFY_CONFLICT_THRESHOLD

If APPLY is waiting on conflict (PAUSE handler), should a notification be sent?

• YES (default)
• NO

Parameter change needs a process restart: No

If APPLY is waiting on conflict (RETRY handler), after how many retries should a notification be sent?

Values: Integer

Default: 2

Parameter change needs a process restart: No

Times when the overall progress email should be sent. Use 24-hour time format, separate multiple times by colon, e.g. 0700 or 0800:2000. Note that times near to midnight may be skipped, if no check gets scheduled till midnight (see also NOTIFY_INTERVAL_BETWEEN_CHECK). 

Default: 0700

Parameter change needs a process restart: No

How many times must be a notification condition be met before the SNMP trap / email is actually sent. (\

Values: Integer

Default: 2

Parameter change needs a process restart: No

How many times a notification will be sent out via email for a given incident.
Values: Integer
Default: 10
Parameter change needs a process restart: No

How often the notification checks are performed. (Specify seconds, minutes, hours, days, as needed, e.g. 5m or 1h20m30s).

Value: Integer (plus s:m:h:d)

Default: 5m

Parameter change needs a process restart: No

NOTIFY_ON_DDL

Sends an email when apply replicates a DDL statement.

• YES (default)
• NO

Parameter change needs a process restart: Apply

ALL or colon-separated list. If the specified peer is down, sends an SNMP trap and/or email.

Example:

MINE:APPLY:APPLY1

Default: ALL

Parameter change needs a process restart: No

SCN difference: if the lag between APPLY and MINE exceeds this threshold, an SNMP trap and/or email is sent.

Values: Integer

Default is 10000

Parameter change needs a process restart: Yes

Times when the overall heartbeat email should be sent. Use 24-hour time format, separate multiple times by colon, e.g. 0700 or 0800:2000. Note that times near to midnight may be skipped, if no check gets scheduled till midnight (see also NOTIFY_INTERVAL_BETWEEN_CHECK).

Default: 0800:1300

Parameter change needs a process restart: No

Number of redo logs / PLOGS: if the lag between APPLY and MINE or MINE and FETCHER exceeds this threshold, an SNMP trap and/or email is sent.

Values: Integer

Default: 10

Parameter change needs a process restart: No

The list progress and heartbeat emails are sent to these addresses. Separate multiple addresses by comma.

Default: OFF

Parameter change needs a process restart: No

The time, in seconds, between MINE and APPLY. If the lag between APPLY and MINE or MINE and FETCHER exceeds this threshold, an SNMP trap and/or email is sent.

Values: Integer

Default: 300

Parameter change needs a process restart: No

Commit options for APPLY sessions (target). Can be either 

• DEFAULT (default)
• WAIT IMMEDIATE
• WAIT BATCH
• NOWAIT IMMEDIATE
• NOWAIT BATCH 

The default value is DEFAULT, which is the usual behaviour of commit on Oracle. DEFAULT is the only valid option for Oracle 9i. Option is ignored for non-Oracle databases. Consult with support before setting, as some of the non-default values may lead to data loss in some special cases such as RAC. Setting to NOWAIT BATCH means APPLY will not wait for commit redo to be written to disk. This may improve performance of APPLY, but is not recommended for RAC target systems because during a crash of one of the nodes not all the SCN information of the replication will be up to date. And this may cause data loss in the replication. For RAC target systems set to WAIT IMMEDIATE which means commit wait. For Oracle current versions, DEFAULT is the same as WAIT IMMEDIATE.

Parameter change needs a process restart: APPLY

Should errors be treated fatal? Usually used in DDC file so that failed variable checks are clearly pointed out.

• SKIP (default): continue
• EXIT: fatal error and stop

Parameter change needs a process restart: No

Should warnings be treated fatal?

• SKIP (default): continue
• EXIT: fatal error and stop

Parameter change needs a process restart: No

Set this variable for Dbvisit Replicate with the same affect as setting them in the shell environment. Note that ASM connection use bequeath connection and thus need same ORACLE_HOME as that when ASM actually resides.

Default: empty string

Parameter change needs a process restart: MINE

Set this variable for Dbvisit Replicate with the same affect as setting them in the shell environment for any Oracle client.

Default: empty string

Parameter change needs a process restart: MINE

Format of SQL in conflict log table:

• BIND
• NOBIND (default)
• BOTH

BIND = show SQL statements with bind variables

NOBIND = show SQL statements with literals

BOTH = show both

Parameter change needs a process restart: APPLY

Should PREPARE command check that the table exists on target database? 

• NO (default)

• YES

Parameter change needs a process restart: No

Should PREPARE command check that the table exists on target? Default: YES. Note that both mine and apply checks also include supported datatypes, for apply we check that the datatypes match with source.

• YES (default)

• NO

Parameter change needs a process restart: No

Global Temporary Tables will be checked when the PREPARE command is run. Global Temporary Tables will be ignored. If you have a large number of tables you may wish to set the parameter to NO to speed up the PREPARE command, however this may mean that Global Temporary Tables are replicated.

• YES (default starting in 2.7.12)

• NO

Parameter change needs a process restart: No

PREPARE_SCHEMA_EXCEPTIONS

The list of schema.tables to be skipped in PREPARE SCHEMA. This is part of Step 3 in the Setup Wizard if you specify exceptions.

Values: string

Default: (empty)

Parameter change needs a process restart: No

Set type of process to MINE/FETCHER/APPLY (this must be set per-process). With SIMPLE_CONFIG, APPLY process is set to APPLY, MINE to MINE and if FETCHER is enabled, FETCHER to FETCHER.

Default: APPLY.PROCESS_TYPE = APPLY

MINE.PROCESS_TYPE = MINE

This parameter is not supposed to be changeable (The only situation which comes to mind is that value changed to OFF in order to switch off one of the apply processes).

Parameter change needs a process restart: APPLY

OFF / profiler file name. Use only as instructed by support. This will generate extra trace files with profiling information that can be used by support to further diagnose issues. This can be turned on for the MINE or APPLY process or both.

Example:
SET PROFILER /home/oracle/..../prof_%S.%E in the DDC file.

Restart the process and wait for a few log switches, then zip and upload the resulting files to support.                       

The specified path can be arbitrary but ensure to include %S in the name so a new file is generated for each log switch. 

Please see Dbvisit Replicate Profile Performance Statistics for more information.

Default: OFF

Parameter change needs a process restart: MINE/APPLY

Specify if both online redo logs and archive logs should be used or archive log only (archivelogs only) files exclusively.

• REDOFIRST (default, use both online redo and archive logs)
• ARCHONLY (use only archive logs)

Set this in the *MINE.ddc only.

Parameter change needs a process restart: MINE

Determines whether Replicate internal tables (DBRSOBJ$, DBRSUSER$, DBRSCOMMON_HEARTBEAT and for CSV output also DBRSCOL$) are replicated to target.

Do not change to NO unless instructed by Dbvisit support, as apply depends on this to work correctly.

• YES (default)
• NO

Parameter change needs a process restart: MINE

Seconds between retries if conflict handling is RETRY.

Default: 5 seconds

Parameter change needs a process restart: no

Path to setup scripts. Used when packing scripts for support.

This path is set as part of the Setup Wizard.

Parameter change needs a process restart: no

If set to YES, configures processes MINE, FETCHER (if fetcher_enabled) and APPLY. Use for a single one-way configuration.

Default: YES

Parameter change needs a process restart: no

Disables/enables SNMP subagent. Also sets the index in the process table presented by the SNMP agent. (Set to 0 to disable SNMP, set to 1 if there is just one process of that particular type on the machine, set to unique values for each process type if there are multiple processes of the same type)
On Windows, no SNMP agent is supported and thus the only value supported is 0.

Default: 0

Parameter change needs a process restart: FETCHER/MINE/APPLY

Sets community (=password) for sending of SNMP traps.

Default: public

Parameter change needs a process restart: FETCHER/MINE/APPLY

Sets destination for SNMP traps (notifications).

• OFF (default)
• hostname
• hostname:port

Parameter change needs a process restart: FETCHER/MINE/APPLY

Determines the source database timezone so that "TIMESTAMP WITH LOCAL TIME ZONE" datatype is handled properly.

The default is UNKNOWN, meaning we autodetect it.

If this autodetection is wrong, set this variable manually to an Oracle-known timezone.

Values: UNKNOWN/time zone (can be both +HH:MM or a name like Africa/Johanesburg).

Parameter change needs a process restart: MINE

SQL_QUOTE_IDENTIFIERS

Quote owner/table/column name in apply SQL. Uses "" for Oracle, [] for MSSQL.

• AUTO (default) Auto means YES for Oracle and MSSQL and NO for MYSQL.
• YES
• NO

Parameter change needs a process restart: APPLY

Enable Oracle sql trace (aka 10046) on all Replicate Oracle sessions.

• YES
• NO (Default)

Parameter change needs a process restart: no

Show status bar in console

• OFF: no status bar
• ON or STATUS: show SCNs and time 
• LIST: show "list progress"
• LISTALL: show "list progress all"
• STATUS+LIST: show both STATUS and LIST (default setting by setup wizard)
• STATUS+LISTALL: show both STATUS and LISTALL

Parameter change needs a process restart: CONSOLE

This is set to a number to limit the number of active tables shown in the status bar. Example: STATUS_BAR_ACTIVE_TABLES = 20

Default: AUTO

Parameter change needs a process restart: no

How often should be a log message written to log showing number of processed LCRs (in LCR count) (use 0 to disable). Changes on log switch.
Values: Integer

Default: 10000 

Parameter change needs a process restart: no

How often should be a log message written to log showing number of processed LCRs (in seconds) (use 0 to disable). Changes on log switch.

Values: Integer

Default: 120

Parameter change needs a process restart: no

If set to YES, then the APPLY status line in the status bar will show the number of past conflicts even when they are resolved. This is the default.

YES (default)

NO

Example: 
APPLY IS running. Currently at PLOG 2453 and SCN 14696300 (08/16/2012 16:19:17) and 2 APPLY conflicts so far (last at 16/08/2012 15:07:37). 

If set to No, then the APPLY status line in the status bar will only show the current conflict. When they are resolved it will not show past conflicts.

Example:
APPLY IS running. Currently at PLOG 2453 and SCN 14696300 (08/16/2012 16:19:17) 

Parameter change needs a process restart: no

Set for each process to specify sort order in status bar. Simple config does this automatically, setting the order FETCHER.STATUS_SORT=01, MINE.STATUS_SORT=02, APPLY.STATUS_SORT=03.

Default:

APPLY.STATUS_SORT = 01

MINE.STATUS_SORT = 00

Parameter change needs a process restart: no

Controls whether the apply process dumps memory info on every log switch.

• YES
• NO (Default)

Parameter change needs a process restart: APPLY

Enables the profiler.

• YES (Default)
• NO

Parameter change needs a process restart: MINE

Determines whether profiler information should be printed to the log file on every redo log switch. Change of the parameter is applied on log switch.

• YES (Default)
• NO

Parameter change needs a process restart: no

Determines how many top events will be printed to the log for each plog that is processed. Change of the parameter is applied on log switch.

• 10 (Default)

Parameter change needs a process restart: no

When profiling information is printed to the log, it determines how many of the lastest plogs, should have the statistics calculated and printed.

• 10 (default)

Parameter change needs a process restart: MINE

Mandatory parameter that is set in the wizard. Points to tnsnames.ora/sqlnet.ora to be used to resolve connection strings.
Default is set during the setup wizard. 

Default: TNS value set during the Setup Wizard.

Parameter change needs a process restart: FETCHER/MINE/APPLY

Set this variable for Dbvisit Replicate with the same affect as setting them in the shell environment for any Oracle client.

Default: empty string

Parameter change needs a process restart: FETCHER/MINE/APPLY

Watchdog will show SQL with actual values instead of just bind variables.

• YES
• NO (default)

Parameter change needs a process restart: APPLY

Timeout for waiting on lock to be released when applying (most notably for TM/TX locks, i.e. waiting for other sessions modifying the same rows). (Waits ½ of this time before aborting due to internal deadlocks etc., waits full time for other users.)

Values: Integer (seconds)
Default: 30 

Parameter change needs a process restart: no