문서유형ㅣ기술정보
분야ㅣ설치
적용제품버전ㅣ6FS07, 6FS07PS, 7FS02, 7FS02PS
문서번호ㅣTINTI017
개요
본 문서에서는 AIX환경에서 TSC no observer mode 구성하는 방법에 대해 설명합니다.
| 구분 | 테스트 환경 |
|---|---|
| OS | AIX 7.3 |
| Tibero | Tibero 7 (DB 7.2.2) Build 281152 |
방법
0. 설치 전 확인사항
빌드 옵션에서 CM OBSERVER이 가능한지 확인이 필요합니다.(D_CM_OBSERVER)
$ tbboot -version
Tibero 7 (DB 7.2.2) Build 281152
AIX aix-2016 1 7 00F80B944C00 version (big-endian)
Patch files (FS02PS_329260a FS02PS_325760c FS02PS_329445a FS02PS_329289a FS02PS_329501a FS02PS_320531d FS02PS_260558c FS02PS_304750d FS02PS_305372c FS02PS_320572b FS02PS_328182d FS02PS_329644a FS02PS_329790a FS02PS_314370c FS02PS_327810a FS02PS_328182e FS02PS_310711c FS02PS_311509c FS02PS_328463b FS02PS_229885i FS02PS_329666a FS02PS_324905b FS02PS_327971a FS02PS_293220c FS02PS_329400a FS02PS_326537a FS02PS_326383d FS02PS_329637a FS02PS_330082a FS02PS_143199d FS02PS_301647b FS02PS_227267f FS02PS_325199c FS02PS_329001a_jdbc FS02PS_301647c FS02PS_330352a FS02PS_330352b FS02PS_253667q FS02PS_326459a FS02PS_313491b FS02PS_260558d FS02PS_308355d FS02PS_329594a FS02PS_329435a FS02PS_301647d FS02PS_313968a FS02PS_308355e FS02PS_316404e FS02PS_280911a FS02PS_328273a FS02PS_313491c FS02PS_331452a FS02PS_310623d FS02PS_330392a FS02PS_329018a FS02PS_259638e FS02PS_316058a FS02PS_326173b FS02PS_328492a FS02PS_330530a FS02PS_329718a FS02PS_329943a FS02PS_328894a FS02PS_331938a FS02PS_330155a FS02PS_313968b FS02PS_331397a FS02PS_234440t FS02PS_331746a FS02PS_331031a FS02PS_310404a FS02PS_326459b FS02PS_332332a FS02PS_310711d FS02PS_234440u FS02PS_311483b FS02PS_331435a FS02PS_332341a FS02PS_262389e FS02PS_320175c FS02PS_325514b FS02PS_331618a FS02PS_330690a FS02PS_314731b FS02PS_331688a FS02PS_332780a FS02PS_329553a FS02PS_330956a FS02PS_333254a FS02PS_232998j FS02PS_331031b FS02PS_332689a FS02PS_331934a FS02PS_328939a FS02PS_330570a FS02PS_332511a FS02PS_332973a FS02PS_333402a FS02PS_327980a FS02PS_318449c FS02PS_331012a FS02PS_331374a FS02PS_299834b FS02PS_277244b FS02PS_329865a FS02PS_290198b FS02PS_232998k FS02PS_330973a FS02PS_318449d FS02PS_330173a FS02PS_330066a FS02PS_120552a FS02PS_320175d FS02PS_333647a FS02PS_333645a FS02PS_331789a FS02PS_303840a FS02PS_298920d FS02PS_333560a FS02PS_266259f FS02PS_314370d FS02PS_330066b FS02PS_332350a FS02PS_327345b FS02PS_333896a FS02PS_224914e FS02PS_330066c FS02PS_331435b FS02PS_333567a FS02PS_330173b FS02PS_330973b FS02PS_232998l)
Compiled with "cc128_r -D_HAVENOT_LINUX_AIO -D_TAC -D_XOPEN_SOURCE_EXTENDED=1 -D_ISOC99_SOURCE -D_ALL_SOURCE -qcpluscmt -qlanglvl=extc99 -g -O3 -D_OPT_COMPILED -qchars=signed -D_XOPEN_SOURCE_EXTENDED=1 -D_ISOC99_SOURCE -D_ALL_SOURCE -D_WTHR_STACK_DONT_USE_MMAP -D_USE_VIP -DHAVE_CONFIG_H -DFD_SETSIZE=8192 -D_WORDSIZE=64 -D_OS_AIX -D_AIX_64 -D_PPC -DUSE_ASSERT -DTSAM -DTSAM_NO_ESDS_SEQUENCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_USE_FSYNC -D_CHECK_LICENSE -DLGWR_DONT_USE_AIO -D_TAC_CCD -D_AC_FRAME -D_AC_CCD -D_AC_CCN -qchars=signed -D_STBLOG -D_CM_OBSERVER -D_USE_FALLOCATE -D_LARGE_FILES -D_GNU_SOURCE -D_GNU_SOURCE -DHAVE_POLLSET"
Compiled at Oct 24 2024 21:33:14 build seq 281152 init rev {2023-11-24}1. profile 환경설정
1) Primary Node
######## Profile ENV Config ###############
#export PS1=`uname -n`'@$LOGNAME:$PWD $ '
export PS1="[`whoami`@`hostname`:\$PWD]$ "
export TERM=vt100
umask 022
export EDITOR=vi
alias s='cd ..'
alias l='ls -al'
alias ll='ls -alF'
######## TIBERO ENV ########
export TB_BASE=/data/pub1/kiw/tsc
export TB_HOME=$TB_BASE/tibero7
export TB_SID=tsc1
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$PATH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH
export LIBPATH=$TB_HOME/lib:$TB_HOME/client/lib:$LIBPATH
######## TIBERO alias ########
alias tbhome='cd $TB_HOME'
alias tbbin='cd $TB_HOME/bin'
alias tblog='cd $TB_HOME/instance/$TB_SID/log'
alias tbcfg='cd $TB_HOME/config'
alias tbcfgv='vi $TB_HOME/config/$TB_SID.tip'
alias tbcli='cd ${TB_HOME}/client/config'
alias tbcliv='vi ${TB_HOME}/client/config/tbdsn.tbr'
#alias tbcliv='vi ${TB_HOME}/client/config/tbnet_alias.tbr'
alias tbi='cd $TB_BASE/tbinary'
alias tm='cd $TB_BASE/tbinary/monitor;monitor;cd'
2) Standby Node
######## Profile ENV Config ###############
#export PS1=`uname -n`'@$LOGNAME:$PWD $ '
export PS1="[`whoami`@`hostname`:\$PWD]$ "
export TERM=vt100
umask 022
export EDITOR=vi
alias s='cd ..'
alias l='ls -al'
alias ll='ls -alF'
######## TIBERO ENV ########
export TB_BASE=/data/pub1/kiw/tsc
export TB_HOME=$TB_BASE/tibero7
export TB_SID=tsc2
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$PATH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH
export LIBPATH=$TB_HOME/lib:$TB_HOME/client/lib:$LIBPATH
######## TIBERO alias ########
alias tbhome='cd $TB_HOME'
alias tbbin='cd $TB_HOME/bin'
alias tblog='cd $TB_HOME/instance/$TB_SID/log'
alias tbcfg='cd $TB_HOME/config'
alias tbcfgv='vi $TB_HOME/config/$TB_SID.tip'
alias tbcli='cd ${TB_HOME}/client/config'
alias tbcliv='vi ${TB_HOME}/client/config/tbdsn.tbr'
#alias tbcliv='vi ${TB_HOME}/client/config/tbnet_alias.tbr'
alias tbi='cd $TB_BASE/tbinary'
alias tm='cd $TB_BASE/tbinary/monitor;monitor;cd'
alias tt='tbsql sys/tibero'
export LANG=C
export TB_NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'
2. 바이너리 압축 해제
1) Primary Node
$ su - tibero $ gzip -dc tibero7-bin-FS02_PS02-aix_7.1-281152-20241024103828.tar.gz | tar xvf -
2) Standby Node
$ su - tibero $ gzip -dc tibero7-bin-FS02_PS02-aix_7.1-281152-20241024103828.tar.gz | tar xvf -
3. $TB_SID.tip 설정
1) Primary Node
$ sh $TB_HOME/config/gen_tip.sh $ vi $TB_HOME/config/$TB_SID.tip #------------------------------------------------------------------------------- # # RDBMS initialization parameter # #------------------------------------------------------------------------------- DB_NAME=tsc LISTENER_PORT=3310 CONTROL_FILES="/data/pub1/kiw/tsc/tibero7/database/tsc1/c1.ctl" #CERTIFICATE_FILE="/data/pub1/kiw/tsc/tibero7/config/tb_wallet/tsc1.crt" #PRIVKEY_FILE="/data/pub1/kiw/tsc/tibero7/config/tb_wallet/tsc1.key" #WALLET_FILE="/data/pub1/kiw/tsc/tibero7/config/tb_wallet/WALLET" #ILOG_MAP="/data/pub1/kiw/tsc/tibero7/config/ilog.map" MAX_SESSION_COUNT=20 TOTAL_SHM_SIZE=2G MEMORY_TARGET=4G #---------------------------------------------- # TSC #---------------------------------------------- LOG_REPLICATION_MODE=PERFORMANCE LOG_REPLICATION_DEST_1="192.168.1.213:3314 LGWR ASYNC"
2) Standby Node
$ sh $TB_HOME/config/gen_tip.sh $ vi $TB_HOME/config/$TB_SID.tip #------------------------------------------------------------------------------- # # RDBMS initialization parameter # #------------------------------------------------------------------------------- DB_NAME=tsc LISTENER_PORT=3310 CONTROL_FILES="/data/pub1/kiw/tsc/tibero7/database/tsc1/c1.ctl" #CERTIFICATE_FILE="/data/pub1/kiw/tsc/tibero7/config/tb_wallet/tsc2.crt" #PRIVKEY_FILE="/data/pub1/kiw/tsc/tibero7/config/tb_wallet/tsc2.key" #WALLET_FILE="/data/pub1/kiw/tsc/tibero7/config/tb_wallet/WALLET" #ILOG_MAP="/data/pub1/kiw/tsc/tibero7/config/ilog.map" MAX_SESSION_COUNT=20 TOTAL_SHM_SIZE=2G MEMORY_TARGET=4G #---------------------------------------------- # TSC #---------------------------------------------- #LOG_REPLICATION_MODE=PERFORMANCE #LOG_REPLICATION_DEST_1="192.168.1.212:3314 LGWR ASYNC"
4. tbdsn.tbr 설정
1) Primary Node
-- tibero
$ vi $TB_HOME/client/config/tbdsn.tbr
tsc1=(
(INSTANCE=(HOST=localhost)
(PORT=3310)
(DB_NAME=tsc)
)
)
2) Standby Node
-- tibero
$ vi $TB_HOME/client/config/tbdsn.tbr
tsc2=(
(INSTANCE=(HOST=localhost)
(PORT=3310)
(DB_NAME=tsc)
)
)5. DB 생성
1) Primary Node
$ tbboot nomount $ tbsql sys/tibero SQL> create database archive log; (tsc 운영하기 위해서는 반드시 archive log mode여야 한다.) $ tbboot Listener port = 3310 Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero instance started up (NORMAL mode). $ sh $TB_HOME/scripts/system.sh -p1 tibero -p2 syscat -a1 y -a2 y -a3 y -a4 y (7.2.2 이상의 버전들은 -a 옵션 사용하지 않아도 됨) primary db down 후 datafile 복제 scp -r * tibero@192.168.1.213:/data/pub1/kiw/tsc/tibero7/database/ scp -r .passwd tibero@192.168.1.213:/data/pub1/kiw/tsc/tibero7/database/
2) Standby Node
scp로 넘긴 파일 확인 후 진행 $ tbboot mount $ tbsql sys/tibero SQL> alter database standby controlfile; $ tbdown immediate $ tbboot recovery
6. TSC 구축 후 검증 절차
1) Primary Node
SQL> select open_mode from v$database; OPEN_MODE ---------- READ WRITE SQL> select status from v$standby; STATUS ---------------------------------------- PRIMARY NOT CONNECTED
2) Standby Node
SQL> select open_mode from v$database; OPEN_MODE ---------- RECOVERY SQL> select status from v$standby; STATUS ---------------------------------------- STANDBY, RECOVERY IN PROGRESS
3) Standby read only mode 전환
SQL> alter database open read only continue recovery; SQL> select open_mode from v$database; OPEN_MODE ---------- READ ONLY SQL> select status from v$standby; STATUS --------------------------------------- READ-ONLY STANDBY, RECOVERY IN PROGRESS
4) Standby Node 조회
-- TSN 조회 select primary_tsn, recved_tsn, recovered_tsn from v$standby; -- SEQ 조회 select recved_seq, acked_seq, recovered_seq from v$standby; -- BLK 조회 select recved_blkno, acked_blkno, recovered_blkno from v$standby; -- OPEN 조회 select open_seq, open_blkno from v$standby;
7. TSC 구축 후 기동 절차
1) 기동 절차
1. standby recovery 기동 $ tbboot recovery 2. primary normal 기동 $ tbboot
2) 종료 절차
1.standby 종료 $ tbdown immediate 2. primary 종료 $ tbdown immediate