Skip to main content

Search

Welcome to Tibero GTS!

TSC (No observer mode) Configuration Guide in AIX Environment

Document Type | Technical Information

Category | Installation

Applicable Product Versions | 6FS07, 6FS07PS, 7FS02, 7FS02PS

Document Number | TINTI017

 

Overview

This document explains how to configure TSC no observer mode in the AIX environment.
CategoryTest Environment
OSAIX 7.3
TiberoTibero 7   (DB 7.2.2) Build 281152

Method

0. Pre-Installation Checks

It is necessary to verify if CM OBSERVER is available in the build options. (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 Environment Configuration

 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. Extract Binary

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 Configuration

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 Configuration

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. Create Database

1) Primary Node

$ tbboot nomount
$ tbsql sys/tibero

SQL> create database archive log; (For operating tsc, archive log mode is mandatory.)

$ 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
(For versions 7.2.2 and above, the -a option is not required)  


After primary db shutdown, replicate datafiles
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

After verifying files transferred by scp, proceed

$ tbboot mount
$ tbsql sys/tibero

SQL> alter database standby controlfile;

$ tbdown immediate
$ tbboot recovery

 

6. Post-TSC Deployment Verification Procedure

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) Switch to 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 Queries

-- Query TSN
select primary_tsn, recved_tsn, recovered_tsn from v$standby;

-- Query SEQ
select recved_seq, acked_seq, recovered_seq from v$standby;

-- Query BLK
select recved_blkno, acked_blkno, recovered_blkno from v$standby;

-- Query OPEN
select open_seq, open_blkno from v$standby;

 

7. Post-TSC Deployment Startup Procedure

1) Startup Procedure

1. Start standby recovery 

$ tbboot recovery

2. Start primary normal

$ tbboot

 

2) Shutdown Procedure

1. Shutdown standby

$ tbdown immediate

2. Shutdown primary

$ tbdown immediate