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>

☞ “[Tibero] Tibero 운영 가이드 for beginner (6)”에서 계속됩니다.