3.3. SSVR+TAS+TAC
SSVR 로 구성되어 있을 경우의 기동/종료 순서 입니다.
3.3.1. Startup
| 순서 | 케이스 | Script | |
| 1 | SSVR | Common | $ tbboot mount ( * 1..n ) |
| 2 | Cluster Manager | Common | $ tbcm –b |
| 3 | TAS | cmrctl 사용 | $ cmrctl start as –name <AS1_Name> |
| Tibero command 사용 | $ export TB_SID= <AS1_Name>$ tbboot | ||
| Remote other nodes | $ cmrctl start as –name <AS2_Name>–remote<CM2_SID>@<Cluster2_Name> | ||
| 4 | TAC | cmrctl 사용 | $ cmrctl start db –name <DB1_Name> |
| Tibero command 사용 | $ export TB_SID= <DB1_Name>$ tbboot | ||
| Remote other nodes | $ cmrctl start db –name <DB2_Name>–remote<CM2_SID>@<Cluster_Name> | ||
Example
ssvr@SSVR1:/home/ssvr> tbboot mount
Listener port = 9100
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (MOUNT mode).
# SSVR1..n 만큼 Startup 수행.
# 4.2.2 Using TAS 1) Startup 절차 수행
3.3.2. Shutdown
| 순서 | 케이스 | Script | |
| 1 | TAC | cmrctl 사용 | $ cmrctl stop db –name <DB1_Name> |
| Tibero command 사용 | $ export TB_SID= <DB1_Name>$ tbdown immediate | ||
| Remote other nodes | $ cmrctl stop db –name <DB2_Name>–remote<CM2_SID>@<Cluster_Name> | ||
| 2 | TAS | cmrctl 사용 | $ cmrctl stop as –name <AS1_Name> |
| Tibero command 사용 | $ export TB_SID= <AS1_Name>$ tbdown immediate | ||
| Remote other nodes | $ cmrctl stop as –name <AS2_Name>–remote<CM2_SID>@<Cluster_Name> | ||
| 3 | Cluster Manager | Common | $ tbcm –d |
| 4 | SSVR | Common | $ tbdown immediate |
Example
# 4.2.2 Using TAS 2) Stutdown 절차 수행
ssvr@SSVR1:/home/ssvr> tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
# SSVR1..n 만큼 Shutdown 수행.
3.4. TSC
TSC(Tibero Standby Cluster)로 구성되어 있을 때 기동/종료 순서 입니다.
실제 운영될 Active 서버보다 Standby서버가 recovery모드로 우선 기동이 필요합니다.
3.4.1. Startup
| 순서 | Script | |
| 1 | Standby | $ tbboot recoverySQL> alter database open read only continue recovery; |
| 2 | Active | $ tbboot |
Example
# TSC(Standby)
tsc@edu3[tsc:Standby]:/home/tsc> tbboot recovery
Listener port = 8629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (RECOVERY mode).
tsc@edu3[tsc:Standby]:/home/tsc> tbsql sys/tibero
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Connected to Tibero.
SQL> alter database open read only continue recovery;
Database altered.
# TSC(Active)
tsc@edu2[tsc:Active]:/home/tsc> tbboot
Listener port = 8629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
3.4.2. Shutdown
| 순서 | Script | |
| 1 | Active | $ tbdown immediate |
| 2 | Standby | $ tbdown immediate |
Example
# TSC(Active)
tsc@edu2[tsc:Active]:/home/tsc> tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
# TSC(Standby)
tsc@edu3[tsc:Standby]:/home/tsc> tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
3.5. Startup Error
비정상적인 종료 이력이 있는 경우, 아래와 같은 메시지가 발생할 수 있습니다.
tibero@edu1[tac1]:/home/tibero> tbboot
***********************************************************
* BOOT FAILED.
* Garbage files have not been deleted.
* Please run “tbdown clean” and try again.
***********************************************************
이 경우, 아래와 같은 절차를 따라 오류를 해결합니다.
tibero@edu1[tac1]:/home/tibero> tbdown clean
tibero@edu1[tac1]:/home/tibero> tbboot
Listener port = 8629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
tibero@edu1[tac1]:/home/tibero>
