주 콘텐츠로 건너뛰기

검색

Welcome to Tibero GTS!

OS timezone 변경 시 DB 미반영 현상

문서유형ㅣ장애해결 

분야ㅣ관리/환경설정

적용제품버전ㅣ5SP1FS01, 5SP1FS02, 5SP1FS03, 5SP1FS04, 5SP1FS06, 6FS01, 6FS02, 6FS03, 6FS04, 6FS05, 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS

문서번호ㅣTADTS046

 

현상

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.

 

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.

 

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.

 

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.

 

 
 

관련 대상