3. Tibero Process Startup & Shutdown
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 recovery
SQL> 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>
|
'Admin, 환경설정' 카테고리의 다른 글
| [Tibero] Tibero 운영 가이드 for beginner (7) (0) | 2023.05.12 |
|---|---|
| [Tibero] Tibero 운영 가이드 for beginner (6) (0) | 2023.05.12 |
| [Tibero] Tibero 운영 가이드 for beginner (4) (0) | 2023.05.12 |
| [Tibero] Tibero 운영 가이드 for beginner (3) (0) | 2023.05.12 |
| [Tibero] Tibero 운영 가이드 for beginner (1) (0) | 2023.05.12 |