문서유형ㅣ장애해결
분야ㅣ관리/환경설정
적용제품버전ㅣ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.