_ENABLE_LOG_MINER=Y # ProSync가 사용하기 위한 추가적인 redo log를 남기기 위함
_SPAN_UNDO=N  # Tibero 6 FS07 이상에서 설정
_DDL_TRIGGER_ENABLE=Y # meta table정보관리를 위한 설정, 기본값은 Y이므로 설정하지 않아도 무방함

$ tbboot -t mount
$ tbsql sys/password
SQL> ALTER DATABASE ARCHIVELOG;
SQL> QUIT
$ tbdown
$ tbboot

$ sqlplus / as sysdba
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
SQL> ALTER DATABASE OPEN;

$ sqlplus / as sysdba
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=4 SCOPE=SPFILE;
SQL> ALTER SYSTEM SET OPEN_LINKS=4 SCOPE=SPFILE;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=1 SCOPE=SPFILE;

$ cat postgresql.conf | grep wal_level
wal_level = logical                     # minimal, replica, or logical

$TB_HOME/client/config/tbdsn.tbr

[SOURCE_SID]=(
    (INSTANCE=(HOST=SOURCE DB IP)
              (PORT=SOURCE DB PORT)
              (DB_NAME=SOURCE DB NAME))
)

[TARGET_SID]=(
    (INSTANCE=(HOST=TARGET DB IP)
              (PORT=TARGET DB PORT)
              (DB_NAME=TARGET DB NAME))
)

$ORACLE_HOME/network/admin/tnsnames.ora

[SOURCE_ALIAS]=
(DESCRIPTION=
    (ADDRESS=(PROTOCOL=TCP)
             (HOST=SOURCE DB IP)
             (PORT=SOURCE DB PORT))
    (CONNECT_DATA=(SERVER=DEDICATED)
                  (SERVICE_NAME=SOURCE DB SERVICE NAME))
)

[TARGET_ALIAS]=
(DESCRIPTION=
    (ADDRESS=(PROTOCOL=TCP)
             (HOST=TARGET DB IP)
             (PORT=TARGET DB PORT))
    (CONNECT_DATA=(SERVER=DEDICATED)
                  (SERVICE_NAME=TARGET DB SERVICE NAME))
)

~/pg_service.conf

[SOURCE_ALIAS]
host=SOURCE DB IP
port=SOURCE DB PORT
dbname=SOURCE DB NAME

[SOURCE_ALIAS]
host=TARGET DB IP
port=TARGET DB PORT
dbname=TARGET DB NAME

[EXAMPLE_FOR_REPLICATION]
host=SOURCE DB IP
port=SOURCE DB PORT
dbname=SOURCE DB NAME
replication=database

$ tbsql sys/password

SQL> CREATE USER TEST IDENTIFIED BY PASSWORD;
SQL> GRANT RESOURCE, CONNECT TO TEST;

SQL> CREATE TABLE TEST.T1 (C1 NUMBER PRIMARY KEY, C2 VARCHAR(10));
SQL> CREATE TABLE TEST.T2 (C1 NUMBER PRIMARY KEY, C2 VARCHAR(10));
SQL> CREATE TABLE TEST.T3 (C1 NUMBER PRIMARY KEY, C2 VARCHAR(10));

$PRS_HOME/install/prs_obj_group1.list

TEST.T1
TEST.T2
TEST.T3

TEST.%
TEST%.%

############################################
#
# ProSync Agent Configurations (Template)
#
############################################
# ID have to be unique in prs_instance.map.
# It will checked when execute prs_install_agent.sh.
# Because of multi-agent environment,
# HOSTNAME(defined in /etc/hosts) is not recommended, IP will be better.
# AGENT_HOST[%d]=192.xxx.xxx.xxx

# AGENT_ID is unique key in prosync
# All nodes have to use same AGENT_ID in same agent.

AGENT_CNT=1
AGENT_ID_0=agent
AGENT_HOST_0=localhost
AGENT_PORT_0=7600
#AGENT_CM_GROUP_0=0
#AGENT_CM_ID_0=0

#AGENT_ID_1=agent2
#AGENT_HOST_1=localhost
#AGENT_PORT_1=7601
#AGENT_CM_GROUP_1=1
#AGENT_CM_ID_1=1

AGENT_CNT=4

AGENT_ID_0=agent1
AGENT_HOST_0=172.17.0.1
AGENT_PORT_0=7600
AGENT_CM_GROUP_0=CM1
AGENT_CM_ID_0=0

AGENT_ID_1=agent2
AGENT_HOST_1=172.17.0.2
AGENT_PORT_1=7601
AGENT_CM_GROUP_1=CM1
AGENT_CM_ID_1=1

AGENT_ID_2=agent3
AGENT_HOST_2=172.17.0.3
AGENT_PORT_2=7602
AGENT_CM_GROUP_2=CM2
AGENT_CM_ID_2=0

AGENT_ID_3=agent4
AGENT_HOST_3=172.17.0.4
AGENT_PORT_3=7603
AGENT_CM_GROUP_3=CM2
AGENT_CM_ID_3=1

$ . prs_install_agent.sh [option] [config file]

$ cd $PRS_HOME/install
$ . prs_install_agent.sh

********************************************************************************
* Agent Install Step (1/4)
* Check System Parameters 
********************************************************************************
* Checking system type... 
Linux

* Checking PRS_HOME... 
PRS_HOME: /home/prosync/example

********************************************************************************
* Agent Install Step (2/4)
* Check install agent config file   [prs_install_agent.cfg]  
* Check Instance file               [prs_instance.map] 
********************************************************************************
* Checking configuration file... 
[/home/prosync/example/install/prs_install_agent.cfg] exists.

* Checking Agent configuration... 
parameter check for Agent[0] Started 
    AGENT_ID: agent1
    AGENT_HOST: 172.17.0.1
    AGENT_PORT: 7600
    AGENT_CM_GROUP: CM1
    AGENT_CM_ID: 0
parameter check for Agent[0] Done 
parameter check for Agent[1] Started 
    AGENT_ID: agent2
    AGENT_HOST: 172.17.0.2
    AGENT_PORT: 7601
    AGENT_CM_GROUP: CM1
    AGENT_CM_ID: 1
parameter check for Agent[1] Done 
parameter check for Agent[2] Started 
    AGENT_ID: agent3
    AGENT_HOST: 172.17.0.3
    AGENT_PORT: 7602
    AGENT_CM_GROUP: CM2
    AGENT_CM_ID: 0
parameter check for Agent[2] Done 
parameter check for Agent[3] Started 
    AGENT_ID: agent4
    AGENT_HOST: 172.17.0.4
    AGENT_PORT: 7603
    AGENT_CM_GROUP: CM2
    AGENT_CM_ID: 1
parameter check for Agent[3] Done 

* Checking prs_instance.map file... 
[/home/prosync/example/config/prs_instance.map] exists.

********************************************************************************
* Agent Install Step (3/4)
* Writing agent config file         [/home/prosync/example/install/prs_install_agent.cfg]  
* Writing Instance file             [/home/prosync/example/config/prs_instance.map] 
* Total Agent Cnt                   [4] 
********************************************************************************
* Writing all agents.. cnt: 4
* Writing Agent.. Index:           0
* Writing Agent.. AGENT_ID:        agent1
* Writing Agent.. AGENT_HOST:      172.17.0.1
* Writing Agent.. AGENT_PORT:      7600
* Writing Agent.. AGENT_CM_GROUP:  CM1
* Writing Agent.. AGENT_CM_ID:     0
* Writing Agent configuration... 
File already exists... 
[/home/prosync/example/config/prs_agent_agent1.cfg]
Want to Delete ? (Y/N)
n
Skip deleteing...

* Writing Agent information... 
Agent information already exist
Want to Replace ? (Y/N)
n
Skipped... 


* Writing Agent.. Index:           1
* Writing Agent.. AGENT_ID:        agent2
* Writing Agent.. AGENT_HOST:      172.17.0.2
* Writing Agent.. AGENT_PORT:      7601
* Writing Agent.. AGENT_CM_GROUP:  CM1
* Writing Agent.. AGENT_CM_ID:     1
* Writing Agent configuration... 
/home/prosync/example/config/prs_agent_agent2.cfg not found. Writing files...
Done.

* Writing Agent information... 


* Writing Agent.. Index:           2
* Writing Agent.. AGENT_ID:        agent3
* Writing Agent.. AGENT_HOST:      172.17.0.3
* Writing Agent.. AGENT_PORT:      7602
* Writing Agent.. AGENT_CM_GROUP:  CM2
* Writing Agent.. AGENT_CM_ID:     0
* Writing Agent configuration... 
/home/prosync/example/config/prs_agent_agent3.cfg not found. Writing files...
Done.

* Writing Agent information... 


* Writing Agent.. Index:           3
* Writing Agent.. AGENT_ID:        agent4
* Writing Agent.. AGENT_HOST:      172.17.0.4
* Writing Agent.. AGENT_PORT:      7603
* Writing Agent.. AGENT_CM_GROUP:  CM2
* Writing Agent.. AGENT_CM_ID:     1
* Writing Agent configuration... 
/home/prosync/example/config/prs_agent_agent4.cfg not found. Writing files...
Done.

* Writing Agent information... 


* Creating var directory...
   * Already Created.
********************************************************************************
* Agent Install Step (4/4)
* Creating files for CM
********************************************************************************
AGENT_CM_ID detected
generating prs_0.sh...
PRS_HOME=/home/prosync/example
AGENT_ID=agent1
prs_0.sh has created in $PRS_HOME/bin/
AGENT_CM_ID detected
generating prs_1.sh...
PRS_HOME=/home/prosync/example
AGENT_ID=agent2
prs_1.sh has created in $PRS_HOME/bin/
AGENT_CM_ID detected
generating prs_0.sh...
PRS_HOME=/home/prosync/example
AGENT_ID=agent3
prs_0.sh has created in $PRS_HOME/bin/
AGENT_CM_ID detected
generating prs_1.sh...
PRS_HOME=/home/prosync/example
AGENT_ID=agent4
prs_1.sh has created in $PRS_HOME/bin/
Agent installation Done.

$ cd $PRS_HOME/config
$ ls -al
total 51
drwxr-xr-x  3 users users 4096 Apr 16 15:42 .
drwxr-xr-x 15 users users 4096 Apr 14 15:08 ..
-rw-r--r--  1 users users  367 Feb 27 19:22 prs_agent_agent1.cfg
-rw-r--r--  1 users users  367 Apr 16 15:32 prs_agent_agent2.cfg
-rw-r--r--  1 users users  367 Apr 16 15:32 prs_agent_agent3.cfg
-rw-r--r--  1 users users  367 Apr 16 15:32 prs_agent_agent4.cfg
-rw-r--r--  1 users users 1272 Apr 16 15:32 prs_instance.map
drwxr-xr-x  2 users users 4096 Apr 14 15:08 templates
-rw-r--r--  1 users users    5 Feb 27 13:06 variant

#--------------------------------------------------------
# ProSync Instances Map (prs_instance.map)
#
# Generated by Dummy Time: 04-16T14:22:21.920319
#

AGENT=(ID=agent1)(HOST=172.17.0.1)(PORT=7600)(CM_GROUP=CM1)(CM_ID=0)

#--------------------------------------------------------
# Appended by prs_install_agent.sh at Wed Apr 16 03:32:37 PM KST 2025
#

AGENT=(ID=agent2)(HOST=172.17.0.2)(PORT=7601)(CM_GROUP=CM1)(CM_ID=1)

#--------------------------------------------------------
# Appended by prs_install_agent.sh at Wed Apr 16 03:32:37 PM KST 2025
#

AGENT=(ID=agent3)(HOST=172.17.0.3)(PORT=7602)(CM_GROUP=CM2)(CM_ID=0)

#--------------------------------------------------------
# Appended by prs_install_agent.sh at Wed Apr 16 03:32:37 PM KST 2025
#

AGENT=(ID=agent4)(HOST=172.17.0.4)(PORT=7603)(CM_GROUP=CM2)(CM_ID=1)
                                                                          

################################################################################
# ProSync Agent Configurations (Template)
################################################################################
LISTENER_PORT=7600
LOG_LEVEL=3
LOG_DIR=/home/prosync/example/var/agent/agent1/log
LOG_BACKUP_DIR=/home/prosync/example/var/agent/agentA/log/backup

#!/bin/sh

export TB_HOME=
export PRS_HOME=/home/prosync/example
AGENT_ID=agent1
TIMEOUT_CNT=7
source $PRS_HOME/bin/prs_cm.sh
export logdir=$PRS_HOME/var

echo "------------------------------------------------------------" >> $logdir/cmagent.log
echo "`date +%Y/%m/%d\ %H:%M:%S` cm agent Start (Agent Command $1)" >> $logdir/cmagent.log
case $1 in
START)
    echo "start $TIMEOUT_CNT $AGENT_ID" >> $logdir/cmagent.log
    start $TIMEOUT_CNT $AGENT_ID
    rc=$?
    ;;
PROBE)
    echo "probe $TIMEOUT_CNT $AGENT_ID" >> $logdir/cmagent.log
    probe $TIMEOUT_CNT $AGENT_ID
    rc=$?
    ;;
DOWN)
    echo "stop $TIMEOUT_CNT $AGENT_ID" >> $logdir/cmagent.log
    stop $TIMEOUT_CNT $AGENT_ID
    rc=$?
    ;;
KILL)
    echo "stop $TIMEOUT_CNT $AGENT_ID" >> $logdir/cmagent.log
    stop $TIMEOUT_CNT $AGENT_ID
    rc=$?
    ;;
NOTI)
    rc=0
    ;;
COMMIT)
    echo "send $TIMEOUT_CNT $AGENT_ID ${@:2}" >> $logdir/cmagent.log
    send $TIMEOUT_CNT $AGENT_ID ${@:2}
    rc=$?
    ;;

*)
    ;;
esac
echo "result :  $rc" >> $logdir/cmagent.log
echo "`date +%Y/%m/%d\ %H:%M:%S` cm agent End  (Agent Command $1)" >> $logdir/cmagent.log


exit $rc

CONNECT                   RESOURCE                     ALTER SYSTEM
CREATE TABLE              ALTER ANY TABLE              DROP ANY TABLE
FLASHBACK ANY TABLE       SELECT ANY TABLE             LOCK ANY TABLE
SELECT ON V$DATABASE      SELECT ON V$INSTANCE         SELECT ANY DICTIONARY
EXECUTE ON SYS.SEAF

CONNECT                       RESOURCE                        ALTER SYSTEM
CREATE TABLE                  ALTER ANY TABLE                 DROP ANY TABLE
FLASHBACK ANY TABLE           SELECT ANY TABLE                LOCK ANY TABLE
ADMINISTER DATABASE TRIGGER   SELECT ANY DICTIONARY           EXECUTE ON SYS.DBMS_AQADM
EXECUTE ON SYS.DBMS_AQ        EXECUTE ON SYS.DBMS_AQIN        AQ_ADMINISTRATOR_ROLE
SELECT ON SYS.USER$           EXECUTE ON SYS.DBMS_AQADM_SYS   
SELECT ANY TRANSACTION  

# (12c 이상)
LOGMINING                     CREATE ANY DIRECTORY   
READ, WRITE ON DIRECTORY PRS_DICT_$INSTANCE_ID

# 권한외 필요한사전 설정
ALTER USER PRS_USER QUOTA UNLIMITED ON PRS_TS_NAME
CREATE OR REPLACE DIRECTORY PRS_DICT AS DICT_FILE_DIR

CONNECT              RESOURCE              CREATE SESSION
INSERT ANY TABLE     CREATE ANY TABLE      CREATE ANY SEQUENCE
CREATE ANY INDEX     CREATE ANY TRIGGER    CREATE ANY SYNONYM
CREATE ANY VIEW      CREATE ANY PROCEDURE  UPDATE ANY TABLE
DELETE ANY TABLE     SELECT ANY TABLE      SELECT ANY DICTIONARY
ALTER SESSION        ALTER ANY TABLE       ALTER ANY INDEX
ALTER ANY TRIGGER    ALTER ANY SEQUENCE    ALTER ANY PROCEDURE
DROP ANY TABLE       DROP ANY INDEX        DROP ANY TRIGGER
DROP ANY SEQUENCE    DROP ANY VIEW         DROP ANY PROCEDURE
DROP ANY SYNONYM     COMMENT ANY TABLE

DBA

SUPERUSER

CONNECT                          CREATE USER                       DROP USER
CREATE TABLESPACE                DROP TABLESPACE                   ALTER DATABASE
ALTER SYSTEM                     ADMINISTER DATABASE TRIGGER       ALTER ANY TABLE
ALTER ANY TRIGGER                EXECUTE ANY PROCEDURE             DROP ANY PROCEDURE
DROP ANY TABLE                   DROP ANY TRIGGER                  DROP ANY SEQUENCE
GRANT ANY ROLE                   GRANT ANY PRIVILEGE               SELECT ANY TABLE
INSERT ANY TABLE                 UPDATE ANY TABLE                  SELECT ON V$LOG
SELECT ON V$PARAMETERS
SELECT ON V$DATABASE WITH GRANT OPTION  
SELECT ON V$INSTANCE WITH GRANT OPTION   
SELECT ON SYS._DD_OBJ WITH GRANT OPTION  
SELECT ON SYS._DD_USER WITH GRANT OPTION 
SELECT ON SYS._DD_IDX WITH GRANT OPTION
SELECT ON SYS._DD_IDXPART WITH GRANT OPTION 
SELECT ON SYS._DD_TBL WITH GRANT OPTION 
SELECT ON SYS._DD_TBLPART WITH GRANT OPTION
SELECT ON SYS._DD_TBLSUBPART WITH GRANT OPTION 
SELECT ON SYS._DD_COL WITH GRANT OPTION 
SELECT ON SYS._DD_ICOL WITH GRANT OPTION
EXECUTE ON SYS.SEAF WITH GRANT OPTION

CONNECT                     CREATE SESSION                ALTER SESSION
CREATE USER                 DROP USER                     CREATE TABLESPACE
DROP TABLESPACE             ALTER DATABASE                ALTER SYSTEM
ADMINISTER DATABASE TRIGGER ALTER ANY TABLE               ALTER ANY TRIGGER
EXECUTE ANY PROCEDURE       DROP ANY PROCEDURE            DROP ANY TABLE
DROP ANY TRIGGER            DROP ANY SEQUENCE             GRANT ANY ROLE
GRANT ANY PRIVILEGE         SELECT ANY TABLE              INSERT ANY TABLE
UPDATE ANY TABLE            ALTER USER                    SELECT ON SYS.V_$PARAMETER
SELECT ON SYS.V_$DATABASE   SELECT ON SYS.V_$INSTANCE     SELECT ON SYS.V_$LOG
SELECT ON SYS.USER$ WITH GRANT OPTION
EXECUTE ON SYS.DBMS_AQ WITH GRANT OPTION
EXECUTE ON SYS.DBMS_AQIN WITH GRANT OPTION
EXECUTE ON SYS.DBMS_AQADM WITH GRANT OPTION
EXECUTE ON SYS.DBMS_AQADM_SYS WITH GRANT OPTION
EXECUTE ON SYS.DBMS_LOGMNR WITH GRANT OPTION
EXECUTE ON SYS.DBMS_LOGMNR_D WITH GRANT OPTION
EXECUTE ON SYS.DBMS_LOGMNR_INTERNAL WITH GRANT OPTION
EXECUTE DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY', 'PRS_INSTALL_USER')
-- PDB의 경우 common user에 대해 수행 필요
SET CONTAINER

SUPERUSER

CONNECT                  CREATE USER               DROP USER
CREATE TABLESPACE        DROP TABLESPACE           EXECUTE ANY PROCEDURE
DROP ANY PROCEDURE       DROP ANY TABLE            DROP ANY SEQUENCE
GRANT ANY ROLE           GRANT ANY PRIVILEGE       SELECT ANY TABLE
INSERT ANY TABLE         SELECT ANY SEQUENCE       SELECT ON V$PARAMETERS

CONNECT                  CREATE USER               DROP USER
CREATE TABLESPACE        DROP TABLESPACE           EXECUTE ANY PROCEDURE
DROP ANY PROCEDURE       DROP ANY TABLE            DROP ANY SEQUENCE
GRANT ANY ROLE           GRANT ANY PRIVILEGE       SELECT ANY TABLE
INSERT ANY TABLE         SELECT ANY SEQUENCE       SELECT ON SYS.V_$PARAMETER

SUPERUSER

############################################
#
# ProSync Installation Parameters
#
############################################

# (Mandatory)
INSTANCE_ID=
PRS_USER=prosync
PRS_PWD=

# (Optional)
#PRS_TS_NAME=
#PRS_TS_FILE=
#PRS_TS_SIZE=
#PRS_SKIP_USER_CREATE=N
#PRS_TARGET_MIN_PRIVILEGE=N
#PRS_LOG_DIR=
#LOG_BACKUP_DIR=
#CREATE_DSN_FILE=N
#DSN_DIR=
#DSN_FILE=#need DSN_DIR

############################################
#
# ProSync Processes Informations for Instance Map
#
############################################
### (Optional)
AGENT_LIST_DELIMITER=,

### (Mandatory)
# Ext process
## Ext cnt must be the same as SRC_DB_CNT
EXT_CNT=
EXT_AGENT_ID_LIST_0=agent1
#EXT_AGENT_ID_LIST_1=agent1,agent2

# Apply process
APPLY_PORT=7620
APPLY_AGENT_ID_LIST=agent1

# Llob process
LLOB_PORT=7630
LLOB_AGENT_ID_LIST=agent1

############################################
#
# Source database informations
#
############################################

# (Mandatory)
SRC_DB_TYPE=TIBERO
SRC_DB_NAME=
SRC_INSTALL_USER=
SRC_INSTALL_PWD=

# (Optional)
#AUTO_ADD_SUPP_LOG=Y
#SRC_SKIP_TS_CREATE=N

# (Number Of Database Instances)
#SRC_DB_CNT=1

# (Dsn)
#SRC_DB_REAL_NAME=
#SRC_DB_IP_0=
#SRC_DB_PORT_0=
#SRC_DB_IP_1=
#SRC_DB_PORT_1=

# (for Cluster, only Extract Needed)
#SRC_DB_ALIAS_0=
#SRC_DB_ALIAS_1=

# (for ORACLE DB Only) 
#SUPP_LOG_LVL_ALL=N
#AUTO_SYNC_ON_CREATE=N 

# (for Oracle Logminer only)
# Oracle 11g or less, use utl_file_dir instead of DICT_FILE_DIR
#USE_LOGMNR=Y
#DICT_FILE_DIR=

# (for MySQL only)
#PRS_EXT_IP=

############################################
#
# Target database informations
#
############################################

# (Mandatory)
TAR_DB_TYPE=TIBERO
TAR_DB_NAME=
TAR_INSTALL_USER=
TAR_INSTALL_PWD=

# (Optional)
#TAR_SKIP_TS_CREATE=N

# (Number Of Database Instances)
#TAR_DB_CNT=1

# (Dsn)
#TAR_DB_REAL_NAME=
#TAR_DB_IP_0=
#TAR_DB_PORT_0=
#TAR_DB_IP_1=
#TAR_DB_PORT_1=

# (for MySQL only)
#PRS_APPLY_IP=

# (for multi thread)
#GROUP_NUM=1

# (for TDE(transparent data encryption) synchronization)
#USE_TDE=N

############################################
#
# ProSync Installation Parameters
#
############################################

# (Mandatory)
INSTANCE_ID=instance
PRS_USER=prosync_user
PRS_PWD=prosync_user_password

# (Optional)
#PRS_TS_NAME=
#PRS_TS_FILE=
#PRS_TS_SIZE=
#PRS_SKIP_USER_CREATE=N
#PRS_TARGET_MIN_PRIVILEGE=N
#PRS_LOG_DIR=
#LOG_BACKUP_DIR=
#CREATE_DSN_FILE=N
#DSN_DIR=
#DSN_FILE=#need DSN_DIR

############################################
#
# ProSync Processes Informations for Instance Map
#
############################################
### (Optional)
AGENT_LIST_DELIMITER=,

### (Mandatory)
# Ext process
## Ext cnt must be the same as SRC_DB_CNT
EXT_CNT=1
EXT_AGENT_ID_LIST_0=agent1
#EXT_AGENT_ID_LIST_1=agent1,agent2

# Apply process
APPLY_PORT=7620
APPLY_AGENT_ID_LIST=agent1

# Llob process
LLOB_PORT=7630
LLOB_AGENT_ID_LIST=agent1

############################################
#
# Source database informations
#
############################################

# (Mandatory)
SRC_DB_TYPE=TIBERO
SRC_DB_NAME=src_tibero
SRC_INSTALL_USER=sys
SRC_INSTALL_PWD=tibero

# (Optional)
#AUTO_ADD_SUPP_LOG=Y
#SRC_SKIP_TS_CREATE=N
#AUTO_SYNC_ON_CREATE=N

# (Number Of Database Instances)
#SRC_DB_CNT=1

# (Dsn)
#SRC_DB_REAL_NAME=
#SRC_DB_IP_0=
#SRC_DB_PORT_0=
#SRC_DB_IP_1=
#SRC_DB_PORT_1=

# (for Cluster, only Extract Needed)
#SRC_DB_ALIAS_0=
#SRC_DB_ALIAS_1=

# (for ORACLE DB Only) 
#SUPP_LOG_LVL_ALL=N
#AUTO_SYNC_ON_CREATE=N 

# (for Oracle Logminer only)
# Oracle 11g or less, use utl_file_dir instead of DICT_FILE_DIR
#USE_LOGMNR=Y
#DICT_FILE_DIR=

# (for MySQL only)
#PRS_EXT_IP=

############################################
#
# Target database informations
#
############################################

# (Mandatory)
TAR_DB_TYPE=TIBERO
TAR_DB_NAME=tar_tibero
TAR_INSTALL_USER=sys
TAR_INSTALL_PWD=tibero

# (Optional)
#TAR_SKIP_TS_CREATE=N

# (Number Of Database Instances)
#TAR_DB_CNT=1

# (Dsn)
#TAR_DB_REAL_NAME=
#TAR_DB_IP_0=
#TAR_DB_PORT_0=
#TAR_DB_IP_1=
#TAR_DB_PORT_1=

# (for MySQL only)
#PRS_APPLY_IP=

# (for multi thread)
#GROUP_NUM=1

# (for TDE(transparent data encryption) synchronization)
#USE_TDE=N

$ . prs_install.sh [option] [config file] [list file]

$ cd $PRS_HOME/install
$ . prs_install.sh

*******************************************************************************
* Check System Parameters (1/5)
********************************************************************************
Checking system type... Linux
Checking PRS_HOME... /home/prosync/example
Checking TB_HOME... /home/tibero/tibero7
Checking ORACLE_HOME... not found
Checking psql ... available
Checking psql service ...not found

********************************************************************************
* Check Installation Parameters (2/5)
********************************************************************************
Checking configuration file... ok
Checking prs_instance.map file... ok
Checking Instance Id from prs_instance.map...
* instance information for instance was not found. It will be written in this script...
ok
Checking proecsses infos...
* Checking Ext processes Informations... EXT_CNT: 1
* Delimiter: [,]
   * Ext[0] process's Agent Id List 
       * Agent ID[agent1]
       * [agent1] found.
* Checking Apply process Informations...
* Checking Apply Port..
   * APPLY_PORT=[7620]
* Checking Apply process's Agent Id List..
       * Agent ID[agent1]
       * [agent1] found.
* Checking Llob process Informations...
* Checking Llob Port..
   * LLOB_PORT=[7630]
* Checking Llob process's Agent Id List..
       * Agent ID[agent1]
       * [agent1] found.

Checking INSTANCE_ID... instance
Checking PRS_USER... prosync_user
Checking PRS_TS_NAME... instance_ts
Checking PRS_TS_FILE... instance_ts.dtf
Checking PRS_TS_SIZE... 1G
Checking PRS_EXT_IP... %
Checking PRS_APPLY_IP... %
Checking SRC_DB_CNT... 1
Checking SRC_DB_TYPE... TIBERO
Checking SRC_INSTALL_USER... sys
Checking SRC_DB_NAME... src_tibero
Checking source connection(1/2)... ok
Checking source connection(2/2)... ok
_list_create: Variable TAR_DB_IP_0 is undefined or empty.
_list_create: Variable TAR_DB_PORT_0 is undefined or empty.
Checking TAR_DB_TYPE... TIBERO
Checking TAR_INSTALL_USER... sys
Checking TAR_DB_NAME... tar_tibero
Checking target connection [tar_tibero](1/2)... ok
Checking target connection [tar_tibero](2/2)... ok

********************************************************************************
* Install to Source Database (3/5)
********************************************************************************
Checking archived log mode... ok
Usage: _list_get <list> <index>
Checking log mining parameters [src_tibero]... ok
Usage: _list_get <list> <index>
Get Archive log directory [src_tibero]... ok
Get Archive log format [src_tibero]... ok
Dropping ProSync objects... ok
Dropping ProSync tablespace... DROP TABLESPACE instance_ts INCLUDING CONTENTS AND DATAFILES;

done

ok
Creating ProSync tablespace... ok
Dropping ProSync user... ok
Creating ProSync user... ok
Granting privileges... ok
Granting privileges for trigger... ok
Creating ProSync internal tables... ok
Creating ProSync internal package... ok
Creating ProSync internal trigger... ok
Prosync user prosync_user to uppercase PROSYNC_USER... ok
Checking source object file(group num : 1)... ok
Building source object for TEST.%... ok
Building source object for TEST%.%... ok
Adding table supplemental log... 6, and one for prosync
  "PROSYNC_USER"."PRS_DUMMY_TBL" : Supplemental logging set
  "TEST"."T1" : supplemental log already exists, continue.
  "TEST"."T2" : supplemental log already exists, continue.
  "TEST"."T3" : supplemental log already exists, continue.
  "TEST"."T4" : supplemental log already exists, continue.
  "TEST"."T5" : supplemental log already exists, continue.
  prosync_user.PRS_DUMMY_TBL : supplemental log already exists, continue.
Counting total source objects... 6
Generating initial DDL history... ok
Checking initial DDL history... ok
Insert default value in PRS_DUMMY_TBL...ok
Querying NLS_CHARACTERSET... UTF8
Querying NLS_NCHAR_CHARACTERSET... UTF16
Switching logfile... ok
Usage: _list_get <list> <index>
Querying current log sequence [src_tibero]... 188
Querying current snapshot#... 4306566

********************************************************************************
* Install to Target Database (4/5)
********************************************************************************
Dropping ProSync objects... ok
Dropping ProSync tablespace... DROP TABLESPACE instance_ts INCLUDING CONTENTS AND DATAFILES;

done

ok
Creating ProSync tablespace... ok
Dropping ProSync user... ok
Creating ProSync user... ok
Granting privileges... ok
Creating ProSync internal tables... ok
Usage: _list_get <list> <index>
Generating initial construct history [src_tibero (group 1)]... ok
Generating initial commit history... ok

********************************************************************************
* Generate Configuration Parameters (5/5)
********************************************************************************
Generating Wallet... ok
Usage: _list_get <list> <index>
Generating Extract [src_tibero] configuration...  ok
Generating Apply [tar_tibero] configuration...  ok
Generating LONG/LOB configuration...  ok
Generating instance map to prs_instance.map ...


********************************************************************************
* ProSync is installed successfully on Thu, 17 Apr 2025 14:38:38 +0900.
*
*   PRS_HOME     = /home/prosync/example
*   Binary Path  = /home/prosync/example/bin
*   ProSync User = prosync_user
*
*   Archived Log Path     = /home/tibero/tibero7/database/tibero/archive/
*   Archived Log Format   = log-t%t-r%r-s%s.arc
*   Initial log sequence# = 188
*
*   Initial change# (TSN) = 4306566 
*
********************************************************************************

$ cd $PRS_HOME/config
$ ls -al
total 55
drwxr-xr-x  3 users users 4096 Apr 16 15:42 .
drwxr-xr-x 15 users users 4096 Apr 14 15:08 ..
-rw-r--r--  1 users users  547 Apr 17 14:38 instance_apply1.cfg
-rw-r--r--  1 users users  574 Apr 17 14:38 instance_ext1.cfg
-rw-r--r--  1 users users  470 Apr 17 14:38 instance_llob.cfg
-rw-r--r--  1 users users  352 Apr  3 16:19 prs_adm.cfg
-rw-r--r--  1 users users  367 Feb 27 19:22 prs_agent_agent1.cfg
-rw-r--r--  1 users users  367 Apr 16 15:32 prs_agent_agent2.cfg
-rw-r--r--  1 users users  367 Apr 16 15:32 prs_agent_agent3.cfg
-rw-r--r--  1 users users  367 Apr 16 15:32 prs_agent_agent4.cfg
-rw-r--r--  1 users users 1272 Apr 16 15:32 prs_instance.map
drwxr-xr-x  2 users users 4096 Apr 14 15:08 templates
-rw-r--r--  1 users users    5 Feb 27 13:06 variant

#--------------------------------------------------------
# Appended by prs_install.sh at Thu Apr 17 02:38:37 PM KST 2025
#

instance=(
    EXT1=(AGENT=agent1)(PROGRAM=prs_ext)
    APPLY1=(AGENT=agent1)(PORT=7620)(PROGRAM=prs_apply)
    LLOB=(AGENT=agent1)(PORT=7630)(PROGRAM=prs_llob)
)

################################################################################
#
# ProSync (Ext) Initialization Parameters
#
################################################################################

LOG_LEVEL=3

PRS_USER=prosync_user
PRS_PWD=#encrypted

EXTRACT_NUM=1

SRC_DB_TYPE=TIBERO
SRC_DB_NAME=src_tibero

ARCHIVE_LOG_DIR=/home/tibero/tibero7/database/tibero/archive/
ARCHIVE_LOG_FORMAT=log-t%t-r%r-s%s.arc

LOG_DIR=/home/prosync/example/var/instance/log
LOG_BACKUP_DIR=/home/prosync/example/var/instance/log/backup

################################################################################
#
# ProSync (Apply) Initialization Parameters
#
################################################################################

LOG_LEVEL=3

PRS_USER=prosync_user
PRS_PWD=#encrypted

APPLY_NUM=1

TAR_DB_TYPE=TIBERO
TAR_DB_NAME=tar_tibero

SRC_DB_CNT=1

MAP=(TABLE DEFAULT)

DDL=(INCLUDE DEFAULT, TYPE=('ALTER TABLE','TRUNCATE TABLE'))

LOG_DIR=/home/prosync/example/var/instance/log
LOG_BACKUP_DIR=/home/prosync/example/var/instance/log/backup

################################################################################
#
# ProSync (llob) Initialization Parameters
#
################################################################################

LOG_LEVEL=3

PRS_USER=prosync_user
PRS_PWD=#encrypted

SRC_DB_TYPE=TIBERO
SRC_DB_NAME=src_tibero

LLOB_FLASHBACK_ERROR=CURRENT

LOG_DIR=/home/prosync/example/var/instance/log
LOG_BACKUP_DIR=/home/prosync/example/var/instance/log/backup 

################################################################################
#
# ProSync (Admin) Initialization Parameters
#
################################################################################
LOG_LEVEL=3
LOG_DIR=/home/prosync/example/var/admin/log
LOG_BACKUP_DIR=/home/prosync/example/var/admin/log/backup

# tree 결과예제
.
├── admin
├── agent
└── instance

ProSync 4 - Admin Utility

TmaxData Corporation Copyright (c) 2024-. All rights reserved.

Admin>

Admin> start agent $agent_id

Admin> start $instance_id

Admin> status

ProSync 4 - Admin Utility

TmaxData Corporation Copyright (c) 2024-. All rights reserved.

status

prs_agent ID: agent1, HOST: 172.17.0.1, PORT: 7600, CM_GROUP: CM1, CM_ID: 1 is running
prs_agent ID: agent2, HOST: 172.17.0.2, PORT: 7601, CM_GROUP: CM1, CM_ID: 1 is stopped
prs_agent ID: agent3, HOST: 172.17.0.3, PORT: 7602, CM_GROUP: CM2, CM_ID: 0 is stopped
prs_agent ID: agent4, HOST: 172.17.0.4, PORT: 7603, CM_GROUP: CM2, CM_ID: 1 is stopped

Instance ID: [instance]
instance_ext1 is running (prs_agent ID : agent1, HOST: 172.17.0.1, PORT: 7600)
instance_apply1 is running (prs_agent ID : agent1, HOST: 172.17.0.1, PORT: 7600)
instance_llob is running (prs_agent ID : agent1, HOST: 172.17.0.1, PORT: 7600)

cmrctl add agent --name <agent_name> --grpname <group_name> --script <directory_path>
--pubnet <public_network_resource_name> --retry_cnt <retry_cnt>

$ cmrctl del <resource_type> --name <resource_name>

$ cmrctl show <resource_type> --name <resource_name>

$ cmrctl start <resource_type> --name <resource_name>

$ cmrctl stop <resource_type> --name <resource_name>

$ cmrctl act <resource_type> --name <resource_name>

$ cmrctl deact <resource_type> --name <resource_name>

$ cmrctl modify group --name <group_name> --failover <true|false>

ADMIN> shutd man (abort);

CREATE USER [백업유저이름] IDENTIFIED BY "[백업유저암호]";
GRANT CONNECT, RESOURCE, CREATE SESSION TO [백업유저이름];
GRANT INSERT ANY TABLE TO [백업유저이름];
GRANT CREATE ANY SYNONYM TO [백업유저이름];
GRANT CREATE ANY VIEW TO [백업유저이름];

mv prosync/var prosync_4_4/var
mv prosync/config prosync_4_4/config
mv prosync old_prosync
mv prosync_4_4 prosync

############################################
#
# ProSync Installation Parameters
#
############################################

# (Mandatory)
INSTANCE_ID=instance
PRS_USER=prosync_user
PRS_PWD=prosync_user_password

# (Optional)
#PRS_TS_NAME=
#PRS_TS_FILE=
#PRS_TS_SIZE=
#PRS_SKIP_USER_CREATE=N
#PRS_TARGET_MIN_PRIVILEGE=N
#PRS_LOG_DIR=
#LOG_BACKUP_DIR=
#CREATE_DSN_FILE=N
#DSN_DIR=
#DSN_FILE=#need DSN_DIR

############################################
#
# ProSync Processes Informations for Instance Map
#
############################################
### (Optional)
AGENT_LIST_DELIMITER=,

### (Mandatory)
# Ext process
## Ext cnt must be the same as SRC_DB_CNT
EXT_CNT=1
EXT_AGENT_ID_LIST_0=agent1
#EXT_AGENT_ID_LIST_1=agent1,agent2

# Apply process
APPLY_PORT=7620
APPLY_AGENT_ID_LIST=agent1

# Llob process
LLOB_PORT=7630
LLOB_AGENT_ID_LIST=agent1

...

export PREVIOUS_PRS_HOME=[old_prosync의 절대경로]

$PRS_HOME/install/prs_backup.sh \
  -c prs_install.cfg \
  -u [백업유저이름] \
  -p [백업유저암호]

GRANT SELECT ANY DICTIONARY TO $PRS_USER;
GRANT DELETE ANY TABLE TO $PRS_USER;

GRANT LOCK ANY TABLE TO $PRS_USER;
GRANT CREATE ANY TABLE TO $PRS_USER;
GRANT CREATE ANY SEQUENCE TO $PRS_USER;
GRANT CREATE ANY INDEX TO $PRS_USER;
GRANT CREATE ANY TRIGGER TO $PRS_USER;
GRANT CREATE ANY SYNONYM TO $PRS_USER;
GRANT CREATE ANY VIEW TO $PRS_USER;
GRANT CREATE ANY PROCEDURE TO $PRS_USER;
GRANT SELECT ANY DICTIONARY TO $PRS_USER;
GRANT ALTER ANY TABLE TO $PRS_USER;
GRANT ALTER ANY INDEX TO $PRS_USER;
GRANT ALTER ANY TRIGGER TO $PRS_USER;
GRANT ALTER ANY SEQUENCE TO $PRS_USER;
GRANT ALTER ANY PROCEDURE TO $PRS_USER;
GRANT DROP ANY TABLE TO $PRS_USER;
GRANT DROP ANY INDEX TO $PRS_USER;
GRANT DROP ANY TRIGGER TO $PRS_USER;
GRANT DROP ANY SEQUENCE TO $PRS_USER;
GRANT DROP ANY VIEW TO $PRS_USER;
GRANT DROP ANY PROCEDURE TO $PRS_USER;
GRANT DROP ANY SYNONYM TO $PRS_USER;
GRANT COMMENT ANY TABLE TO $PRS_USER;

-- target db oracle인 경우
GRANT SELECT ON SYS.OBJ$ TO $PRS_USER;
GRANT SELECT ON SYS.USER$ TO $PRS_USER;
GRANT SELECT ON SYS.COL$ TO $PRS_USER;
GRANT SELECT ON SYS.SEQ$ TO $PRS_USER;

cp $PRS_HOME/install/templates/prs_obj_group1.list.template \
  $PRS_HOME/install/prs_obj_group1.list

$PRS_HOME/install/prs_meta.sh -c prs_install.cfg

MGR=(ID=lmgr)(HOST=localhost)(PORT=7600)

Prosync=(
    EXT1=(MGR=lmgr)(HOST=localhost)(PORT=7610)(PROGRAM=prs_ext)
    APPLY1=(MGR=lmgr)(HOST=localhost)(PORT=7620)(PROGRAM=prs_apply)
    LLOB=(MGR=lmgr)(HOST=localhost)(PORT=7630)(PROGRAM=prs_llob)
    VF=(MGR=lmgr)(HOST=localhost)(PORT=7640)(PROGRAM=prs_vf)
)

AGENT=(ID=agent1)(HOST=172.19.0.11)(PORT=7600)

Prosync=(
    EXT1=(AGENT=agent1)(PROGRAM=prs_ext)
    APPLY1=(AGENT=agent1)(PORT=7620)(PROGRAM=prs_apply)
    LLOB=(AGENT=agent1)(PORT=7630)(PROGRAM=prs_llob)
)

ADMIN> start age(nt) {AGENT_ID}
ADMIN> start {INSTANCE_ID}

rm -rf prosync;
mv old_prosync prosync

$PRS_HOME/install/prs_install.sh -c prs_install.cfg

TRUNCATE TABLE $PRS_USER.PRS_TXINFO;
TRUNCATE TABLE $PRS_USER.PRS_OBJ_LIST;
TRUNCATE TABLE $PRS_USER.PRS_DDL_HIST;
TRUNCATE TABLE $PRS_USER.PRS_DD_CON;
TRUNCATE TABLE $PRS_USER.PRS_DD_ENC;
TRUNCATE TABLE $PRS_USER.PRS_DUMMY_TBL;
TRUNCATE TABLE $PRS_USER.PRS_LOGMNR_INFO;
TRUNCATE TABLE $PRS_USER.PRS_IMPORTED_ARCHIVE_LOG;
TRUNCATE TABLE $PRS_USER.PRS_DD_ETL_HIST;
TRUNCATE TABLE $PRS_USER.PRS_DICT_HIST;
TRUNCATE TABLE $PRS_USER.PRS_DD_USR;
TRUNCATE TABLE $PRS_USER.PRS_DD_TBL;
TRUNCATE TABLE $PRS_USER.PRS_DD_SGMT;
TRUNCATE TABLE $PRS_USER.PRS_DD_COL;
TRUNCATE TABLE $PRS_USER.PRS_IPARAM;

TRUNCATE TABLE $PRS_USER.PRS_CONST_HIST;
TRUNCATE TABLE $PRS_USER.PRS_LCT;
TRUNCATE TABLE $PRS_USER.PRS_DUMMY_TBL;
TRUNCATE TABLE $PRS_USER.PRS_COMMITTED_TX_LIST;
TRUNCATE TABLE $PRS_USER.PRS_INSTALL_HIST;

INSERT INTO $PRS_USER.PRS_TXINFO SELECT * FROM prs_backup.PRS_TXINFO;
INSERT INTO $PRS_USER.PRS_OBJ_LIST SELECT * FROM prs_backup.PRS_OBJ_LIST;
INSERT INTO $PRS_USER.PRS_DDL_HIST SELECT * FROM prs_backup.PRS_DDL_HIST;
INSERT INTO $PRS_USER.PRS_DD_CON SELECT * FROM prs_backup.PRS_DD_CON;
INSERT INTO $PRS_USER.PRS_DD_ENC SELECT * FROM prs_backup.PRS_DD_ENC;
INSERT INTO $PRS_USER.PRS_LOGMNR_INFO SELECT * FROM prs_backup.PRS_LOGMNR_INFO;
INSERT INTO $PRS_USER.PRS_IMPORTED_ARCHIVE_LOG SELECT * FROM prs_backup.PRS_IMPORTED_ARCHIVE_LOG;
INSERT INTO $PRS_USER.PRS_DD_ETL_HIST SELECT * FROM prs_backup.PRS_DD_ETL_HIST;
INSERT INTO $PRS_USER.PRS_DICT_HIST SELECT * FROM prs_backup.PRS_DICT_HIST;
INSERT INTO $PRS_USER.PRS_DD_USR SELECT * FROM prs_backup.PRS_DD_USR;
INSERT INTO $PRS_USER.PRS_DD_TBL SELECT * FROM prs_backup.PRS_DD_TBL;
INSERT INTO $PRS_USER.PRS_DD_SGMT SELECT * FROM prs_backup.PRS_DD_SGMT;
INSERT INTO $PRS_USER.PRS_DD_COL SELECT * FROM prs_backup.PRS_DD_COL;
INSERT INTO $PRS_USER.PRS_IPARAM SELECT * FROM prs_backup.PRS_IPARAM;

INSERT INTO $PRS_USER.PRS_CONST_HIST SELECT * FROM prs_backup.PRS_CONST_HIST;
INSERT INTO $PRS_USER.PRS_LCT SELECT * FROM prs_backup.PRS_LCT;
INSERT INTO $PRS_USER.PRS_COMMITTED_TX_LIST SELECT * FROM prs_backup.PRS_COMMITTED_TX_LIST;
INSERT INTO $PRS_USER.PRS_INSTALL_HIST SELECT * FROM prs_backup.PRS_INSTALL_HIST;

ADMIN> start man {AGENT_ID}
ADMIN> start {INSTANCE_ID}