For the complete documentation index, see llms.txt. This page is also available as Markdown.

Extract Parameters

ARCHIVE_LOG_DIR

ARCHIVE_LOG_DIR specifies the directory where the archive logs are stored. It must be specified as an absolute path.

Parameter Format

Property
Description

Parameter type

path

Default Value

""

Class

Optional, Static

Range

ARCHIVE_LOG_FORMAT

ARCHIVE_LOG_FORMAT specifies the archived log file format. Supported formats are %r:RESETLOGS_CHANGE#, %s:SEQUENCE#, %S:8byte SEQUENCE# padded with 0, and %t:THREAD#.

Parameter Format

Property
Description

Parameter type

String

Default Value

"log-t%t-r%r-s%s.arc"

Class

Mandatory, Static

Range

ASM_DB_NAME

ASM_DB_NAME specifies the Oracle ASM instance alias used by oracle log reader. Required for ASM redo file(+...) access.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

ASM_IO_WORKERS

ASM_IO_WORKERS specifies the number of ASM parallel I/O worker sessions used by oracle log reader when reading ASM redo (+...). Applied at extract startup only (not dynamic). Effective workers = min(ASM_IO_WORKERS, compile-time OLR_ASM_PARA_WORKERS).

Parameter Format

Property
Description

Parameter type

Integer

Default Value

4

Class

Optional, Static

Range

1 - 8

ASM_PWD

ASM_PWD specifies the Oracle ASM user password used by oracle log reader. Required for ASM redo file(+...) access.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

ASM_USER

ASM_USER specifies the Oracle ASM user used by oracle log reader. Required for ASM redo file(+...) access.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

BINLOG_INIT_POSITION

BINLOG_INIT_POSITION specifies the starting position of mysql binlog.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

120

Class

Optional, Static

Range

1 - INT32_MAX

COL_SAM_TEMPLATE

The COL_SAM_TEMPLATE parameter sets the path to the user-defined template file to be used when outputting column content for DML statements. It works when SQL_REDO_MODE is set to N. When logging DML statements, if column definitions are present in the COL_SAM_TEMPLATE, ProSync logs the column information to the SAM file according to that template format.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

CONNECT_TO_APPLY_CHECK_INTERVAL

CONNECT_TO_APPLY_CHECK_INTERVAL specifies the interval at which the connection is attempted when the connection between ext and apply is lost.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

0

Class

Optional, Static

Range

0 - 3600

CONN_MAX

CONN_MAX specifies the max number of connections between processes.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

128

Class

Optional, Static

Range

32 - 1024

DICT_FILE_DIR

DICT_FILE_DIR specifies the directory where user wants to make dictfile while using oracle logminer version.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

DSN_DIR

DSN_DIR specifies the directory where the dsn file located. It must be specified as an absolute path.

Parameter Format

Property
Description

Parameter type

path

Default Value

""

Class

Optional, Static

Range

DSN_FILE

DSN_FILE specifies name of dsn file.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

DUMMY_LOG_SEND_INTERVAL_COMMIT_TSN

DUMMY_LOG_SEND_INTERVAL_COMMIT_TSN specifies the interval of sending dummy tx to prevent synchronization delay in TAC and RAC.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

1000

Class

Optional, Static

Range

10 - UINT64_MAX

DUMMY_TX_INTERVAL

DUMMY_TX_INTERVAL specifies the interval (in seconds) at which the extract process generates a dummy transaction on the source database. At each interval the extract process updates the row for its own extract number in PRS_DUMMY_TBL on the local source instance and commits, so that redo or WAL keeps being generated even while no user DML occurs. This prevents the apply process from delaying transaction merge because of an idle node in a cluster (TAC or RAC) environment. The interval is measured from the previous dummy transaction regardless of whether logs remain to be read, a value smaller than 5 is treated as 5, and the dummy transaction is generated only when EXT_TO_APPLY is Y.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

5

Class

Optional, Static

Range

1 - 1000

ENABLE_NETWORK_COMPRESS

ENABLE_NETWORK_COMPRESS specifies whether to compress data when sending data from the extract process to the apply process. If set to 'Y', performance may be affected due to the compress/decompress process when sending/receiving data. This is useful when sending large amounts of data across a large network.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Dynamic

Range

ENABLE_NETWORK_ENCRYPT

ENABLE_NETWORK_ENCRYPT specifies whether to encrypt data when sending data from the extract process to the apply process. If set to 'Y', data is sent using the SSL protocol.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

ENABLE_SYNC_TABLE_FILTER

determines whether to send only LCR of synchronization table to the apply process

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

ENABLE_TSC_STANDBY

ENABLE_TSC_STANDBY enables TSC standby source mode. In this mode, ProSync reads from SRC_DB_NAME and sends source-side writes to SRC_PRIMARY_DB_NAME.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

EXCLUDE_USER

EXCLUDE_USER specifies the name of a user to be excluded from extract operations. If bi-directional synchronization is used, enter a ProSync user name that uses reverse directional synchronization.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

EXTRACT_ARCHIVE_LOG_ONLY

EXTRACT_ARCHIVE_LOG_ONLY specifies to only extract archived log. If set to 'Y', redo log is archived and cannot be extracted until a new archived log is created.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

EXTRACT_NUM

EXTRACT_NUM specifies the instance number of the source database. It must be greater than or equal to 1. For a database cluster, each extract process must be assigned a different number in sequential order (1, 2, 3...).

Parameter Format

Property
Description

Parameter type

Integer

Default Value

1

Class

Mandatory, Static

Range

1 - 1024

EXT_TO_APPLY

EXT_TO_APPLY specifies whether the extract process sends the extracted change records to the apply process. If set to 'N', the chunks that the read threads produce are not transmitted to any apply process, so this parameter is normally set to 'N' only together with EXT_TO_SAM in order to write the extracted changes into the SAM file without replicating them. The periodic dummy transaction controlled by DUMMY_TX_INTERVAL is also generated only when this parameter is set to 'Y'.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

Y

Class

Optional, Static

Range

EXT_TO_SAM

This parameter sets whether to log statements that are passed from the EXT process to the APPLY process into the SAM file. (Y/N)

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Dynamic

Range

INSTANCE_FAILURE_CHECK_INTERVAL

INSTANCE_FAILURE_CHECK_INTERVAL specifies instance status check interval (in seconds) in a cluster database environment. The extract process does not perform status checks at each interval. The check occurs at the set interval from the time when there are no more redo or archive logs to read (no new logs are generated).

Parameter Format

Property
Description

Parameter type

Integer

Default Value

5

Class

Optional, Static

Range

5 - 3600

LOG_BACKUP_DIR

LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.

Parameter Format

Property
Description

Parameter type

path

Default Value

""

Class

Mandatory, Static

Range

LOG_BACKUP_SIZE

LOG_BACKUP_SIZE specifies the maximum size of all backup files in the process. If this limit is exceeded, the oldest log files in the directory are deleted.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

0

Class

Optional, Dynamic

Range

0 - 128G

LOG_DIR

LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.

Parameter Format

Property
Description

Parameter type

path

Default Value

""

Class

Mandatory, Static

Range

LOG_FILE_SIZE

LOG_FILE_SIZE specifies the maximum log file size. If a log file exceeds this limit, it is moved to the backup directory and a new log file is created.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

104857600

Class

Optional, Dynamic

Range

1M - 1G

LOG_LEVEL

LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

3

Class

Mandatory, Dynamic

Range

1 - 5

LOG_SWITCH_INTERVAL

LOG_SWITCH_INTERVAL specifies interval of log switch.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

0

Class

Optional, Static

Range

0 - INT32_MAX

LR_FILE_CNT

LR_FILE_CNT determines how many lr files to keep in LR directory

Parameter Format

Property
Description

Parameter type

Integer

Default Value

0

Class

Optional, Static

Range

0 - 2147483647

LR_FILE_DELETE_MODE

LR_FILE_DELETE_MODE determines how to control lr files

Parameter Format

Property
Description

Parameter type

String

Default Value

"CNT"

Class

Optional, Static

Range

LR_FILE_RETENTION_DAY

LR_FILE_RETENTION_DAY determines retention period(days) for lr files

Parameter Format

Property
Description

Parameter type

Integer

Default Value

0

Class

Optional, Dynamic

Range

0 - 36500

LR_FILE_TOTAL_SIZE

LR_FILE_TOTAL_SIZE determines max size of lr files to keep in LR directory

Parameter Format

Property
Description

Parameter type

Integer

Default Value

0

Class

Optional, Static

Range

0 - 1000G

LR_LOG_BACKUP_DIR

LR_LOG_BACKUP_DIR specifies the directory where the LR_LOG files of ext process are backed up. It must be specified as an absolute path.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

LR_LOG_BACKUP_SIZE

LR_LOG_BACKUP_SIZE specifies the maximum size of LR_LOG backup files of ext process. If this limit is exceeded, the oldest LR_LOG files in the directory are deleted.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

0

Class

Optional, Static

Range

0 - 128G

LR_LOG_DIR

LR_LOG_DIR specifies the directory where the LR_LOG files are stored. It must be specified as an absolute path.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

LR_LOG_FILE_SIZE

LR_LOG_FILE_SIZE specifies the maximum LR_LOG file size of ext process. If a LR_LOG file exceeds this limit, it is moved to the backup directory and a new LR_LOG file is created.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

17179869184

Class

Optional, Static

Range

1M - 16G

LR_STOP_AT_CORRUPTED_LCR_0

LR_STOP_AT_CORRUPTED_LCR_0 determines whether to stop when extracting a corrupted LCR for a table with object id and segment id equal to 0

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

LR_STOP_AT_CORRUPTED_LCR_ALL

LR_STOP_AT_CORRUPTED_LCR_ALL determines whether to stop when extracting all types of corrupted LCR

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

LR_STOP_AT_CORRUPTED_LCR_TARGET

LR_STOP_AT_CORRUPTED_LCR_TARGET determines whether to stop when a corrupted LCR is extracted for the synchronization table

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

LR_TRACE_LVL

LR_TRACE_LVL specifies the logging level of the log reader. A higher log-level produces more detailed logs.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

2

Class

Optional, Dynamic

Range

1 - 5

LR_WARN_AT_CORRUPTED_LCR_0

LR_WARN_AT_CORRUPTED_LCR_0 determines whether the log type of a corrupted LCR with object id and segment id equal to 0 will be [W] or [F]

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

Y

Class

Optional, Static

Range

LR_WARN_AT_CORRUPTED_LCR_ALL

LR_WARN_AT_CORRUPTED_LCR_ALL determines whether the log type for all types of corrupted LCR will be [W] or [F]

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

Y

Class

Optional, Static

Range

LR_WARN_AT_CORRUPTED_LCR_TARGET

LR_WARN_AT_CORRUPTED_LCR_TARGET determines whether the log type of a corrupted LCR for the synchronization table will be [W] or [F]

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

MYSQLBINLOG_RETRY_CNT

MYSQLBINLOG_RETRY_CNT specifies how many consecutive times the extract process retries when the mysqlbinlog command that it runs to read the source binary log fails. Each retry switches to local mode, which copies the binary log file under $PRS_HOME/var/<instance>/binlog_backup and reads it locally, and the retry count is reset to 0 after a successful run. Extraction stops with an error once the retry count reaches this value, so 0 means that the extract process stops on the first failure.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

3

Class

Optional, Static

Range

0 - 10000

MYSQLBINLOG_RETRY_INTERVAL

MYSQLBINLOG_RETRY_INTERVAL specifies the time (in seconds) that the extract process waits before retrying when the mysqlbinlog command that it runs to read the source binary log fails. The retry itself is repeated up to MYSQLBINLOG_RETRY_CNT times.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

3

Class

Optional, Static

Range

1 - 120

MYSQL_BINLOG_PREFIX

MYSQL_BINLOG_PREFIX specifies the prefix of mysql binlog file name.

Parameter Format

Property
Description

Parameter type

String

Default Value

"bin"

Class

Optional, Static

Range

NETWORK_COMPRESS_LEVEL

NETWORK_COMPRESS_LEVEL specifies the zlib compression level that the extract process uses when it compresses a chunk before sending it to the apply process. 0 means no compression and 9 means maximum compression, so a higher level reduces the amount of data sent over the network but consumes more CPU. This parameter takes effect only when ENABLE_NETWORK_COMPRESS is set to 'Y'.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

1

Class

Optional, Static

Range

0 - 9

OCI_DRIVER

OCI_DRIVER specifies a path to the client library used to access a database. An absolute path must be specified. for Oracle, enter a path to the libclntsh.so file.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

ODBC_DRIVER

ODBC_DRIVER specifies a path to the client library used to access a database. An absolute path must be specified. Set a path to the proper library file.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

PQ_DRIVER

PQ_DRIVER specifies a path to the pq library used to access a database. An absolute path must be specified. For PostgreSQL, set a path to the libpq.so file.

Parameter Format

Property
Description

Parameter type

path

Default Value

""

Class

Optional, Static

Range

PQ_REP_CONN_NAME

PQ_REP_CONN_NAME specifies the replication connection name.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

PREFETCH_SIZE

PREFETCH_SIZE specifies the number of rows to fetch for each oci fetch call. This parameter is used only in oracle logminer version.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

1

Class

Optional, Static

Range

1 - UINT32_MAX

PRS_PROC_AGENT_CONNECTION_TIMEOUT

connection timeout from process to agent. if a process cannot connect to agent while this timeout, kill itself

Parameter Format

Property
Description

Parameter type

Integer

Default Value

180

Class

Optional, Static

Range

0 - 86400

PRS_PWD

PRS_PWD specifies the database user password. If the password is encrypted, append the string '#encrypted'.

Parameter Format

Property
Description

Parameter type

String

Default Value

"#encrypted"

Class

Mandatory, Static

Range

PRS_USER

PRS_USER specifies the database user.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Mandatory, Static

Range

REPO_RESOURCE_INSERT_INTERVAL

This parameter decides how often to insert resource data into repoDB.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

60

Class

Optional, Static

Range

60 - 3600

RESUME_WAIT_TIME

RESUME_WAIT_TIME specifies the interval (in seconds) at which the read thread of the extract process polls for a resume while its log reading is suspended. The read thread is suspended when it is paused by an administrator command, when it is paused by flow control from the apply process, or while an ADD TABLE, DEL TABLE, or DD reload request is being processed, and it sleeps for this interval on every polling iteration until the request is cleared.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

3

Class

Optional, Static

Range

1 - 120

RETENTION_FILE_CLEANUP_INTERVAL

RETENTION_FILE_CLEANUP_INTERVAL specifies how often retention-based file cleanup is checked.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

3600

Class

Optional, Dynamic

Range

60 - 86400

ROLLBACK_OBJECT_IDS

If a transaction references any object ID listed in this parameter, skip the entire transaction.

Parameter Format

Property
Description

Parameter type

desc

Default Value

"()"

Class

Optional, Static

Range

SAM_BACKUP_DIR

SAM_BACKUP_DIR specifies the directory where the SAM files are backed up. It must be specified as an absolute path.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

SAM_BACKUP_SIZE

SAM_BACKUP_SIZE specifies the maximum size of SAM backup files. If this limit is exceeded, the oldest SAM files in the directory are deleted.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

0

Class

Optional, Dynamic

Range

0 - 128G

SAM_BIND_VALUE

SAM_BIND_VALUE specifies whether to retain the values of the query in SAM files. If set to 'Y', the specific values of the query are retained. If set to 'N', every value in the query is replaced with '?'.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

Y

Class

Optional, Dynamic

Range

SAM_DIR

SAM_DIR specifies the directory where the sam files are stored. It must be specified as an absolute path.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

SAM_FILE_SIZE

SAM_FILE_SIZE specifies the maximum SAM file size. If a SAM file exceeds this limit, it is moved to the backup directory and a new SAM file is created.

Parameter Format

Property
Description

Parameter type

Integer

Default Value

17179869184

Class

Optional, Dynamic

Range

1M - 16G

SAM_LOG_PREFIX

SAM_LOG_PREFIX specifies whether to include timestamp and thread information for each query in the SAM files, similar to how prosync logging works. If set to 'Y', this information is prepended to each row in the SAM files. If set to 'N', the timestamp and thread information is not included on each row.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

Y

Class

Optional, Dynamic

Range

SQL_REDO_MODE

The SQL_REDO_MODE parameter specifies whether to log the full DML/DDL statements into the SAM files. Y: The DML statements are logged row-by-row into the SAM files. (This is the default setting). N: The DML statements are not logged row-by-row into the SAM files.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

Y

Class

Optional, Static

Range

SRC_DB_IP

SRC_DB_IP specifies the database IP Address.

Parameter Format

Property
Description

Parameter type

String

Default Value

"localhost"

Class

Optional, Static

Range

SRC_DB_NAME

SRC_DB_NAME specifies the name(Alias) of the source database. For TIBERO, UPDB, or K-DB, use the value specified in the dsn file. For ORACLE, use the value specified in the tnsname file.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Mandatory, Static

Range

SRC_DB_PORT

SRC_DB_PORT specifies the database port.

Parameter Format

Property
Description

Parameter type

String

Default Value

"7600"

Class

Optional, Static

Range

SRC_DB_TYPE

SRC_DB_TYPE specifies the type of the source database to extract data from. Options are TIBERO, UPDB, KDB, or ORACLE.

Parameter Format

Property
Description

Parameter type

String

Default Value

"TIBERO"

Class

Mandatory, Static

Range

SRC_LOCAL_SID

SRC_LOCAL_SID indicates specified instance name of the source database in RAC or TAC.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

SRC_PRIMARY_DB_NAME

SRC_PRIMARY_DB_NAME specifies the writable primary database alias used when ENABLE_TSC_STANDBY is enabled.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

SRC_PRIMARY_LOCAL_SID

SRC_PRIMARY_LOCAL_SID indicates the writable primary local instance name used when ENABLE_TSC_STANDBY is enabled.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

STMT_SAM_TEMPLATE

The STMT_SAM_TEMPLATE parameter sets the path to the user-defined template file to be used when logging statement (DML/DDL) content to the SAM file. It works when SQL_REDO_MODE is set to N. ProSync reads the template from the specified path and logs the DDL and DML content to the SAM file according to that template format.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

TDE_FOR_EXT

TDE_FOR_EXT specifies whether use data decryption from source database

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

TDE_FOR_TABLESPACE

TDE_FOR_TABLESPACE specifies whether use tablespace decryption from source database

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

TDE_HSM_LIB_FILE

Absolute library path with the library file name. It is used for linking with an HSM device.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

TDE_HSM_PIN

pin value for HSM. It is used for linking with an HSM device.

Parameter Format

Property
Description

Parameter type

String

Default Value

""

Class

Optional, Static

Range

TDE_HSM_USE_WRAPPING

Option to use the PKCS #11 wrapping key option for linking an HSM device.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

Y

Class

Optional, Static

Range

TDE_USE_HSM

Option to use Hardware Security Module (HSM) to save data encryption keys.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range

TDE_WALLET_FILE

TDE_WALLET_FILE specifies the wallet file name of source db including absolute path

Parameter Format

Property
Description

Parameter type

String

Default Value

"/"

Class

Optional, Static

Range

TDE_WALLET_PWD

TDE_WALLET_PWD specifies the password of wallet file for tde

Parameter Format

Property
Description

Parameter type

String

Default Value

"#encrypted"

Class

Optional, Static

Range

TX_FILTER_KEY

TX_FILTER_KEY specifies the key tables that the extract process uses to filter changes at the transaction level. The default value FILTER DEFAULT disables transaction filtering. With EXCLUDE FILTER <owner>.<table>, <INSERT|DELETE|UPDATE|ALL> the extract process skips the entire transaction as soon as it performs the specified operation on a key table, and emits an entire-rollback record so that the changes already sent for that transaction are discarded. With SYNC FILTER <owner>.<table>, <INSERT|DELETE|UPDATE|ALL> it extracts only the transactions whose first DML is the specified operation on a key table and skips all the other transactions. The EXCLUDE and SYNC keywords select a mode for the whole extract process, not for an individual rule: all the key tables listed share one mode, and the mode is taken from the first rule that carries a keyword, so mixing EXCLUDE and SYNC rules in a single value is not supported and the extract process logs a warning when it finds such a mix. A rule written without a keyword, FILTER <owner>.<table>, <INSERT|DELETE|UPDATE|ALL>, only registers a key table and leaves the mode at its default, SYNC. Every key table listed must exist in the data dictionary, otherwise loading the DD fails.

Parameter Format

Property
Description

Parameter type

desc

Default Value

"(FILTER DEFAULT)"

Class

Optional, Static

Range

TX_SAM_TEMPLATE

The TX_SAM_TEMPLATE parameter sets the path to the user-defined template file to be used when outputting transactions to the SAM file. It works when SQL_REDO_MODE is set to N. ProSync reads the template from the specified path whenever a transaction encounters a commit, and logs the transaction content to the SAM file according to that template format.

Parameter Format

Property
Description

Parameter type

path

Default Value

"/"

Class

Optional, Static

Range

USE_LOGMNR

USE_LOGMNR specifies whether to use oracle logminer or to use oracle log reader, when analyzing redo logs.

Parameter Format

Property
Description

Parameter type

Boolean

Default Value

N

Class

Optional, Static

Range