문서유형ㅣ기술정보
분야ㅣ백업/복구
적용제품버전ㅣ7FS02PS
문서번호ㅣTBATI039
개요
BCT
Block Change Tracking 의 약자로, tbrmgr로 full backup 수행 후 incremental backup을 수행 할 때 변경된 블락만을 백업하는 방법입니다.
redo buffer를 읽어서 블락이 변경이 될 때마다 BCT 파일에 변경 이력을 bitmap으로 남기게 됩니다.
incremental backup 수행시 해당 bitmap을 참조하여 전체 블락이 아닌 변경 블락만을 빠르게 백업하게 됩니다.
관련 파라미터
$TB_HOME/config/$TB_SID.tip에 설정BLOCK_CHANGE_TRACKING파라미터에 BCT 파일의 절대 경로로 설정ex) BLOCK_CHANGE_TRACKING=/home/t/tbdata/tibero.bct
관련 명령어
- BCT 기능 활성화:
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING; - BCT 기능 비활성화:
ALTER SYSTEM DISABLE BLOCK CHANGE TRACKING;
방법
테스트 시나리오
$TB_SID.tip 수정
...
BLOCK_CHANGE_TRACKING=/home/tibero/tibero7/block/tibero.bct
BCT 활성화 및 활성화 확인
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;명령어로 BCT 활성화_vt_bct에서 ENABLED 컬럼의 값이 1이면 BCT 활성화, 0이면 비활성화
$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> select * from _vt_bct;
ENABLED SET_ID CUR_SET_ID REQ_TSN
---------- ---------- ---------- ----------
0 0 0 170649
0 1 0 170597
2 rows selected.
SQL> ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
System altered.
SQL> select * from _vt_bct;
ENABLED SET_ID CUR_SET_ID REQ_TSN
---------- ---------- ---------- ----------
1 0 0 172019
1 1 0 170597
2 rows selected.
full backup 진행
$ tbrmgr backup -o /home/tibero/tibero7/block/backup
==============================================================================
= Recovery Manager(RMGR) starts =
= =
= TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /home/tibero/tibero7/block/backup
==============================================================================
RMGR - Backup (FULL)
==============================================================================
Initializing the backup progress, it may take few minutes...
BACKUP (set_id: 4, ts_id: 0, df_id: 0)
100.0% |===============================>| 13568/13568 blks 0.00s
Synchronizing...
BACKUP (set_id: 4, ts_id: 1, df_id: 1)
100.0% |===============================>| 13056/13056 blks 0.00s
Synchronizing...
BACKUP (set_id: 4, ts_id: 3, df_id: 2)
100.0% |===============================>| 1280/1280 blks 0.00s
Synchronizing...
BACKUP (set_id: 4, ts_id: 4, df_id: 3)
100.0% |===============================>| 2560/2560 blks 0.00s
Synchronizing...
Switching an online logfile...
Backing up the control file...
Control file backup succeeded
Database backup succeeded
RMGR backup ends
incremental backup 진행
$ tbrmgr backup -i -o /home/tibero/tibero7/block/backup2
==============================================================================
= Recovery Manager(RMGR) starts =
= =
= TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /home/tibero/tibero7/block/backup2
==============================================================================
RMGR - Backup (INCREMENTAL)
==============================================================================
Initializing the backup progress, it may take few minutes...
BACKUP (set_id: 3, ts_id: 0, df_id: 0)
100.0% |===============================>| 269/269 blks 0.00s
Synchronizing...
BACKUP (set_id: 3, ts_id: 1, df_id: 1)
100.0% |===============================>| 1056/1056 blks 0.00s
Synchronizing...
BACKUP (set_id: 3, ts_id: 3, df_id: 2)
100.0% |===============================>| 2/2 blks 0.00s
Synchronizing...
BACKUP (set_id: 3, ts_id: 4, df_id: 3)
100.0% |===============================>| 916/916 blks 0.00s
Synchronizing...
Switching an online logfile...
Backing up the control file...
Control file backup succeeded
Database backup succeeded
RMGR backup ends