CONN_MAX specifies the max number of connections between processes.
Parameter type
Integer
Default Value
LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.
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.
LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.
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.
LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.
cm probe timeout. when it's 0, indefinitely wait returns from cm. works only when USE_CM=Y
time interval to check whether child process is dead or not.
maximum fail count to calibrate process status internally. works only when USE_CM=Y
STARTUP 명령이나 자동 재기동으로 프로세스 기동을 요청한 뒤 해당 프로세스가 Agent 에 접속할 때까지 기다리는 최대 시간(초)을 설정한다. 이 시간 안에는 기동 중인 것으로 보고 재기동하지 않으며, 시간이 지나도 접속하지 않으면 남아 있는 프로세스를 강제 종료한 뒤 다시 기동한다. 누적 자동 재기동 횟수가 PRS_AGENT_PROC_MAX_FAIL_CNT 에 이르면 더 이상 재기동하지 않고 CM 에 Agent 중지를 요청한다. USE_CM=Y 일 때만 동작한다. 값은 PRS_AGENT_PROC_STATUS_REPLY_TIMEOUT 이하로 설정해야 하며, 이보다 크면 USE_CM 설정과 관계없이 Agent 가 파라미터 오류로 기동하지 않는다.
proc status check interval. works only when USE_CM=Y
read idle timeout seconds, for status reply. works only when USE_CM=Y
time interval to get statistic information. agent sends info req msg to ext and apply.
This parameter decides how often to insert resource data into repoDB.
USE_CM specifies whether use cm management for failover or not.
128
Class
Optional, Static
Range
32 - 1024
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
Integer
Default Value
5
Class
Parameter type
Integer
Default Value
10
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
Integer
Default Value
10
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
Boolean
Default Value
N
Class
Mandatory, Static
Range
Optional, Dynamic
Range
0 - 128G
Mandatory, Static
Range
Optional, Dynamic
Range
1M - 1G
Mandatory, Dynamic
Range
1 - 5
Optional, Static
Range
0 - PRS_AGENT_CM_PROBE_TIMEOUT < PRS_AGENT_PROC_STATUS_INTERVAL
Optional, Static
Range
1 - 3600
Optional, Static
Range
1 - 3600
Optional, Static
Range
5 - 256
Optional, Static
Range
2 - 256
Optional, Static
Range
6 - 256
Optional, Static
Range
1 - 3600
Optional, Static
Range
60 - 3600
Optional, Static
Range
An initialization parameter describes a ProSync configuration. It is provided with a text file and required to create a ProSync.
An initialization parameter file is a text file, with a filename in the form prosync.cfg needed when starting a ProSync. It can be edited using a document editor provided with the operating system. Once the initialization parameter file is modified, the ProSync must be restarted to apply the modification to the entire system.
However, not all initialization parameters require the restarting of the ProSync after their modification. Some parameters can be modified while being used by an instance. These parameters are applied only to the current instance, not the initialization parameter file.
This section explains the class attributes necessary for users to understand the information configured in the initialization parameter file.
Static/Dynamic
Static
A parameter that cannot be modified during system operation.
Dynamic
A parameter that can be modified during system operation.
Mandatory/Optional
Mandatory
A parameter required to start up a system. If these parameter are not defined in the initialization parameter file, the system cannot be booted.
Optional
A parameter that uses a default value if not defined in the initialization parameter.
CONN_MAX specifies the max number of connections between processes.
Parameter type
Integer
Default Value
DSN_DIR specifies the directory where the dsn file located. It must be specified as an absolute path.
DSN_FILE specifies name of dsn file.
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.
LLOB_FLASHBACK_ERROR specifies how to handle an error during a flashback query on a LONG/LOB column. If set to 'SKIP', the column is not synchronized; if set to 'CURRENT', the query is re-executed for the latest value.
Number of llob thread cnt when starting prosync.
LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.
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.
LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.
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.
LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.
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.
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.
connection timeout from process to agent. if a process cannot connect to agent while this timeout, kill itself
PRS_PWD specifies the database user password. If the password is encrypted, append the string '#encrypted'.
PRS_USER specifies the database user.
SRC_DB_IP specifies the database IP Address.
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.
SRC_DB_PORT specifies the database port.
SRC_DB_TYPE specifies the type of the source database to extract data from. Options are TIBERO, UPDB, KDB, or ORACLE.
SRC_PRIMARY_DB_NAME specifies the writable primary database alias used when ENABLE_TSC_STANDBY is enabled.
USE_LOGMNR specifies whether to use oracle logminer or to use oracle log reader, when analyzing redo logs.
128
Class
Optional, Static
Range
32 - 1024
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
String
Default Value
"CURRENT"
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
180
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"localhost"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"7600"
Class
Parameter type
String
Default Value
"TIBERO"
Class
Parameter type
String
Default Value
""
Class
Parameter type
Boolean
Default Value
N
Class
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Optional, Static
Range
1 - 4
Mandatory, Static
Range
Optional, Dynamic
Range
0 - 128G
Mandatory, Static
Range
Optional, Dynamic
Range
1M - 1G
Mandatory, Dynamic
Range
1 - 5
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
0 - 86400
Mandatory, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Optional, Static
Range
Number of retries to apply dml before leaving a log to report file.
Parameter type
Integer
Default Value
APPLY_NUM specifies the number of the target database. It must be greater than or equal to 1. In 1:N topology, each apply process must be assigned a different number in sequential order (1, 2, 3...).
APPLY_REPORT_BACKUP_DIR specifies the directory where the report files of apply process are backed up. It must be specified as an absolute path.
APPLY_REPORT_BACKUP_SIZE specifies the maximum size of report backup files of apply process. If this limit is exceeded, the oldest report files in the directory are deleted.
APPLY_REPORT_DIR specifies the directory where the report files are stored. It must be specified as an absolute path.
APPLY_REPORT_FILE_SIZE specifies the maximum report file size of apply process. If a report file exceeds this limit, it is moved to the backup directory and a new report file is created.
APPLY_TO_DB specifies whether the replay thread of the apply process actually executes the received changes on the target database. If set to 'N', neither the DML statements nor the DDL statements are executed on the target database, so this parameter is normally set to 'N' only together with APPLY_TO_SAM in order to record the statements into the SAM file without applying them.
Determines whether to leave a log on the report file or not.
This parameter sets whether to log the statements that the APPLY process applies to the database into the SAM file. (Y/N)
This parameter determines the maximum value of LCR data to be stored for array bind.
Apply control thread stops receiving msg from ext when total chunk size of un-constructed exceeded.
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.
CONN_MAX specifies the max number of connections between processes.
DDL specifies DDL filtering options. For more information, refer to ProSync DDL RULE in Administrator's Guide.
DISCARD_BACKUP_DIR specifies the directory where the discard files of apply process are backed up. It must be specified as an absolute path.
DISCARD_BACKUP_SIZE specifies the maximum size of discard backup files of apply process. If this limit is exceeded, the oldest discard files in the directory are deleted.
DISCARD_CAST_ERR determines whether to skip a DML statement that fails because ProSync cannot convert a source value to the target data type (for example, an unsupported time zone region). A skipped statement is not applied to the target database. It works regardless of DISCARD_YN, and the skipped statement is recorded in the discard file only when DISCARD_FILE_YN is set to 'Y'.
DISCARD_DDL_BACKUP_DIR specifies the directory where the discard files of apply process are backed up. It must be specified as an absolute path.
DISCARD_DDL_BACKUP_SIZE specifies the maximum size of discard backup files of apply process. If this limit is exceeded, the oldest discard files in the directory are deleted.
DISCARD_DDL_FILE_DIR specifies the directory where the discard files are stored. It must be specified as an absolute path.
DISCARD_DDL_FILE_SIZE specifies the maximum discard file size of apply process. If a discard file exceeds this limit, it is moved to the backup directory and a new discard file is created.
Y to make a file of error DDL that discarded during sync.
Toggle Discard DDL feature.
List error codes to ignore during sync. (max 256 codes)
DISCARD_FILE_DIR specifies the directory where the discard files are stored. It must be specified as an absolute path.
DISCARD_FILE_SIZE specifies the maximum discard file size of apply process. If a discard file exceeds this limit, it is moved to the backup directory and a new discard file is created.
Y to make a file of error codes that discarded during sync.
Toggle Discard feature.
DML_WAIT_TIMEOUT specifies the timeout (in seconds) for a statement executed on the target database. When the timeout expires the statement is cancelled, the connection to the target database is dropped, and the transaction is retried from the beginning. If it is set to 0, no timeout is set and the apply process waits indefinitely for the statement to finish. It applies to a Tibero target (DML execution only) and to a target accessed through ODBC such as PostgreSQL; it has no effect on an Oracle target because the OCI path does not set a statement timeout.
DSN_DIR specifies the directory where the dsn file located. It must be specified as an absolute path.
DSN_FILE specifies name of dsn file.
Apply 프로세스가 테이블 메타데이터(DD)의 추가·변경·삭제를 반영할 때 그 테이블의 Source 객체 ID(파티션 포함)를 연결된 모든 Extract 프로세스에 전달할지 여부를 설정한다. Extract 는 ENABLE_SYNC_TABLE_FILTER=Y 이고 Source DB 가 Oracle 이면서 USE_LOGMNR=N 일 때만 이 정보로 추출 대상 테이블 목록을 갱신하며, 그 외 구성에서는 설정해도 효과가 없다.
GROUP_NUM specifies the number of replay groups in multi-grouping mode.
The number of retries in a fault situation absence of primary key. Default value means infinite retries.
This parameter decides how often to update the target meta tables PRS_COMMITTED_TX_LIST and PRS_LCT. The unit is in seconds.
a leading prosync user in history topology
LLOB_APPLY_MODE specifies how a LONG/LOB column is synchronized. If set to 'SKIP', the column is not synchronized; if set to 'SYNC', the column is synchronized during DML execution.
LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.
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.
LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.
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.
LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.
MAP specifies the mapping information of the target table for synchronization. For more information, refer to ProSync Administrator's Guide.
MAP_SKIP_UPD_WHERE specifies where clause or the set clause when check skipping update dml. If set 'Y', prosync skip using where clause and otherwise, prosync skip using set clause.
Apply control threads resumes the receiving of msg from ext when total size of un-committed but fully constructed tx is smaller than this parameter.
Apply control thread stops receiving msg from ext when total size of un-committed but fully constructed tx is larger than this parameter.
BLOCK EXT STMT COUNT
RESUME EXT STMT COUNT
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.
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.
connection timeout from process to agent. if a process cannot connect to agent while this timeout, kill itself
PRS_PWD specifies the database user password. If the password is encrypted, append the string '#encrypted'.
PRS_USER specifies the database user.
Parallel Replay object id mode
records history when DML occurred.
Number of replay thread cnt when starting prosync.
This parameter decides how often to insert resource data into repoDB.
RETENTION_FILE_CLEANUP_INTERVAL specifies how often retention-based file cleanup is checked.
SAM_BACKUP_DIR specifies the directory where the SAM files are backed up. It must be specified as an absolute path.
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.
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 specifies the directory where the sam files are stored. It must be specified as an absolute path.
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.
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.
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.
SRC_DB_CHARSET specifies the character set of the source database.
SRC_DB_CNT specifies the number of source database instances, that is the number of extract processes, from which the apply process receives changes. The value must be identical to the number of extract processes defined for the topology in prs_instance.map, otherwise the apply process fails to start. A value greater than 1 means that the source is a cluster (TAC or RAC), in which case the apply process keeps a transaction hash and a log position per source node and merges the transactions arriving from the nodes in commit order. The value cannot exceed 20 because the apply process reserves a fixed number of per-source-node slots internally.
SRC_DB_NCHARSET specifies the national character set of the source database.
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.
TAR_DB_NAME specifies the name(Alias) of the target 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.
TAR_DB_TYPE specifies the type of the target database to apply data to. Options are TIBERO, UPDB, KDB, or ORACLE.
TDE_FOR_APPLY specifies whether use data decryption from source database
TDE_WALLET_FILE specifies the wallet file name of source db including absolute path
TDE_WALLET_PWD specifies the password of wallet file for tde
TX_HASH_FILE_CNT determines how many tx_hash_files to keep in PRS_TX_DIR
TX_HASH_FILE_DIR specifies the directory where the ProSync tx hashes are saved. It must be specified as an absolute path.
TX_HASH_FILE_MODE determines how to control tx_hash_files
TX_HASH_FILE_RETENTION_DAY determines retention period(days) for tx_hash_files
TX_HASH_FILE_TOTAL_SIZE determines max size of every tx_hash_files to keep in PRS_TX_DIR
TX_HASH_SIZE specifies the maximum memory size that the apply process can use for transaction data. If this size is not sufficient, there will be frequent swapping between memory and disk which will affect performance.
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.
UPDATE_LCT_WHEN_ADD_HIST determines whether to execute UPDATE_LCT or not when a replay thread inserts ADD_CONST_HIST information.
This parameter determines whether the replay thread use the array bind or not.
USE_LOGMNR specifies whether to use oracle logminer or to use oracle log reader, when analyzing redo logs.
use batch mode for insert only
USE_PK_FOR_WHERE specifies whether use only PK columns when replay thread generate and bind the where clause of dml(update and delete) or not.
(Deprecated) VERIFY_TIMEOUT is no longer used. It used to specify the timeout (in seconds) after which the apply process released a table that it had blocked or frozen for a verify request. The verify feature was separated into a standalone tool and its code was removed, so this parameter no longer has any effect. It is kept only so that existing configuration files that still contain it remain loadable.
20
Class
Optional, Static
Range
0 - 100000
Parameter type
Integer
Default Value
1
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
10485760
Class
Parameter type
Integer
Default Value
1073741824
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
128
Class
Parameter type
desc
Default Value
"(INCLUDE DEFAULT, TYPE=('ALTER TABLE','TRUNCATE TABLE'))"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
desc
Default Value
"()"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"SYNC"
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
desc
Default Value
"(TABLE DEFAULT)"
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Integer
Default Value
1073741824
Class
Parameter type
Integer
Default Value
2147483648
Class
Parameter type
Integer
Default Value
1000
Class
Parameter type
Integer
Default Value
100
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
180
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"OBJ"
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
4
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
Integer
Default Value
3600
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
17179869184
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
String
Default Value
"MSWIN949"
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
String
Default Value
"UTF16"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"TIBERO"
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
String
Default Value
"/"
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
"CNT"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
2147483648
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
1800
Class
Mandatory, Static
Range
1 - 1024
Optional, Static
Range
Optional, Dynamic
Range
0 - 128G
Optional, Static
Range
Optional, Dynamic
Range
1M - 1G
Optional, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
Optional, Static
Range
1024 - UINT64_MAX
Optional, Static
Range
1 - UINT64_MAX
Optional, Static
Range
Optional, Static
Range
32 - 1024
Mandatory, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
0 - 128G
Optional, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
0 - 128G
Optional, Static
Range
Optional, Dynamic
Range
1M - 1G
Optional, Dynamic
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
1M - 1G
Optional, Dynamic
Range
Optional, Static
Range
Optional, Static
Range
0 - 1048576
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
1 - 20
Optional, Static
Range
0 - UINT16_MAX
Optional, Static
Range
1 - INT32_MAX
Optional, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Optional, Dynamic
Range
0 - 128G
Mandatory, Static
Range
Optional, Dynamic
Range
1M - 1G
Mandatory, Dynamic
Range
1 - 5
Mandatory, Dynamic
Range
Optional, Static
Range
Optional, Static
Range
1 - UINT64_MAX & MEMORY_CTRL_RESUME_SIZE < MEMORY_CTRL_STOP_SIZE
Optional, Static
Range
1 - UINT64_MAX & MEMORY_CTRL_RESUME_SIZE < MEMORY_CTRL_STOP_SIZE
Optional, Static
Range
1 - UINT32_MAX & MERGE_RESUME_CNT < MERGE_BLOCK_CNT
Optional, Static
Range
1 - UINT32_MAX & MERGE_RESUME_CNT < MERGE_BLOCK_CNT
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
0 - 86400
Mandatory, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
1 - 20
Optional, Static
Range
60 - 3600
Optional, Dynamic
Range
60 - 86400
Optional, Static
Range
Optional, Dynamic
Range
0 - 128G
Optional, Dynamic
Range
Optional, Static
Range
Optional, Dynamic
Range
1M - 16G
Optional, Dynamic
Range
Optional, Static
Range
Optional, Static
Range
"ASCII", "US7ASCII", "EUCKR", "KO16KSC5601", "MSWIN949","KO16MSWIN949", "UTF8", "AL32UTF8", "UTF16", "AL16UTF16", "SJIS", "JA16SJIS", "JA16SJISTILDE", "JA16EUC", "JA16EUCTILDE", "GBK", "ZHS16GBK", "VN8VN3", "WE8MSWIN1252", "ZHT16HKSCS", "CL8MSWIN1251", "WE8ISO8859P1", "EE8ISO8859P2", "WE8ISO8859P9", "WE8ISO8859P15", "CL8KOI8R", "CL8ISO8859P5", "RU8PC866", "TH8TISASCII", "EL8MSWIN1253", "EL8ISO8859P7", "AR8MSWIN1256", "AR8ISO8859P6"
Mandatory, Static
Range
1 - 20
Optional, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
0 - 32
Optional, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
0 - 36500
Optional, Static
Range
0 - 1000G
Optional, Dynamic
Range
1M - 32G
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
1 - 3600
ARCHIVE_LOG_DIR specifies the directory where the archive logs are stored. It must be specified as an absolute path.
Parameter type
path
Default Value
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#.
ASM_DB_NAME specifies the Oracle ASM instance alias used by oracle log reader. Required for ASM redo file(+...) access.
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).
ASM_PWD specifies the Oracle ASM user password used by oracle log reader. Required for ASM redo file(+...) access.
ASM_USER specifies the Oracle ASM user used by oracle log reader. Required for ASM redo file(+...) access.
BINLOG_INIT_POSITION specifies the starting position of mysql binlog.
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.
CONNECT_TO_APPLY_CHECK_INTERVAL specifies the interval at which the connection is attempted when the connection between ext and apply is lost.
CONN_MAX specifies the max number of connections between processes.
DICT_FILE_DIR specifies the directory where user wants to make dictfile while using oracle logminer version.
DSN_DIR specifies the directory where the dsn file located. It must be specified as an absolute path.
DSN_FILE specifies name of dsn file.
DUMMY_LOG_SEND_INTERVAL_COMMIT_TSN specifies the interval of sending dummy tx to prevent synchronization delay in TAC and RAC.
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.
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.
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.
determines whether to send only LCR of synchronization table to the apply process
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.
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.
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.
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...).
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'.
This parameter sets whether to log statements that are passed from the EXT process to the APPLY process into the SAM file. (Y/N)
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).
LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.
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.
LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.
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.
LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.
LOG_SWITCH_INTERVAL specifies interval of log switch.
LR_FILE_CNT determines how many lr files to keep in LR directory
LR_FILE_DELETE_MODE determines how to control lr files
LR_FILE_RETENTION_DAY determines retention period(days) for lr files
LR_FILE_TOTAL_SIZE determines max size of lr files to keep in LR directory
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.
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.
LR_LOG_DIR specifies the directory where the LR_LOG files are stored. It must be specified as an absolute path.
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.
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
LR_STOP_AT_CORRUPTED_LCR_ALL determines whether to stop when extracting all types of corrupted LCR
LR_STOP_AT_CORRUPTED_LCR_TARGET determines whether to stop when a corrupted LCR is extracted for the synchronization table
LR_TRACE_LVL specifies the logging level of the log reader. A higher log-level produces more detailed logs.
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]
LR_WARN_AT_CORRUPTED_LCR_ALL determines whether the log type for all types of corrupted LCR will be [W] or [F]
LR_WARN_AT_CORRUPTED_LCR_TARGET determines whether the log type of a corrupted LCR for the synchronization table will be [W] or [F]
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.
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.
MYSQL_BINLOG_PREFIX specifies the prefix of mysql binlog file name.
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'.
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.
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.
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.
PQ_REP_CONN_NAME specifies the replication connection name.
PREFETCH_SIZE specifies the number of rows to fetch for each oci fetch call. This parameter is used only in oracle logminer version.
connection timeout from process to agent. if a process cannot connect to agent while this timeout, kill itself
PRS_PWD specifies the database user password. If the password is encrypted, append the string '#encrypted'.
PRS_USER specifies the database user.
This parameter decides how often to insert resource data into repoDB.
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.
RETENTION_FILE_CLEANUP_INTERVAL specifies how often retention-based file cleanup is checked.
If a transaction references any object ID listed in this parameter, skip the entire transaction.
SAM_BACKUP_DIR specifies the directory where the SAM files are backed up. It must be specified as an absolute path.
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.
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 specifies the directory where the sam files are stored. It must be specified as an absolute path.
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.
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.
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.
SRC_DB_IP specifies the database IP Address.
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.
SRC_DB_PORT specifies the database port.
SRC_DB_TYPE specifies the type of the source database to extract data from. Options are TIBERO, UPDB, KDB, or ORACLE.
SRC_LOCAL_SID indicates specified instance name of the source database in RAC or TAC.
SRC_PRIMARY_DB_NAME specifies the writable primary database alias used when ENABLE_TSC_STANDBY is enabled.
SRC_PRIMARY_LOCAL_SID indicates the writable primary local instance name used when ENABLE_TSC_STANDBY is enabled.
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.
TDE_FOR_EXT specifies whether use data decryption from source database
TDE_FOR_TABLESPACE specifies whether use tablespace decryption from source database
Absolute library path with the library file name. It is used for linking with an HSM device.
pin value for HSM. It is used for linking with an HSM device.
Option to use the PKCS #11 wrapping key option for linking an HSM device.
Option to use Hardware Security Module (HSM) to save data encryption keys.
TDE_WALLET_FILE specifies the wallet file name of source db including absolute path
TDE_WALLET_PWD specifies the password of wallet file for tde
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.
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.
USE_LOGMNR specifies whether to use oracle logminer or to use oracle log reader, when analyzing redo logs.
""
Class
Optional, Static
Range
Parameter type
String
Default Value
"log-t%t-r%r-s%s.arc"
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
4
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
120
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
128
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
1000
Class
Parameter type
Integer
Default Value
5
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
String
Default Value
""
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
5
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
String
Default Value
"CNT"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
17179869184
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
2
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
String
Default Value
"bin"
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
Integer
Default Value
180
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
Integer
Default Value
3600
Class
Parameter type
desc
Default Value
"()"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
17179869184
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
String
Default Value
"localhost"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"7600"
Class
Parameter type
String
Default Value
"TIBERO"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
String
Default Value
"/"
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
desc
Default Value
"(FILTER DEFAULT)"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Boolean
Default Value
N
Class