문서유형ㅣ기술정보

분야ㅣ관리/환경설정

적용제품버전ㅣTibero 7.2.2

문서번호ㅣTADTI157

개요

본 문서에서는 티베로를 처음 접하는 사용자가 티베로 설치 후 기본적인 기동과 종료 절차를 담고 있습니다.

Single / TAC / TSC 로 구성이 가능하며 각각의 구성 방식에 따라 기동/종료 절차가 다르므로 각자의 구성에 맞는 기동방법을 확인합니다.

참고

다양한 기동/다운 옵션 및 설명은 매뉴얼을 참고합니다.

티베로 매뉴얼, 가이드 문서 안내 바로가기

방법

Single

하나의 Instance로 구성된 DB 입니다.

기동

순서		스크립트
1	Tibero	$ tbboot

예시

tb7@edu1[tb7]:/home/tb7> tbboot
Change core dump dir to /home/tb7/tibero7/bin/prof.
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

종료

순서		스크립트
1	Tibero	$ tbdown immediate

예시

tb7@edu1[tb7]:/home/tb7> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

TAC

하나의 Database에 복수의 Instance로 구성된 DB이다. TAS(Tibero Active Storage)를 쓰는 경우와 아닌 경우로 나눠집니다.

without TAS

기동

순서		수행 유저	스크립트
1	Cluster Manager	root	$ tbcm –b
2	Tibero	tibero 설치 유저	$ tbboot

예시

# Node1

root@edu1:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tb7/tibero7/config/cm0_res.crf'...

TBCM 7.1.1 (Build 285045)

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Tibero cluster manager started up.
Local node name is (cm0:11039).

root@edu1:/root> su - tibero
tibero@edu1[tac1]:/home/tibero> tbboot
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

# Node2

root@edu2:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tb7/tibero7/config/cm1_res.crf'...

TBCM 7.1.1 (Build 285045)

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Tibero cluster manager started up.
Local node name is (cm1:11039).

root@edu2:/root> su - tibero
tibero@edu2[tac2]:/home/tibero> tbboot
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

종료

순서		수행 유저	스크립트
1	Cluster Manager	tibero 설치 유저	$ tbdown immediate
2	Tibero	tibero 설치 유저	$ tbcm -d

예시

# Node1

tibero@edu1[tac1]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

tibero@edu1[tac1]:/home/tibero> tbcm -d
CM DOWN SUCCESS!

# Node2

tibero@edu2[tac2]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

tibero@edu2[tac2]:/home/tibero> tbcm -d
CM DOWN SUCCESS!

using TAS

기동

순서		케이스	수행 유저	스크립트
1	CM	Common	root	$ tbcm –b
2	TAS	cmrctl 사용	tibero 설치 유저	$ cmrctl start as --name <AS1_Name>
		Tibero command 사용
		Remote other nodes		$ export TB_SID=<AS1_Name> $ tbboot
				$ cmrctl start as --name <AS2_Name> --remote <CM2_SID>@<Cluster_Name>
3	TAC	cmrctl 사용	root	$ cmrctl start db --name <DB1_Name>
		Tibero command 사용	tibero 설치 유저	$ export TB_SID=<DB1_Name> $ tbboot
		Remote other nodes		$ cmrctl start db --name <DB2_Name> --remote <CM2_SID>@<Cluster_Name>

예시

# Node1

# Common
root@edu1:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tb7/tibero7/config/cm0_res.crf'...

TBCM 7.1.1 (Build 285045)

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Tibero cluster manager started up.
Local node name is (cm0:11039).

root@edu1:/root> su - tibero

# Case 1 Using cmrctl command

tibero@edu1[tac1]:/home/tibero> cmrctl start as --name tas1
Listener port = 18629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)

tibero@edu1[tac1]:/home/tibero> cmrctl start db --name tac1
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)

# Case 2 
tibero@edu1[tac1]:/home/tibero> export TB_SID=tas1
tibero@edu1[tas1]:/home/tibero> tbboot
Listener port = 18629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

tibero@edu1[tas1]:/home/tibero> export TB_SID=tac1
tibero@edu1[tac1]:/home/tibero> tbboot
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

# Case 3 Remote boot other nodes

tibero@edu1[tac1]:/home/tibero> cmrctl start as --name tas2 --remote cm2@cluster1
BOOT SUCCESS! (MODE : NORMAL)

tibero@edu1[tac1]:/home/tibero> cmrctl start db --name tac2 --remote cm2@cluster1
BOOT SUCCESS! (MODE : NORMAL)

# Node2

# Common
root@edu2:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tb7/tibero7/config/cm1_res.crf'...

TBCM 7.1.1 (Build 285045)

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Tibero cluster manager started up.
Local node name is (cm1:11039).

root@edu2:/root> su - tibero


# Case 1 Using cmrctl command

tibero@edu2[tas2]:/home/tibero> cmrctl start as --name tas2
Listener port = 18629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

tibero@edu2[tas2]:/home/tibero> cmrctl start db --name tac2
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)

# Case 2

tibero@edu2[tac2]:/home/tibero> export TB_SID=tas2
tibero@edu2[tas2]:/home/tibero> tbboot
Listener port = 18629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

tibero@edu2[tas2]:/home/tibero> export TB_SID=tac2
tibero@edu2[tac2]:/home/tibero> tbboot
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

종료

순서		케이스	수행 유저	스크립트
1	TAC	cmrctl 사용	tibero 설치 유저	$ 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 사용	tibero 설치 유저	$ 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	CM	Common	root	$ tbcm –d

예시

# Node1

# Case 1 Using cmrctl command

tibero@edu1[tac1]:/home/tibero> cmrctl stop db --name tac1
MSG SENDING SUCCESS! 
tibero@edu1[tac1]:/home/tibero> cmrctl stop as --name tas1
MSG SENDING SUCCESS!

# Case 2
tibero@edu1[tac1]:/home/tibero> export TB_SID=tac1
tibero@edu1[tac1]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).              

tibero@edu1[tac1]:/home/tibero> export TB_SID=tas1
tibero@edu1[tas1]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).              

# Case 3 Remote down other nodes
tibero@edu1[tac1]:/home/tibero> cmrctl stop db --name tac2 --remote cm2@cluster1
MSG SENDING SUCCESS! 
tibero@edu1[tac1]:/home/tibero> cmrctl stop as --name tas2 --remote cm2@cluster1
MSG SENDING SUCCESS!

# Common
tibero@edu1[tas1]:/home/tibero> exit
logout
root@edu1:/root> tbcm -d
CM DOWN SUCCESS!

# Node2

# Case 1 Using cmrctl command
tibero@edu2[tac2]:/home/tibero> cmrctl stop db --name tac2
MSG SENDING SUCCESS! 
tibero@edu2[tac2]:/home/tibero> cmrctl stop as --name tas2
MSG SENDING SUCCESS!

# Case 2
tibero@edu2[tac2]:/home/tibero> export TB_SID=tac2
tibero@edu2[tac2]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).              

tibero@edu2[tac2]:/home/tibero> export TB_SID=tas2
tibero@edu2[tas2]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).              

# Common
tibero@edu2[tas2]:/home/tibero> exit
logout
root@edu2:/root> tbcm -d
CM DOWN SUCCESS!

SSVR+TAS+TAC

SSVR로 구성되어 있을 경우 기동/종료 순서입니다.

기동

순서		케이스	수행 유저	스크립트
1	SSVR	Common	root	$ tbboot mount ( * 1..n )
2	CM	Common	root	$ tbcm –b
3	TAS	Cmrctl 사용	tibero 설치 유저	$ 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 사용	tibero 설치 유저	$ cmrctl start db --name <DB1_Name>
		Tibero command 사용		$ export TB_SID=<DB1_Name> $ tbboot
		Tibero command 사용		$ cmrctl start db --name <DB2_Name> --remote <CM2_SID>@<Cluster_Name>

예시

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 절차 수행

2. 종료

순서		케이스	수행 유저	스크립트
1	TAC	Cmrctl 사용	tibero 설치 유저	$ cmrctl stop db --name <DB1_Name>
		Tibero command 사용		$ export TB_SID=<DB1_Name> $ tbdown immediate
		Tibero command 사용		$ cmrctl stop db --name <DB2_Name> --remote <CM2_SID>@<Cluster_Name>
2	TAS	Cmrctl 사용	tibero 설치 유저	$ 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	CM	Common	root	$ tbcm –d
4	SSVR	Common	root	$ tbdown immediate

예시

# 4.2.2 Using TAS 2) Stutdown 절차 수행

ssvr@SSVR1:/home/ssvr> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

# SSVR1..n 만큼 Shutdown 수행.

TSC

Tibero Standby Cluster로 구성되어 있을 때의 기동 및 종료 순서입니다. Standby 서버는 recovery 모드로 동작하므로, 실제 운영이 되는 Active 서버보다 먼저 기동되어야 합니다.

기동

순서		스크립트
1	Standby	$ tbboot recovery SQL> alter database open read only continue recovery;
2	Active	$ tbboot

예시

# TSC(Standby)

tsc@edu3[tsc:Standby]:/home/tsc> tbboot recovery
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (RECOVERY mode). 

tsc@edu3[tsc:Standby]:/home/tsc> tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. 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 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

종료

순서		스크립트
1	Standby	$ tbdown immediate
2	Active	$ tbdown immediate

예시

# TSC(Standby)

tsc@edu2[tsc:Standby]:/home/tsc> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).   
 

# TSC(Active)

tsc@edu3[tsc:Active]:/home/tsc> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

참고

Startup Error

Tibero6 및 Tibero7 특정 버전에서는 비정상 종료 이력이 있는 경우, 다음 같은 메시지가 발생할 수 있습니다.

아래 절차로 수행하면 기동할 수 있습니다.
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).

검색

Welcome to Tibero GTS!

티베로 운영 가이드 (초보자용, 기동-종료 절차)

개요

방법

Single

TAC

without TAS

using TAS

SSVR+TAS+TAC

TSC

업무 외 시간 안내

검색

Welcome to Tibero GTS!

개요

방법

Single

TAC

without TAS

using TAS

SSVR+TAS+TAC

TSC