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
Parameter type
path
Default Value
""
Class
Mandatory, 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
Parameter type
String
Default Value
"log-t%t-r%r-s%s.arc"
Class
Mandatory, Static
Range
BINLOG_INIT_POSITION
BINLOG_INIT_POSITION specifies the starting position of mysql binlog.
Parameter Format
Parameter type
Integer
Default Value
120
Class
Optional, Static
Range
1 - INT32_MAX
CLIENT_DRIVER
CLIENT_DRIVER specifies a path to the client library used to access a database. An absolute path must be specified. For Tibero, set a path to the libtbclnt.so file. And for Oracle, enter a path to the libclntsh.so file.
Parameter Format
Parameter type
path
Default Value
""
Class
Optional, Static
Range
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
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
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
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
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
Parameter type
path
Default Value
""
Class
Optional, Static
Range
DSN_FILE
DSN_FILE specifies name of dsn file.
Parameter Format
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
Parameter type
Integer
Default Value
1000
Class
Optional, Static
Range
10 - UINT64_MAX
DUMMY_TX_INTERVAL
DUMMY_TX_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
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
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
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
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
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
Parameter type
Integer
Default Value
1
Class
Mandatory, Static
Range
1 - 1024
EXT_TO_APPLY
Parameter Format
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
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
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
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
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
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
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
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
Parameter type
Integer
Default Value
0
Class
Optional, Static
Range
0 - INT32_MAX
LR_TRACE_LVL
LR_TRACE_LVL specifies the logging level of the log reader. A higher log-level produces more detailed logs.
Parameter Format
Parameter type
Integer
Default Value
2
Class
Optional, Dynamic
Range
1 - 5
MYSQLBINLOG_RETRY_CNT
Parameter Format
Parameter type
Integer
Default Value
3
Class
Optional, Static
Range
0 - 10000
MYSQLBINLOG_RETRY_INTERVAL
Parameter Format
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
Parameter type
String
Default Value
"bin"
Class
Optional, Static
Range
NETWORK_COMPRESS_LEVEL
Parameter Format
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
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
Parameter type
path
Default Value
"/"
Class
Optional, Static
Range
ORACLE10G_LOG_FILE_BLOCKSIZE
Parameter Format
Parameter type
Integer
Default Value
512
Class
Optional, Static
Range
512, 1024, 4096
PQ_DRIVER
PQ_DRIVER specifies a path to the pq library used to access a database. An absolute path must be specified. For Tibero, set a path to the libpq.so file.
Parameter Format
Parameter type
path
Default Value
""
Class
Optional, Static
Range
PQ_PUBLISH_NAME
PQ_PUBLISH_NAME specifies the publish name.
Parameter Format
Parameter type
String
Default Value
""
Class
Optional, Static
Range
PQ_REP_CONN_NAME
PQ_REP_CONN_NAME specifies the repliucation connection name.
Parameter Format
Parameter type
String
Default Value
""
Class
Optional, Static
Range
PQ_SLOT_NAME
PQ_SLOT_NAME specifies the replication slot name.
Parameter Format
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
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
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
Parameter type
String
Default Value
"#encrypted"
Class
Mandatory, Static
Range
PRS_USER
PRS_USER specifies the database user.
Parameter Format
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
Parameter type
Integer
Default Value
60
Class
Optional, Static
Range
60 - 3600
RESUME_WAIT_TIME
Parameter Format
Parameter type
Integer
Default Value
3
Class
Optional, Static
Range
1 - 120
SAM_BACKUP_DIR
SAM_BACKUP_DIR specifies the directory where the SAM files of ext process are backed up. It must be specified as an absolute path.
Parameter Format
Parameter type
path
Default Value
"/"
Class
Optional, Static
Range
SAM_BACKUP_SIZE
SAM_BACKUP_SIZE specifies the maximum size of SAM backup files of ext process. If this limit is exceeded, the oldest SAM files in the directory are deleted.
Parameter Format
Parameter type
Integer
Default Value
0
Class
Optional, Dynamic
Range
0 - 128G
SAM_BIND_VALUE
SAM_BIND_VALUE
Parameter Format
Parameter type
Boolean
Default Value
Y
Class
Optional, Dynamic
Range
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 '?'.
SAM_DIR
SAM_DIR specifies the directory where the sam files are stored. It must be specified as an absolute path.
Parameter Format
Parameter type
path
Default Value
"/"
Class
Optional, Static
Range
SAM_FILE_SIZE
SAM_FILE_SIZE specifies the maximum SAM file size of ext process. If a SAM file exceeds this limit, it is moved to the backup directory and a new SAM file is created.
Parameter Format
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
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
Parameter type
Boolean
Default Value
Y
Class
Optional, Static
Range
SRC_DB_IP
SRC_DB_IP specifies the database IP Address.
Parameter Format
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
Parameter type
String
Default Value
""
Class
Mandatory, Static
Range
SRC_DB_PORT
SRC_DB_PORT specifies the database port.
Parameter Format
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
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
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
Parameter type
path
Default Value
"/"
Class
Optional, Static
Range
TDE_FOR_EXT
TDE_FOR_EXT specifiese whether use data decryption from source database
Parameter Format
Parameter type
Boolean
Default Value
N
Class
Optional, Static
Range
TDE_FOR_TABLESPACE
TDE_FOR_TABLESPACE specifiese whether use tablespace decryption from source database
Parameter Format
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
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
Parameter type
String
Default Value
"#encrypted"
Class
Optional, Static
Range
TX_FILTER_KEY
Parameter Format
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
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
Parameter type
Boolean
Default Value
N
Class
Optional, Static
Range
Last updated