현상
OS 시간대와 DB 시간대가 달라 OS timezone 변경하였으나 DB에 반영되지 않는 현상을 설명합니다.
참고
OS timezone 과 DB time은 Linux 기준 적용
원인
Tibero는 설치 시점의 OS timezone을 읽기 때문입니다. 그렇기에 설치 이후에 OS에서 변경하여도 DB에는 반영되지 않게 됩니다.
해결
Control file 재 생성하여 변경된 timezone을 읽도록 조치해야 합니다.
1.
Control file backup문 생성
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> alter database backup controlfile to trace as 'ctl_bak.sql' reuse noresetlogs;
Database altered.
SQL
복사
2.
nomount 모드로 부팅 후 Control file 재생성
[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbboot nomount
Change core dump dir to /sdiske/ps1/tuning/tibero7/bin/prof.
Listener port = 1188
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NOMOUNT mode).
[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> @ctl_bak.sql
Control File created.
SQL> quit
Disconnected.
SQL
복사
3.
mount 모드로 부팅 후 media recovery 진행
[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbdown immediate
Tibero instance terminated (IMMEDIATE mode).
[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbboot mount
Change core dump dir to /sdiske/ps1/tuning/tibero7/bin/prof.
Listener port = 1188
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> alter database recover automatic;
Database altered.
SQL> quit
Disconnected.
SQL
복사
4.
normal 모드로 부팅 후 temp file 재생성
[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbboot
Change core dump dir to /sdiske/ps1/tuning/tibero7/bin/prof.
Listener port = 1188
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/sdiske/ps1/tuning/tbdata/temp001.dtf' SIZE 7332M REUSE AUTOEXTEND ON NEXT 16M MAXSIZE 32G;
Tablespace 'TEMP' altered.
SQL
복사