기술문서 Tibero 관리 2
2023.10.25 14:30
Tibero 관리 2
## tbsql 사용시 tbsdn.tbr 사용 안하고 접속하는 방법
tbsql sys/tibero@127.0.0.1:8629/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL>
------------------------------------------------------------------
[tibero@T1:/tibero/tibero7/client/config]$ tbboot -h
Usage: tbboot [-h] [-v] [-l] [-C] [-t BOOTMODE]
-h: show this help.
-v: show RDBMS version.
-l: show license information.
-C: show available character set list.
-c: No replication mode.
-w: wallet auto-login mode.
BOOTMODE: one of NOMOUNT MOUNT RECOVERY NORMAL RESETLOGS ALTERDD READONLY FAILOVER
If no bootmode is set, default bootmode is 'NORMAL'.
[tibero@T1:/tibero/tibero7/client/config]$ tbboot -v
Tibero 7 (DB 7.0 FS02) Build 258363
Linux bistro-build-centos_7 5.15.0-56-generic #62~20.04.1-Ubuntu SMP Tue Nov 22 21:24:20 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux version (little-endian)
Patch files (FS02_176852j FS02_203072b FS02_212908b FS02_223255b FS02_227908c_expimp FS02_232270h FS02_236665l FS02_246823g FS02_249466b FS02_251228b FS02_255286v FS02_257900a FS02_260041c FS02_266259e FS02_271637b FS02_273334a FS02_274278a FS02_276471c FS02_277051j FS02_277704c FS02_278952b FS02_279336a FS02_279651b FS02_280126a FS02_280522a FS02_280552a FS02_280611a FS02_280738a FS02_280999a FS02_282405b FS02_282595b FS02_282633b FS02_282943a FS02_283135a FS02_283499b FS02_283526a FS02_283894b FS02_284734a FS02_284802a FS02_284992a FS02_285007a FS02_285048a FS02_285117a FS02_285296b FS02_285368a FS02_285441a FS02_285449a FS02_285483a FS02_285499a FS02_285500a FS02_285511a FS02_285590a FS02_285596a FS02_285818a FS02_285982a FS02_286019b FS02_286172a FS02_286232a FS02_286479a FS02_286538d FS02_286571a FS02_286640a FS02_286669a FS02_286705a FS02_286725a FS02_286769a FS02_286873b FS02_286934a FS02_286944a FS02_287034b FS02_287049d_expimp FS02_287073a FS02_287193c FS02_287325a FS02_287362a FS02_287424a FS02_287466a FS02_287577a FS02_287671a FS02_287752a_expimp FS02_287904b FS02_287925a_expimp FS02_287998a FS02_288022b FS02_288092a FS02_288315a FS02_288316a FS02_289023a FS02_289061a FS02_289441a FS02_291574a FS02_291950a)
Compiled with "cc -Wl,--no-as-needed -D_TAC -ggdb -fstack-protector-all -O3 -fno-strict-aliasing -fno-omit-frame-pointer -pipe -D_OPT_COMPILED -D_USE_VIP -Wall -W -Werror-implicit-function-declaration -Wno-unused-parameter -Wpointer-arith -Wdeclaration-after-statement -DHAVE_CONFIG_H -DFD_SETSIZE=8192 -D_WORDSIZE=64 -D_OS_LINUX -D_LINUX_X86_64 -D_X86 -DUSE_ASSERT -DTSAM -DTSAM_NO_ESDS_SEQUENCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_USE_FSYNC -D_CHECK_LICENSE -D_STBLOG -D_CM_OBSERVER -D_USE_FALLOCATE -D_GNU_SOURCE -D_GNU_SOURCE -D_GNU_SOURCE -D_GNU_SOURCE -DHAVE_EPOLL"
Compiled at Feb 23 2023 19:40:44 build seq 258363 init rev {2022-03-10}
[tibero@T1:/tibero/tibero7/client/config]$ tbboot -l
############################
License Information
############################
License Version: 1.0
Licensee: T1
License Type: demo
Product Name: Tibero
Product Version: 7
Edition: enterprise
Module:
Issue Time: 2023/04/24
Start Time: 2023/04/24
Expiration Time: 2023/10/23
Limit User: UNLIMITED
Limit CPU: UNLIMITED
Limit Instance: UNLIMITED
Identification Method: Hostname=T1
The license has been validated.
tbboot [-t BOOTMODE] -t 생략가능 , 입력 안할경우 기본이 NORMAL
[tibero@T1:/tibero/tibero7/config]$ tbboot nomount
Change core dump dir to /tibero/tibero7/bin/prof.
Listener port = 8629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NOMOUNT mode).
[tibero@T1:/tibero/tibero7/config]$
[tibero@T1:/tibero/tibero7/config]$ ps -ef | grep tbsvr
tibero 18451 1 5 10:49 pts/2 00:00:00 tbsvr -t nomount -SVR_SID tibero
tibero 18453 18451 0 10:49 pts/2 00:00:00 tbsvr_MGWP -t nomount -SVR_SID tibero
tibero 18454 18451 0 10:49 pts/2 00:00:00 tbsvr_FGWP000 -t nomount -SVR_SID tibero
tibero 18455 18451 0 10:49 pts/2 00:00:00 tbsvr_FGWP001 -t nomount -SVR_SID tibero
tibero 18456 18451 0 10:49 pts/2 00:00:00 tbsvr_FGWP002 -t nomount -SVR_SID tibero
tibero 18457 18451 0 10:49 pts/2 00:00:00 tbsvr_BGWP003 -t nomount -SVR_SID tibero
tibero 18458 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP000 -t nomount -SVR_SID tibero
tibero 18459 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP001 -t nomount -SVR_SID tibero
tibero 18460 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP002 -t nomount -SVR_SID tibero
tibero 18461 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP003 -t nomount -SVR_SID tibero
tibero 18462 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP004 -t nomount -SVR_SID tibero
tibero 18463 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP005 -t nomount -SVR_SID tibero
tibero 18464 18451 0 10:49 pts/2 00:00:00 tbsvr_AGNT -t nomount -SVR_SID tibero
tibero 18465 18451 0 10:49 pts/2 00:00:00 tbsvr_DBWR -t nomount -SVR_SID tibero
tibero 18466 18451 0 10:49 pts/2 00:00:00 tbsvr_RCWP -t nomount -SVR_SID tibero
tibero 18676 6683 0 10:49 pts/2 00:00:00 grep --color=auto tbsvr
[tibero@T1:/tibero/tibero7/config]$
[tibero@T1:/tibero/tibero7/config]$ ps -ef | grep tibero
root 1937 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 1969 1937 0 Sep20 ? 00:00:00 sshd: tibero@pts/0
tibero 1970 1969 0 Sep20 pts/0 00:00:00 -bash
root 6670 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 6682 6670 0 Sep20 ? 00:00:01 sshd: tibero@pts/2
tibero 6683 6682 0 Sep20 pts/2 00:00:00 -bash
tibero 18451 1 0 10:49 pts/2 00:00:00 tbsvr -t nomount -SVR_SID tibero
tibero 18452 18451 0 10:49 pts/2 00:00:00 /tibero/tibero7/bin/tblistener -n 11 -t NOMOUNT -SVR_SID tibero
tibero 18453 18451 0 10:49 pts/2 00:00:00 tbsvr_MGWP -t nomount -SVR_SID tibero
tibero 18454 18451 0 10:49 pts/2 00:00:00 tbsvr_FGWP000 -t nomount -SVR_SID tibero
tibero 18455 18451 0 10:49 pts/2 00:00:00 tbsvr_FGWP001 -t nomount -SVR_SID tibero
tibero 18456 18451 0 10:49 pts/2 00:00:00 tbsvr_FGWP002 -t nomount -SVR_SID tibero
tibero 18457 18451 0 10:49 pts/2 00:00:00 tbsvr_BGWP003 -t nomount -SVR_SID tibero
tibero 18458 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP000 -t nomount -SVR_SID tibero
tibero 18459 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP001 -t nomount -SVR_SID tibero
tibero 18460 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP002 -t nomount -SVR_SID tibero
tibero 18461 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP003 -t nomount -SVR_SID tibero
tibero 18462 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP004 -t nomount -SVR_SID tibero
tibero 18463 18451 0 10:49 pts/2 00:00:00 tbsvr_PEWP005 -t nomount -SVR_SID tibero
tibero 18464 18451 0 10:49 pts/2 00:00:00 tbsvr_AGNT -t nomount -SVR_SID tibero
tibero 18465 18451 0 10:49 pts/2 00:00:00 tbsvr_DBWR -t nomount -SVR_SID tibero
tibero 18466 18451 0 10:49 pts/2 00:00:00 tbsvr_RCWP -t nomount -SVR_SID tibero
tibero 18714 6683 0 10:49 pts/2 00:00:00 ps -ef
tibero 18715 6683 0 10:49 pts/2 00:00:00 grep --color=auto tibero
tibero 19800 1970 0 Sep20 pts/0 00:00:00 rlwrap tbsql sys/tibero
tibero 19801 19800 0 Sep20 pts/1 00:00:00 tbsql
[tibero@T1:/tibero/tibero7/config]$ tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
[tibero@T1:/tibero/tibero7/config]$ tbboot mount
Change core dump dir to /tibero/tibero7/bin/prof.
Listener port = 8629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
[tibero@T1:/tibero/tibero7/config]$ ps -ef | grep tiberop
tibero 19197 6683 0 10:51 pts/2 00:00:00 grep --color=auto tiberop
[tibero@T1:/tibero/tibero7/config]$ ps -ef | grep tibero
root 1937 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 1969 1937 0 Sep20 ? 00:00:00 sshd: tibero@pts/0
tibero 1970 1969 0 Sep20 pts/0 00:00:00 -bash
root 6670 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 6682 6670 0 Sep20 ? 00:00:01 sshd: tibero@pts/2
tibero 6683 6682 0 Sep20 pts/2 00:00:00 -bash
tibero 18969 1 3 10:51 pts/2 00:00:00 tbsvr -t mount -SVR_SID tibero
tibero 18970 18969 0 10:51 pts/2 00:00:00 /tibero/tibero7/bin/tblistener -n 11 -t MOUNT -SVR_SID tibero
tibero 18971 18969 0 10:51 pts/2 00:00:00 tbsvr_MGWP -t mount -SVR_SID tibero
tibero 18972 18969 0 10:51 pts/2 00:00:00 tbsvr_FGWP000 -t mount -SVR_SID tibero
tibero 18973 18969 0 10:51 pts/2 00:00:00 tbsvr_FGWP001 -t mount -SVR_SID tibero
tibero 18974 18969 0 10:51 pts/2 00:00:00 tbsvr_FGWP002 -t mount -SVR_SID tibero
tibero 18975 18969 0 10:51 pts/2 00:00:00 tbsvr_BGWP003 -t mount -SVR_SID tibero
tibero 18976 18969 0 10:51 pts/2 00:00:00 tbsvr_PEWP000 -t mount -SVR_SID tibero
tibero 18977 18969 0 10:51 pts/2 00:00:00 tbsvr_PEWP001 -t mount -SVR_SID tibero
tibero 18978 18969 0 10:51 pts/2 00:00:00 tbsvr_PEWP002 -t mount -SVR_SID tibero
tibero 18979 18969 0 10:51 pts/2 00:00:00 tbsvr_PEWP003 -t mount -SVR_SID tibero
tibero 18980 18969 0 10:51 pts/2 00:00:00 tbsvr_PEWP004 -t mount -SVR_SID tibero
tibero 18981 18969 0 10:51 pts/2 00:00:00 tbsvr_PEWP005 -t mount -SVR_SID tibero
tibero 18982 18969 0 10:51 pts/2 00:00:00 tbsvr_AGNT -t mount -SVR_SID tibero
tibero 18983 18969 0 10:51 pts/2 00:00:00 tbsvr_DBWR -t mount -SVR_SID tibero
tibero 18984 18969 0 10:51 pts/2 00:00:00 tbsvr_RCWP -t mount -SVR_SID tibero
tibero 19200 6683 0 10:51 pts/2 00:00:00 ps -ef
tibero 19201 6683 0 10:51 pts/2 00:00:00 grep --color=auto tibero
tibero 19800 1970 0 Sep20 pts/0 00:00:00 rlwrap tbsql sys/tibero
tibero 19801 19800 0 Sep20 pts/1 00:00:00 tbsql
nomount, mount 라고 프로세서 상태라고 말할수 없다
실행할때의 지시사항일 뿐이고 실제 마운트가 된것인지는 알수 없다
콘트롤파일에 문제가 생겨서 노마운트상태일수도 있다
[tibero@T1:/tibero/tibero7/config]$ tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
[tibero@T1:/tibero/tibero7/config]$ tbboot normal
Change core dump dir to /tibero/tibero7/bin/prof.
Listener port = 8629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
[tibero@T1:/tibero/tibero7/config]$ ps -ef | grep tibero
root 1937 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 1969 1937 0 Sep20 ? 00:00:00 sshd: tibero@pts/0
tibero 1970 1969 0 Sep20 pts/0 00:00:00 -bash
root 6670 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 6682 6670 0 Sep20 ? 00:00:01 sshd: tibero@pts/2
tibero 6683 6682 0 Sep20 pts/2 00:00:00 -bash
tibero 19515 1 3 10:54 pts/2 00:00:00 tbsvr -t normal -SVR_SID tibero
tibero 19516 19515 0 10:54 pts/2 00:00:00 /tibero/tibero7/bin/tblistener -n 11 -t NORMAL -SVR_SID tibero
tibero 19517 19515 0 10:54 pts/2 00:00:00 tbsvr_MGWP -t normal -SVR_SID tibero
tibero 19518 19515 0 10:54 pts/2 00:00:00 tbsvr_FGWP000 -t normal -SVR_SID tibero
tibero 19519 19515 0 10:54 pts/2 00:00:00 tbsvr_FGWP001 -t normal -SVR_SID tibero
tibero 19520 19515 0 10:54 pts/2 00:00:00 tbsvr_FGWP002 -t normal -SVR_SID tibero
tibero 19521 19515 0 10:54 pts/2 00:00:00 tbsvr_BGWP003 -t normal -SVR_SID tibero
tibero 19522 19515 0 10:54 pts/2 00:00:00 tbsvr_PEWP000 -t normal -SVR_SID tibero
tibero 19523 19515 0 10:54 pts/2 00:00:00 tbsvr_PEWP001 -t normal -SVR_SID tibero
tibero 19524 19515 0 10:54 pts/2 00:00:00 tbsvr_PEWP002 -t normal -SVR_SID tibero
tibero 19525 19515 0 10:54 pts/2 00:00:00 tbsvr_PEWP003 -t normal -SVR_SID tibero
tibero 19526 19515 0 10:54 pts/2 00:00:00 tbsvr_PEWP004 -t normal -SVR_SID tibero
tibero 19527 19515 0 10:54 pts/2 00:00:00 tbsvr_PEWP005 -t normal -SVR_SID tibero
tibero 19528 19515 1 10:54 pts/2 00:00:00 tbsvr_AGNT -t normal -SVR_SID tibero
tibero 19529 19515 0 10:54 pts/2 00:00:00 tbsvr_DBWR -t normal -SVR_SID tibero
tibero 19530 19515 0 10:54 pts/2 00:00:00 tbsvr_RCWP -t normal -SVR_SID tibero
tibero 19744 6683 0 10:54 pts/2 00:00:00 ps -ef
tibero 19745 6683 0 10:54 pts/2 00:00:00 grep --color=auto tibero
tibero 19800 1970 0 Sep20 pts/0 00:00:00 rlwrap tbsql sys/tibero
tibero 19801 19800 0 Sep20 pts/1 00:00:00 tbsql
노말로 부팅시켰지만 마운트상태나 노마운트 상태일수도 있다
## ps 조회시 normal 조회되고, 인스턴스는 control 파일만 오픈 상태
# 인스턴스 종료후 redolog 파일 중 한개를 숨긴다./
# 인스턴스 시작! 에러 발생하고 mount mode가 됨
[tibero@T1:/tibero/tbdata/data_1]$ tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$ mv log001.log log001.log_1
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$ tbboot -t normal
Change core dump dir to /tibero/tibero7/bin/prof.
Listener port = 8629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
[tibero@T1:/tibero/tbdata/data_1]$ ps -ef | grep tibero
root 1937 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 1969 1937 0 Sep20 ? 00:00:00 sshd: tibero@pts/0
tibero 1970 1969 0 Sep20 pts/0 00:00:00 -bash
root 6670 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 6682 6670 0 Sep20 ? 00:00:01 sshd: tibero@pts/2
tibero 6683 6682 0 Sep20 pts/2 00:00:00 -bash
tibero 19800 1970 0 Sep20 pts/0 00:00:00 rlwrap tbsql sys/tibero
tibero 19801 19800 0 Sep20 pts/1 00:00:00 tbsql
tibero 21566 1 1 11:17 pts/2 00:00:00 tbsvr -t normal -SVR_SID tibero
tibero 21567 21566 0 11:17 pts/2 00:00:00 /tibero/tibero7/bin/tblistener -n 11 -t NORMAL -SVR_SID tibero
tibero 21569 21566 0 11:17 pts/2 00:00:00 tbsvr_MGWP -t normal -SVR_SID tibero
tibero 21570 21566 0 11:17 pts/2 00:00:00 tbsvr_FGWP000 -t normal -SVR_SID tibero
tibero 21571 21566 0 11:17 pts/2 00:00:00 tbsvr_FGWP001 -t normal -SVR_SID tibero
tibero 21572 21566 0 11:17 pts/2 00:00:00 tbsvr_FGWP002 -t normal -SVR_SID tibero
tibero 21573 21566 0 11:17 pts/2 00:00:00 tbsvr_BGWP003 -t normal -SVR_SID tibero
tibero 21574 21566 0 11:17 pts/2 00:00:00 tbsvr_PEWP000 -t normal -SVR_SID tibero
tibero 21575 21566 0 11:17 pts/2 00:00:00 tbsvr_PEWP001 -t normal -SVR_SID tibero
tibero 21576 21566 0 11:17 pts/2 00:00:00 tbsvr_PEWP002 -t normal -SVR_SID tibero
tibero 21577 21566 0 11:17 pts/2 00:00:00 tbsvr_PEWP003 -t normal -SVR_SID tibero
tibero 21578 21566 0 11:17 pts/2 00:00:00 tbsvr_PEWP004 -t normal -SVR_SID tibero
tibero 21579 21566 0 11:17 pts/2 00:00:00 tbsvr_PEWP005 -t normal -SVR_SID tibero
tibero 21580 21566 0 11:17 pts/2 00:00:00 tbsvr_AGNT -t normal -SVR_SID tibero
tibero 21581 21566 0 11:17 pts/2 00:00:00 tbsvr_DBWR -t normal -SVR_SID tibero
tibero 21582 21566 0 11:17 pts/2 00:00:00 tbsvr_RCWP -t normal -SVR_SID tibero
tibero 21835 6683 0 11:17 pts/2 00:00:00 ps -ef
tibero 21836 6683 0 11:17 pts/2 00:00:00 grep --color=auto tibero
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$ ls -la
total 880668
drwxr-xr-x 3 tibero dba 297 Sep 21 11:16 .
drwxr-xr-x 6 tibero dba 66 Apr 25 10:40 ..
-rw------- 1 tibero dba 10485760 Sep 21 11:17 EXAMPLE01.dtf
drwx------ 3 tibero dba 17 Apr 25 10:40 java
-rw------- 1 tibero dba 10485760 Sep 21 11:17 KL01.dtf
-rw------- 1 tibero dba 52428800 Sep 21 11:16 log001.log_1
-rw------- 1 tibero dba 52428800 Sep 21 11:17 log002.log
-rw------- 1 tibero dba 52428800 Sep 21 11:17 log003.log
-rw------- 1 tibero dba 52428800 Sep 21 11:17 log004.log
-rw------- 1 tibero dba 52428800 Sep 21 11:17 log005.log
-rw------- 1 tibero dba 52428800 Sep 21 11:17 log006.log
-rw-r--r-- 1 tibero dba 44 Sep 21 11:16 .passwd
-rw------- 1 tibero dba 20971520 Sep 21 11:17 syssub001.dtf
-rw------- 1 tibero dba 115343360 Sep 21 11:17 system001.dtf
-rw------- 1 tibero dba 104857600 Sep 21 00:01 temp001.dtf
-rw------- 1 tibero dba 209715200 Sep 21 11:17 undo001.dtf
-rw------- 1 tibero dba 10485760 Sep 21 11:17 USERS01.dtf
-rw------- 1 tibero dba 104857600 Sep 21 11:17 usr001.dtf
[tibero@T1:/tibero/tbdata/data_1]$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL>
SQL> select * from dual;
DUMMY
-----
X
1 row selected.
SQL>
[tibero@T1:/tibero/tbdata/data_1]$ ls -la
total 880668
drwxr-xr-x 3 tibero dba 299 Sep 21 11:22 .
drwxr-xr-x 6 tibero dba 66 Apr 25 10:40 ..
-rw------- 1 tibero dba 10485760 Sep 21 11:21 EXAMPLE01.dtf
drwx------ 3 tibero dba 17 Apr 25 10:40 java
-rw------- 1 tibero dba 10485760 Sep 21 11:21 KL01.dtf
-rw------- 1 tibero dba 52428800 Sep 21 11:16 log001.log_1
-rw------- 1 tibero dba 52428800 Sep 21 11:17 log002.log_1
-rw------- 1 tibero dba 52428800 Sep 21 11:21 log003.log
-rw------- 1 tibero dba 52428800 Sep 21 11:21 log004.log
-rw------- 1 tibero dba 52428800 Sep 21 11:17 log005.log
-rw------- 1 tibero dba 52428800 Sep 21 11:17 log006.log
-rw-r--r-- 1 tibero dba 44 Sep 21 11:21 .passwd
-rw------- 1 tibero dba 20971520 Sep 21 11:21 syssub001.dtf
-rw------- 1 tibero dba 115343360 Sep 21 11:21 system001.dtf
-rw------- 1 tibero dba 104857600 Sep 21 00:01 temp001.dtf
-rw------- 1 tibero dba 209715200 Sep 21 11:21 undo001.dtf
-rw------- 1 tibero dba 10485760 Sep 21 11:21 USERS01.dtf
-rw------- 1 tibero dba 104857600 Sep 21 11:21 usr001.dtf
[tibero@T1:/tibero/tbdata/data_1]$ tbboot normal
Change core dump dir to /tibero/tibero7/bin/prof.
Listener port = 8629
********************************************************
* Critical Warning : Raise svmode failed. The reason is
* TBR-1042 : Unable to read log member file in group 0, member 1 (/tibero/tbdata/data_1/log002.log), block 0.
* Current server mode is MOUNT.
********************************************************
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started suspended at MOUNT mode.
[tibero@T1:/tibero/tbdata/data_1]$ ps -ef | grep tibero
root 1937 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 1969 1937 0 Sep20 ? 00:00:00 sshd: tibero@pts/0
tibero 1970 1969 0 Sep20 pts/0 00:00:00 -bash
root 6670 1487 0 Sep20 ? 00:00:00 sshd: tibero [priv]
tibero 6682 6670 0 Sep20 ? 00:00:01 sshd: tibero@pts/2
tibero 6683 6682 0 Sep20 pts/2 00:00:00 -bash
tibero 19800 1970 0 Sep20 pts/0 00:00:00 rlwrap tbsql sys/tibero
tibero 19801 19800 0 Sep20 pts/1 00:00:00 tbsql
tibero 22343 1 0 11:22 pts/2 00:00:00 tbsvr -t normal -SVR_SID tibero
tibero 22344 22343 0 11:22 pts/2 00:00:00 /tibero/tibero7/bin/tblistener -n 11 -t NORMAL -SVR_SID tibero
tibero 22345 22343 0 11:22 pts/2 00:00:00 tbsvr_MGWP -t normal -SVR_SID tibero
tibero 22346 22343 0 11:22 pts/2 00:00:00 tbsvr_FGWP000 -t normal -SVR_SID tibero
tibero 22347 22343 0 11:22 pts/2 00:00:00 tbsvr_FGWP001 -t normal -SVR_SID tibero
tibero 22348 22343 0 11:22 pts/2 00:00:00 tbsvr_FGWP002 -t normal -SVR_SID tibero
tibero 22349 22343 0 11:22 pts/2 00:00:00 tbsvr_BGWP003 -t normal -SVR_SID tibero
tibero 22350 22343 0 11:22 pts/2 00:00:00 tbsvr_PEWP000 -t normal -SVR_SID tibero
tibero 22351 22343 0 11:22 pts/2 00:00:00 tbsvr_PEWP001 -t normal -SVR_SID tibero
tibero 22352 22343 0 11:22 pts/2 00:00:00 tbsvr_PEWP002 -t normal -SVR_SID tibero
tibero 22353 22343 0 11:22 pts/2 00:00:00 tbsvr_PEWP003 -t normal -SVR_SID tibero
tibero 22354 22343 0 11:22 pts/2 00:00:00 tbsvr_PEWP004 -t normal -SVR_SID tibero
tibero 22355 22343 0 11:22 pts/2 00:00:00 tbsvr_PEWP005 -t normal -SVR_SID tibero
tibero 22356 22343 0 11:22 pts/2 00:00:00 tbsvr_AGNT -t normal -SVR_SID tibero
tibero 22357 22343 0 11:22 pts/2 00:00:00 tbsvr_DBWR -t normal -SVR_SID tibero
tibero 22358 22343 0 11:22 pts/2 00:00:00 tbsvr_RCWP -t normal -SVR_SID tibero
tibero 22664 6683 0 11:24 pts/2 00:00:00 ps -ef
tibero 22665 6683 0 11:24 pts/2 00:00:00 grep --color=auto tibero
[tibero@T1:/tibero/tbdata/data_1]$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> select 1 from dual;
1
----------
1
1 row selected.
SQL>
-- 인스턴스 구동 상태 조회
SQL> select status from v$instance;
STATUS
----------------
MOUNT
1 row selected.
SQL>
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
1 row selected.
SQL>
로그확인
[tibero@T1:/tibero/tibero7/instance/tibero/log]$ ls -la
total 356
drwxr-xr-x 8 tibero dba 4096 Sep 21 11:22 .
drwxr-xr-x 5 tibero dba 59 Sep 21 11:22 ..
drwxr-xr-x 2 tibero dba 23 Apr 25 10:36 audit
drwxr-xr-x 2 tibero dba 35 Sep 20 14:27 callstack
drwxr-xr-x 2 tibero dba 22 Apr 25 10:36 dlog
drwxr-xr-x 16 tibero dba 8192 Sep 21 11:22 ilog
drwxr-xr-x 2 tibero dba 28 Apr 25 10:36 lsnr
-rw------- 1 tibero dba 0 Sep 21 11:22 lsnr.out.22344
drwxr-xr-x 2 tibero dba 21 Apr 25 10:36 slog ---- 시스템로그
-rw-r--r-- 1 tibero dba 341550 Apr 25 10:40 system_init.log
-rw------- 1 tibero dba 1003 Sep 20 14:27 tbsvr.out.17821
-rw------- 1 tibero dba 0 Sep 21 10:49 tbsvr.out.18451
-rw------- 1 tibero dba 0 Sep 21 10:51 tbsvr.out.18969
-rw------- 1 tibero dba 0 Sep 21 10:54 tbsvr.out.19515
-rw------- 1 tibero dba 0 Apr 25 10:36 tbsvr.out.20837
-rw------- 1 tibero dba 0 Sep 20 14:34 tbsvr.out.21069
-rw------- 1 tibero dba 0 Apr 25 10:37 tbsvr.out.21409
-rw------- 1 tibero dba 0 Sep 20 10:51 tbsvr.out.2141
-rw------- 1 tibero dba 0 Sep 21 11:17 tbsvr.out.21566
-rw------- 1 tibero dba 0 Sep 21 11:22 tbsvr.out.22343
-rw------- 1 tibero dba 0 Sep 20 15:15 tbsvr.out.24502
-rw------- 1 tibero dba 0 Apr 25 10:40 tbsvr.out.25162
-rw------- 1 tibero dba 0 Apr 25 10:40 tbsvr.out.25476
-rw------- 1 tibero dba 0 Sep 20 15:40 tbsvr.out.26791
-rw------- 1 tibero dba 0 Sep 20 15:54 tbsvr.out.28214
cd slog
[tibero@T1:/tibero/tibero7/instance/tibero/log/slog]$ ls -la
total 11940
drwxr-xr-x 2 tibero dba 21 Apr 25 10:36 .
drwxr-xr-x 8 tibero dba 4096 Sep 21 11:33 ..
-rw-r--r-- 1 tibero dba 12219046 Sep 21 11:33 sys.log
[2023-09-21T11:22:40.454702] [CFD-44] [I] open (stat) failed (errno=2, No such file or directory) (flag=010002) (filename=/tibero/tbdata/data_1/log001.log)
[2023-09-21T11:22:40.454734] [CFD-44] [I] open (stat) failed (errno=2, No such file or directory) (flag=010002) (filename=/tibero/tbdata/data_1/log002.log)
[tibero@T1:/tibero/tbdata/data_1]$ mv log001.log_1 log001.log
[tibero@T1:/tibero/tbdata/data_1]$ mv log002.log_1 log002.log
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$ ls
EXAMPLE01.dtf KL01.dtf log002.log log004.log log006.log system001.dtf undo001.dtf usr001.dtf
java log001.log log003.log log005.log syssub001.dtf temp001.dtf USERS01.dtf
[tibero@T1:/tibero/tbdata/data_1]$ tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$
[tibero@T1:/tibero/tbdata/data_1]$ tbboot
Change core dump dir to /tibero/tibero7/bin/prof.
Listener port = 8629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
[tibero@T1:/tibero/tbdata/data_1]$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
1 row selected.
SQL> select status from v$instance;
STATUS
----------------
NORMAL
1 row selected.
정상기동 로그확인
# $TB_HOME/instance/$TB_SID/log/slog/sys.log
[tibero@T1:/tibero/tibero7/instance/tibero/log/slog]$ ls -la
tail -f sys.log
로그시작
[2023-09-21T11:33:56.434429] [FRM-00] [I] show OS info
[2023-09-21T11:33:56.434493] [FRM-00] [I] -----------------------------------------------------------------------------
[2023-09-21T11:33:56.436748] [FRM-00] [I] Linux T1 3.10.0-693.11.6.el7.x86_64 #1 SMP Thu Jan 4 01:06:37 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
[2023-09-21T11:33:56.436757] [FRM-00] [I] -----------------------------------------------------------------------------
[2023-09-21T11:33:56.436816] [FRM-00] [I] show tip [tibero.tip]
-----------------------------------------------------------------------------
파라미터파일 내용 표시됨
중략
RV master received CRASH_RECOVERY request
RV slave 2 received CRASH_RECOVERY job
1단계 cache recovery
DF ( 데이타 파일)
2단계 TX_RECOVERY
중략
Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
JOB REVIVAL: job id=3 ->> 시작이 완료된 상태의 로그/ 맨 마지막로그임
시작 - show OS info
마지막 - JOB REVIVAL
cat sys.log | grep "bootmode"
[tibero@T1:/tibero/tibero7/instance/tibero/log/slog]$ cat sys.log | grep "bootmode"
[2023-04-25T10:36:27.749528] [FRM-00] [I] Server is running at NOMOUNT mode (bootmode : NOMOUNT, bootflag : 0)
[2023-04-25T10:36:29.417426] [FRM-41] [I] Server is running at NOMOUNT mode (bootmode : NOMOUNT, bootflag : 0)
[2023-04-25T10:37:10.571215] [FRM-41] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-04-25T10:37:22.010759] [FRM-41] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-04-25T10:40:14.391495] [FRM-41] [I] Server is running at MOUNT mode (bootmode : MOUNT, bootflag : 0)
[2023-04-25T10:40:19.982971] [FRM-41] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-09-20T10:51:34.868439] [FRM-41] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-09-20T13:56:07.259835] [FRM-43] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-09-20T14:34:04.654735] [FRM-43] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-09-20T15:15:05.658053] [FRM-43] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-09-20T15:40:27.562207] [FRM-43] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-09-20T15:54:49.966165] [FRM-43] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-09-21T10:49:04.928939] [FRM-00] [I] Server is running at NOMOUNT mode (bootmode : NOMOUNT, bootflag : 0)
[2023-09-21T10:49:05.348635] [FRM-43] [I] Server is running at NOMOUNT mode (bootmode : NOMOUNT, bootflag : 0)
[2023-09-21T10:51:32.592344] [FRM-43] [I] Server is running at MOUNT mode (bootmode : MOUNT, bootflag : 0)
[2023-09-21T10:54:28.189153] [FRM-43] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-09-21T11:17:06.650094] [FRM-43] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
[2023-09-21T11:33:58.288717] [FRM-43] [I] Server is running at NORMAL mode (bootmode : NORMAL, bootflag : 0)
에러관련
[tibero@T1:/tibero/tibero7/instance/tibero/log/slog]$ cat sys.log | grep "THROW"
[2023-04-25T10:36:29.801727] [FRM-89] [I] THROW. ec=ERROR_CLIMSG_RESTRICTED_STMT(-12020) [ Unable to execute SQL statement.] (csr_id:0) [tbsvr_sql_process.c:245:tbsvr_sql_process]
[2023-04-25T10:37:17.303535] [FRM-19] [I] THROW. ec=ERROR_SESS_KILLED(-12001) [ Session has been closed.] (csr_id:4294967295) [bitqueue.c:514:bitq_read_dbginfo]
[2023-04-25T10:37:17.303566] [FRM-14] [I] THROW. ec=ERROR_SESS_KILLED(-12001) [ Session has been closed.] (csr_id:4294967295) [bitqueue.c:514:bitq_read_dbginfo]
[2023-04-25T10:37:17.303602] [FRM-17] [I] THROW. ec=ERROR_SESS_KILLED(-12001) [ Session has been closed.] (csr_id:4294967295) [bitqueue.c:514:bitq_read_dbginfo]
[2023-04-25T10:38:13.784750] [FRM-89] [I] THROW. ec=ERROR_DDL_INVALID_OBJ_NAME(-7071) [ Schema object 'SYS._AGENT_DUMMY' was not found or is invalid.] (csr_id:4294967295) [ddl_check_common.c:221:ddl_check_alter_drop_obj]
[2023-04-25T10:38:16.545282] [FRM-89] [I] THROW. ec=ERROR_DDL_INVALID_OBJ_NAME(-7071) [ Schema object 'SYS._VT_ACCESS' was not found or is invalid.] (csr_id:4294967295) [ddl_check_common.c:221:ddl_check_alter_drop_obj]
[2023-04-25T10:38:16.545541] [FRM-89] [I] THROW. ec=ERROR_DDL_INVALID_OBJ_NAME(-7071) [ Schema object 'SYS._VT_ACTIVE_SESSION_HISTORY' was not found or is invalid.] (csr_id:4294967295) [ddl_check_common.c:221:ddl_check_alter_drop_obj]
[tibero@T1:/home/tibero]$ tbdown -h
Usage: tbdown [-h] [-t DOWNMODE]
DOWNMODE : NORMAL, POST_TX, IMMEDIATE, ABORT, SWITCHOVER, ABNORMAL
## DB SESSION 존재 상황에서 normal 사용
[tibero@T1:/home/tibero]$ tbdown normal
^C
[tibero@T1:/home/tibero]$ tbdown normal
TBR-12039: Server instance is shutting down.
tbdown failed to receive greeting.
tbdown post_tx --> 세션은 끊어 버리고 트랜잭션은 끝날때까지 기다린다
create table tibero.a(c1 number);
insert into tibero.a values(1);
insert into a values(3);
select * from v$transaction;
## 트랜젝션 존재시 immediate 모드 사용 -- 롤백수행후 다운됨
create table tibero.a(c1 number);
insert into tibero.a values(1);
insert into a values(3);
select * from v$transaction;
## 트랜젝션 존재시 abort 사용 ( 대기않함, 복구 필요) - recovery 할때 롤백수행
insert into tibero.a values(1); 100만건 수행
insert into a values(3);
select * from v$transaction;
CRASH_RECOVERY 수행
데이타베이스 오픈되고 나중에 TX RECOVERY
TX_RECOVERY_DONE
#### ABNORMAL 사용 종료 ( 대기하지 않음-abort, 복구필요 - abort, 종료 로그 없음)
tail -f sys.log &
tbdown abnormal - 프로세서 kill 로 죽이므로 로그안찍힘
### 종료 모드에서 로그 차이점
abort 종료 - mode[4]:ABORT
abnormal 종료
immediate 종료 - mode[3]:IMMEDIATE , check hotbackup ( 핫백업중일때 안내려감)
, checkpoint 수행 (메모리데이타 파일로 저장) - shutdowm immediate 로 내려야 된다 (문제발생 방지)
normal 종료 -- mode[1]:NORMAL
tbdown clean
BOOT_WITH_AUTO_DOWN_CLEAN 파라미터 사용하면 자동으로 정리
SQL> show parameter BOOT_WITH_AUTO
NAME TYPE VALUE
---------------------------- -------- ----------------------------------------
BOOT_WITH_AUTO_DOWN_CLEAN Y_N YES
파라미터 파일에서 tbdown clean 관련 파라미터 확인후 기본값을 변경시 tibero.tip 수정
티베로7에서는 기본값이 YES
티베로6,5에서는 기본값이 NO
tbdown clean 관련 파일 .proc.list - tbbot 할때 만들어짐
# $TB_HOME/instance/$TB_SID/.proc.list
[tibero@T1:/tibero/tibero7/instance/tibero]$ cat .proc.list
Tibero 7 start at (2023-09-21 15:10:08) by 1000
shared memory: 140144812744704 size: 2147483648
shm_key: 888124518 1 sem_key: -1826191751 227 listener_pid: 9107 listener_port: 8629 listener_special_port: 8630 epa_pid: -1
9106 MONP
9108 MGWP
9109 FGWP0000
9110 FGWP0001
9111 FGWP0002
9112 BGWP0003
9113 PEWP0000
9114 PEWP0001
9115 PEWP0002
9116 PEWP0003
9117 PEWP0004
9118 PEWP0005
9119 AGNT
9120 DBWR
9121 RCWP
## 인스턴스 종료시 .proc.list 파일 자동 제거됨
tbdown
[tibero@T1:/tibero/tibero7/instance/tibero]$ ls -la .proc.list
ls: cannot access .proc.list: No such file or directory
tbboot
[tibero@T1:/tibero/tibero7/instance/tibero]$ ls -la .proc.list
-rw-r--r-- 1 tibero dba 429 Sep 21 15:31 .proc.list
[tibero@T1:/tibero/tibero7/instance/tibero]$ cat .proc.list
Tibero 7 start at (2023-09-21 15:31:41) by 1000
shared memory: 140619409342464 size: 2147483648
shm_key: 888124518 1 sem_key: -1826191751 227 listener_pid: 11052 listener_port: 8629 listener_special_port: 8630 epa_pid: -1
11051 MONP
11053 MGWP
11054 FGWP0000
11055 FGWP0001
11056 FGWP0002
11057 BGWP0003
11058 PEWP0000
11059 PEWP0001
11060 PEWP0002
11061 PEWP0003
11062 PEWP0004
11063 PEWP0005
11064 AGNT
11065 DBWR
11066 RCWP
## .proc.list 내용 출력하는 명령어
tbdown pid
[tibero@T1:/tibero/tibero7/instance/tibero]$ tbdown pid
11051: MONP
11053: MGWP
11054: FGWP0000
11055: FGWP0001
11056: FGWP0002
11057: BGWP0003
11058: PEWP0000
11059: PEWP0001
11060: PEWP0002
11061: PEWP0003
11062: PEWP0004
11063: PEWP0005
11064: AGNT
11065: DBWR
11066: RCWP
만들어진 이유?
tbdown 할때 .proc.list 읽어서 종료처리
만약 .proc.list 없어지면 종료안됨 , 에러
###.proc.list 숨기고 , tbdown 실행하기 ( 에러 발생 )
[tibero@T1:/tibero/tibero7/instance/tibero]$ tbdown pid
info file is deleted.
[tibero@T1:/tibero/tibero7/instance/tibero]$ tbdown immediate
tbdown failed. proc info file is deleted.
Hint: Please check if the tbsvr instance was already stopped.
### tbsql 툴의 tbdown 옵션 사용
[tibero@T1:/tibero/tibero7/instance/tibero]$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> help tbdown
TBDOWN
-------------
Terminates instance.
TBDOWN [mode]
where mode is
NORMAL
POST_TX
IMMEDIATE
ABORT
SQL> tbdown immediate
tbboot 하면 .proc.list 이 생김
.proc.list.abnormal.6525는 tbdown abnormal 로 했을때 저장
SQL> CREATE BTIP FROM TIP;
SQL> CREATE BTIP='PATH' FROM TIP;
QL> ALTER SYSTEM SET PARAMETER1 = NEW_VALUE SCOPE BTIP ;
...PARAMETER1의 변경된 값 NEW_VALUE는 BTIP에만 반영하여
...다음 부팅부터 PARAMETER1의 값은 NEW_VALUE로 동작한다.
...DDL 구문 수행 후 PARAMETER1의 값은 OLD_VALUE이다.
SQL> ALTER SYSTEM SET PARAMETER1 = NEW_VALUE SCOPE MEMORY ;
...PARAMETER1의 변경된 값 NEW_VALUE는 운영 중인 시점에만 반영하고
...다음 부팅시 PARAMETER1의 값은 OLD_VALUE이다.
SQL> ALTER SYSTEM SET PARAMETER1 = NEW_VALUE SCOPE BOTH ;
...PARAMETER1의 변경된 값 NEW_VALUE는 운영 시점과 BTIP 모두 반영하며
...다음 부팅시 PARAMETER1의 값은 NEW_VALUE이다.
...DDL 구문 수행 후 PARAMETER1의 값도 NEW_VALUE이다.
### btip 만들기
[tibero@T1:/tibero/tibero7/instance/tibero]$ !tbsql
tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> CREATE BTIP FROM TIP;
BTIP created.
[tibero@T1:/tibero/tibero7/config]$ ls -la tibero.btip
-rw------- 1 tibero dba 90164 Sep 21 15:54 tibero.btip
[tibero@T1:/tibero/tibero7/config]$ ls -la tibero.tip
-rw-r--r-- 1 tibero dba 883 Sep 20 15:54 tibero.tip
사용할려면 재시작해야됨
btip이 우선순위 높음
BTIP_FILE_PATH 를 추가 설정
티베로 버젼에 따라서 다름
6버젼은 설정없이도 btip
tbcfgv 로 추가
BTIP_FILE_PATH=/tibero/tibero7/config
[tibero@T1:/tibero/tibero7/config]$ !tbsql
tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> SELECT TIP_FILE FROM V$INSTANCE;
TIP_FILE
--------------------------------------------------------------------------------
/tibero/tibero7/config/tibero.tip
1 row selected.
[tibero@T1:/tibero/tibero7/config]$ cat tibero.tip
BTIP_FILE_PATH=/tibero/tibero7/config/tibero.btip
기존내용 전부 지움
[tibero@T1:/tibero/tibero7/config]$ !tbsql
tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> SELECT TIP_FILE FROM V$INSTANCE;
TIP_FILE
--------------------------------------------------------------------------------
/tibero/tibero7/config/tibero.btip
1 row selected.
SQL>
SQL> -- 최대 세션 갯수를 60개로 설정하기
SQL> ALTER SYSTEM SET MAX_SESSION_COUNT = 60 SCOPE=BTIP ;
ALTER SYSTEM SET MAX_SESSION_COUNT = 60 SCOPE=BTIP ;
[2023-09-21T16:28:27.446635] [DDL-91] [I] DDL execution succeeded
System altered.
SQL>
메뉴얼에 "=" 빠짐 ( SCOPE=BTIP ;)
tibero 16800 16796 0 16:29 pts/2 00:00:00 tbsvr_FGWP000 -t NORMAL -SVR_SID tibero
tibero 16801 16796 0 16:29 pts/2 00:00:00 tbsvr_FGWP001 -t NORMAL -SVR_SID tibero
tibero 16802 16796 0 16:29 pts/2 00:00:00 tbsvr_FGWP002 -t NORMAL -SVR_SID tibero
tibero 16803 16796 0 16:29 pts/2 00:00:00 tbsvr_FGWP003 -t NORMAL -SVR_SID tibero
tibero 16804 16796 0 16:29 pts/2 00:00:00 tbsvr_FGWP004 -t NORMAL -SVR_SID tibero
tibero 16805 16796 0 16:29 pts/2 00:00:00 tbsvr_BGWP005 -t NORMAL -SVR_SID tibero
[tibero@T1:/tibero/tibero7/config]$ tbdown pid
16796: MONP
16799: MGWP
16800: FGWP0000 10
16801: FGWP0001 10
16802: FGWP0002 10
16803: FGWP0003 10
16804: FGWP0004 10
16805: BGWP0005 10
16806: PEWP0000
16807: PEWP0001
16808: PEWP0002
16809: PEWP0003
16810: PEWP0004
16811: PEWP0005
16812: AGNT
16813: DBWR
16814: RCWP
토탈 60개로 설정됨
SQL> show parameter max
NLS_DATE_FORMAT 파라미터의 CLASS 조회
SQL> select * from VT_PARAMETER WHERE NAME='NLS_DATE_FORMAT';
NAME TYPE
---------------------------------------------------------------- --------
DFLT_VALUE
--------------------------------------------------------------------------------
IS_OPTIONAL IS_ADJUSTABLE IS_DYNAMIC IS_HIDDEN BOUND GLOBAL
----------- ------------- ---------- ---------- -------- --------
VALUE
--------------------------------------------------------------------------------
STATUS
----------------
RANGE
--------------------------------------------------------------------------------
NLS_DATE_FORMAT STRING
YYYY/MM/DD
1 1 1 0 SESS BOTH
YYYY/MM/DD HH24:MI:SS
TIP_MODIFIED
Any valid date format mask up to 64 characters in length
1 row selected.
BOTH --
-------------------------------------------------------------------------------
controlfile 조회
SQL> select * from v$controlfile;
STATUS
----------
NAME
--------------------------------------------------------------------------------
BLKSIZE BLOCKS
---------- ----------
0
/tibero/tbdata/control_2/c2.ctl
16384 4645
0
/tibero/tbdata/control_2/c2.ctl
16384 4645
2 rows selected.
[tibero@T1:/tibero/tibero7/config]$ mv tibero.tip tibero.tip.org
[tibero@T1:/tibero/tibero7/config]$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> create tip from btip;
TIP created.
SQL>
중지후
[tibero@T1:/tibero/tibero7/config]$ cat tibero.tip
"DB_NAME"="tibero"
"LOG_DEFAULT_DEST"="/tibero/tibero7/instance/tibero/log/"
"LISTENER_PORT"=8629
"LSNR_LOG_FILE_SIZE"=10485760
"LSNR_LOG_TOTAL_SIZE_LIMIT"=314572800
"EXTRA_LISTENER_PORTS"="8639;8640;"
"DB_CREATE_FILE_DEST"="/tibero/tbdata/data_1/"
"MAX_SESSION_COUNT"=60
"MAX_BG_SESSION_COUNT"=10
"MEMORY_TARGET"=3221225472
"TOTAL_SHM_SIZE"=2147483648
"DBMS_LOG_FILE_SIZE"=104857600
"SLOG_FILE_SIZE"=104857600
"SLOG_TOTAL_SIZE_LIMIT"=314572800
"DBMS_LOG_TOTAL_SIZE_LIMIT"=314572800
"ILOG_FILE_SIZE"=10485760
"ILOG_TOTAL_SIZE_LIMIT"=734003200
"LOG_ARCHIVE_DEST"="/tibero/tbdata/arch/"
"NLS_DATE_FORMAT"="YYYY/MM/DD HH24:MI:SS"
#"BTIP_FILE_PATH"="/tibero/tibero7/config/tibero.btip"
"GATHER_SQL_PLAN_STAT"="Y"
"CONTROL_FILES"="/tibero/tbdata/control_2/c2.ctl","/tibero/tbdata/control_2/c2.ctl"
재기동
[tibero@T1:/tibero/tibero7/config]$ !tbsql
tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL>
SQL>
SQL> SELECT TIP_FILE FROM V$INSTANCE;
TIP_FILE
--------------------------------------------------------------------------------
/tibero/tibero7/config/tibero.tip
1 row selected.
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/tibero/tbdata/control_1/c1.ctl
/tibero/tbdata/control_2/c2.ctl
2 rows selected.
댓글 0
| 번호 | 제목 | 날짜 | 조회 수 |
|---|---|---|---|
| 170 | 급증하는 키싱(Qishing) 공격 | 2023.11.14 | 112 |
| 169 | tibero 7 install for linux | 2023.11.06 | 169 |
| 168 |
Red Hat Enterprise Linux Certification Matrix for Dell PowerEdge Servers
 | 2023.11.02 | 70 |
| 167 |
Tibero test sql문, SCHEMA_OBJECT_SAMPLE
| 2023.10.25 | 112 |
| 166 | Tibero 관리 3 | 2023.10.25 | 562 |
| » | Tibero 관리 2 | 2023.10.25 | 145 |
| 164 | Tibero 접속 및 관리 | 2023.10.25 | 189 |
| 163 |
Jeus 8.5 + WebtoB 연동및 운영
| 2023.10.24 | 156 |
| 162 |
Jeus 8.5 설치및 운영
| 2023.10.24 | 230 |
| 161 |
Webtob Install for Windows and command
| 2023.10.24 | 156 |
| 160 |
Webtob Install for Linux
| 2023.10.23 | 193 |
| 159 |
HPUX Apache 2.4.53 다운로드 및 설치
| 2022.07.20 | 131 |
| 158 |
qlogic qaucli command - HBA카드 온도체크
| 2022.07.05 | 1465 |
| 157 |
2021년도 주요정보통신기반시설 기술적 취약점 분석ㆍ평가 방법 상세가이드
| 2022.06.23 | 139 |
| 156 |
Apache Log4j 취약점및 대응방안
| 2022.02.05 | 102 |
