주 콘텐츠로 건너뛰기
📓 Tibero Online Manual Click here 📓

검색

Welcome to Tibero GTS!

TTA BMT 기능 검증 시나리오(SINGLE 구성) - 백업/복구

문서유형ㅣ기술정보

분야ㅣ관리/환경설정 

적용제품버전ㅣTibero5, Tibero6 , Tibero7

문서번호ㅣTADTI215

 

개요

SINGLE 환경에서 백업 및 복구 기능의 정상 동작 여부를 검증하기 위한 BMT 시나리오를 기술한다.

 
 

방법

온라인 백업 후 완전 복구 기능

 

수행

수행 순서시나리오
1

테스트용 데이터 생성

  • 테이블 스페이스 생성
  • 테스트 유저 및 테이블 생성
 2

사전 확인

  • 테이블 건수 회
  • 테이블 스페이스 확인
  • 데이터 확인
 3Begin Backup 수행 및 확인
 4핫 백업 진행
 5End Backup 수행 및 로그 스위치 수행
 6데이터 입력 및 로그 스위치
 7 데이터 조회
 8티베로 종료 및 데이터 파일 전체 삭제
 9티베로 기동하여 마운트 모드 및 장애 상황 확인
 10티베로 종료 및 핫 백업 원복
 11티베로 마운트 모트 기동 및 복구 수행
 12티베로 기동
 13테이블 건수 조회

 

결과

수행 순서시나리오
1

테스트용 데이터 생성

  • 테이블 스페이스 생성
  • 테스트 유저 및 테이블 생성

tbsql sys/tibero

 

CREATE TABLESPACE TS_TEST DATAFILE 'test001.dtf' SIZE 16M AUTOEXTEND ON NEXT 16M MAXSIZE 1G, 'test002.dtf' SIZE 16M AUTOEXTEND ON NEXT 16M MAXSIZE 1G EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

Tablespace 'TS_TEST' created.

 

CREATE TABLESPACE TS_TEST_IDX DATAFILE 'test_idx_001.dtf' SIZE 8M AUTOEXTEND ON NEXT 8M MAXSIZE 1G EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

Tablespace 'TS_TEST_IDX' created.

 

CREATE USER TEST IDENTIFIED BY TEST DEFAULT TABLESPACE TS_TEST;

User 'TEST' created.


grant dba to test;

Granted.
 

conn test/test
Connected to Tibero.

 

CREATE TABLE TEST.T1 (ID NUMBER,ANAME VARCHAR2(32),BNAME VARCHAR2(32),ID2 NUMBER) TABLESPACE TS_TEST;

Table 'TEST.T1' created.
 

CREATE INDEX IDX_T1 ON T1(ID, ANAME) TABLESPACE TS_TEST_IDX;

Index 'IDX_T1' created.

 2

사전 확인

  • 테이블 건수 회
  • 테이블 스페이스 확인
  • 데이터 확인

select count(*) from test.t1;

 COUNT(*)
----------
        0

1 row selected.

 

SELECT TABLESPACE_NAME FROM DBA_TABLESPACES;

TABLESPACE_NAME
----------------------
SYSTEM
UNDO
TEMP
USR
SYSSUB
TS_TEST
TS_TEST_IDX

 

select file_name from dba_data_files;

FILE_NAME
--------------
/tibero/data/system/system001.dtf
/tibero/data/system/usr001.dtf
/tibero/data/system/tpr_ts.dtf
/tibero/data/test001.dtf
/tibero/data/test002.dtf
/tibero/data/test_idx_001.dtf
/tibero/data/undo001.dtf

 

select name from v$controlfile;

NAME
-----------------------------
/tibero/data/tbctl1/c1.ctl
/tibero/data/tbctl2/c2.ctl
 

 3Begin Backup 수행 및 확인

ALTER DATABASE BEGIN BACKUP;

Database altered.
 

SELECT * FROM V$BACKUP;

     FILE# STATUS        CHANGE# TIME
---------- ---------- ---------- ----------------------------------------
        0 ACTIVE         368580 2025/12/05
        1 ACTIVE         368582 2025/12/05
        2 ACTIVE         368584 2025/12/05
        3 ACTIVE         368586 2025/12/05
        4 ACTIVE         368588 2025/12/05
        5 ACTIVE         368590 2025/12/05
        6 ACTIVE         368592 2025/12/05


7 rows selected.

exit
Disconnected.
 

 4핫 백업 진행

mkdir /tibero/data_bak

cp -Rp /tibero/data/system001.dtf     /tibero/data_bak/. 
cp -Rp /tibero/data/system002.dtf     /tibero/data_bak/.
cp -Rp /tibero/data/usr001.dtf        /tibero/data_bak/.
cp -Rp /tibero/data/syssub001.dtf     /tibero/data_bak/.
cp -Rp /tibero/data/test001.dtf       /tibero/data_bak/.
cp -Rp /tibero/data/test002.dtf       /tibero/data_bak/.
cp -Rp /tibero/data/test_idx_001.dtf  /tibero/data_bak/.
cp -Rp /tibero/data/undo001.dtf       /tibero/data_bak/.

cp -Rp /tibero/data/tbctl1 /tibero/data_bak/.
cp -Rp /tibero/data/tbctl2 /tibero/data_bak/.

 5End Backup 수행 및 로그 스위치 수행

tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

 

alter database end backup;

Database altered.

 

alter system switch logfile;

System altered.

 

alter system switch logfile;

System altered.

 

alter system switch logfile;

System altered.

 

SELECT * FROM V$BACKUP;

     FILE# STATUS        CHANGE# TIME
---------- ---------- ---------- ------------------------------
        0 NOT ACTIVE      93048 2025/12/09
        1 NOT ACTIVE      93050 2025/12/09
        2 NOT ACTIVE      93052 2025/12/09
        3 NOT ACTIVE      93054 2025/12/09
        4 NOT ACTIVE      93048 2025/12/09
        5 NOT ACTIVE      93056 2025/12/09
        6 NOT ACTIVE      93056 2025/12/09
        7 NOT ACTIVE      93058 2025/12/09
 

 6데이터 입력 및 로그 스치

INSERT INTO TEST.T1 SELECT ROWNUM, 'A'||TO_CHAR(ROWNUM), 'B'||TO_CHAR(ROWNUM),ROUND(ROWNUM/50) FROM DUAL CONNECT BY ROWNUM<=50000;

50000 rows inserted.
 

commit;

Commit completed.

 

alter system switch logfile;

System altered.

 7 데이터 조회

SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
    50000

1 row selected.

 8티베로 종료 및 데이터 파일 전체 삭제

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

rm -rf /tibero/data

 9티베로 기동하여 마운트 모드 및 장애 상황 확인

tbboot
Change core dump dir to /home/tibero/tibero7/bin/prof.

Listener port = 8629

********************************************************
* Critical Warning : Raise svmode failed. The reason is
*   TBR-1024 :  Database needs media recovery: file needs end backup, media recovery required in MOUNT mode(/tibero/data/system001.dtf).
*   Current server mode is MOUNT.
********************************************************


Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started suspended at MOUNT mode.

 10

티베로 종료 및 핫 백업 원복

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

cp -Rp /tibero/data_bak/system001.dtf     /tibero/data/. 
cp -Rp /tibero/data_bak/system002.dtf     /tibero/data/.
cp -Rp /tibero/data_bak/usr001.dtf        /tibero/data/.
cp -Rp /tibero/data_bak/syssub001.dtf     /tibero/data/.
cp -Rp /tibero/data_bak/test001.dtf       /tibero/data/.
cp -Rp /tibero/data_bak/test002.dtf       /tibero/data/.
cp -Rp /tibero/data_bak/test_idx_001.dtf  /tibero/data/.
cp -Rp /tibero/data_bak/undo001.dtf       /tibero/data/.

 11티베로 마운트 모트 기동 및 복구 수행

tbboot mount
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
  

tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

 

alter database recover automatic;

Database altered.

 

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 12티베로 기동

tbboot
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

 13테이블 건수 조회

SELECT COUNT(*) FROM TEST.T1;

COUNT(*)
----------
   50000

1 row selected.

 

오프라인 백업(콜드 백업) 후 완전 복구 기능

 

수행

수행 순서시나리오
 1

백업 대상 확인

- 컨트롤 파일, 리두 로그, 데이터 파일, 템프 파일

 2테이블 건수 조회
 3티베로 종료 및 콜드 백업 실행
 4티베로 기동
 5데이터 입력
 6데이터 조회
 7티베로 종료 및 데이터 파일 전체 삭제
 8티베로 모드 및 장애 상황 확인
 9티베로 종료 및 콜드 백업 파일 원복
 10티베로 기동 및 복구 수행
 11티베로 종료 및 티베로 기동
12테이블 건수 조회

 

결과

수행 순서시나리오
 1

백업 대상 확인

- 컨트롤 파일, 리두 로그, 데이터 파일, 템프 파일

tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

 

SELECT NAME FROM V$CONTROLFILE;

NAME
-------------------------------
/tibero/data/tbctl1/c1.ctl
/tibero/data/tbctl2/c2.ctl

2 rows selected.

 

SELECT MEMBER FROM V$LOGFILE;

MEMBER
-------------------------------
/tibero/data/redo001.redo
/tibero/data/redo011.redo
/tibero/data/redo021.redo

3 rows selected.

 

SELECT FILE_NAME FROM DBA_DATAFILES;

FILE_NAME
-------------------------------
/tibero/data/system001.dtf
/tibero/data/system002.dtf
/tibero/data/usr001.dtf
/tibero/data/syssub001.dtf
/tibero/data/test001.dtf
/tibero/data/test002.dtf
/tibero/data/test_idx_001.dtf
/tibero/data/undo001.dtf

8 rows selected.

 

SELECT FILE_NAME FROM DBA_TEMP_FILES;

FILE_NAME
-------------------------------
/tibero/data/temp001.dtf

1 row selected.

 2테이블 건수 조회

SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
    50000

 3

티베로 종료 및 콜드 백업 실행

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

cp -Rp /tibero/data /tibero/data_cold_backup

 

 4티베로 기동

tbboot
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

 5데이터 입력

tbsql test/test

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

 

INSERT INTO TEST.T1 SELECT ROWNUM, 'A'||TO_CHAR(ROWNUM), 'B'||TO_CHAR(ROWNUM),ROUND(ROWNUM/50) FROM DUAL CONNECT BY ROWNUM<=50000;

50000 rows inserted.

 

commit;

Commit completed.

 6데이터 조회

SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   100000
1 row selected.

 7티베로 종료 및 데이터 파일 전체 삭제

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

rm -rf /tibero/data

 8티베로 기동하여 티베로 모드 및 장애 상황 확인

tbboot
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

********************************************************
* Critical Warning : Raise svmode failed. The reason is
*   TBR-24001 :  Unable to open control file.
*   Current server mode is NOMOUNT.
********************************************************


Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started suspended at NOMOUNT mode.

 9티베로 종료 및 콜드 백업 파일 원복

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

mv /tibero/data_cold_backup /tibero/data

 10티베로 기동 및 복구 수행
 

tbboot mount
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
 

tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

 

alter database recover automatic;

Database altered.

 11티베로 종료 및 티베로 기동
 

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

tbboot
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

12테이블 건수 조회

select count(*) from test.t1;

 COUNT(*)
----------
    50000

 

매체 복구 (Media Recovery) 기능

 

수행

수행 순서시나리오
1테이블 건수 조회
2Begin Backup 수행
3핫 백업 진행
4End Backup 수행 및 로그 스위치 수행
5Sysdate 조회
6데이터 입력
7테이블 건수 조회
8컨트롤 파일 백업 및 로그 스위치 수행
9티베로 종료 및 데이터 파일 전체 삭제(Redo Log 까지)
10티베로 기동하여 마운트 모드 및 장애 상황 확인
11티베로 종료 및 핫 백업 원복
12노마운트 기동 및 컨트롤 파일 복구
13티베로 마운트 모드 기동 및 복구 수행
14티베로 종료
15티베로 기동 및 복구 마무리
16건수 확인

 

결과

수행 순서시나리오
1테이블 건수 조회

select count(*) from test.t1;

 COUNT(*)
----------
   100000

2Begin Backup 수행

alter database begin backup;

Database altered.

3핫 백업 진행

cp /tibero/data/*.dtf /tibero/data_bak/.

 

tibero@localhost /tibero/data_bak ➤ ls -alrt
total 561364
drwxr-xr-x. 9 tibero dba      4096 Dec 12 17:04 ..
-rw-------. 1 tibero dba 104857600 Dec 12 17:05 syssub001.dtf
-rw-------. 1 tibero dba 104857600 Dec 12 17:05 system001.dtf
-rw-------. 1 tibero dba 104857600 Dec 12 17:05 temp001.dtf
-rw-------. 1 tibero dba  16777216 Dec 12 17:05 test001.dtf
-rw-------. 1 tibero dba  16777216 Dec 12 17:05 test002.dtf
-rw-------. 1 tibero dba  16777216 Dec 12 17:05 test_idx_001.dtf
-rw-------. 1 tibero dba 209715200 Dec 12 17:05 undo001.dtf
drwxr-xr-x. 2 tibero dba      4096 Dec 12 17:05 .
-rw-------. 1 tibero dba 104857600 Dec 12 17:05 usr001.dtf

4End Backup 수행 및 로그 스위치 수행

tibero@localhost ~ ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> alter database end backup;

Database altered.

 

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

5Sysdate 조회

SQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS';

Session altered.


SQL> SELECT SYSDATE FROM DUAL;

SYSDATE
---------------------
2025/12/12 17:08:18

1 row selected.

6데이터 입력

SQL> INSERT INTO TEST.T1 (ID) VALUES ('444444');

1 row inserted.

 

SQL> commit;

Commit completed.

7테이블 건수 조회

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   100001

8컨트롤 파일 백업 및 로그 스위치 수행
 

SQL> alter database backup controlfile to trace as '/home/tibero/ctl_bak.sql' reuse resetlogs;

Database altered.

 

SQL> alter system switch logfile;

System altered.
 

SQL> alter system switch logfile;

System altered.
 

SQL> alter system switch logfile;

System altered.

 

SQL> exit
Disconnected.

9티베로 종료 및 데이터 파일 전체 삭제(Redo Log 까지)
 tibero@localhost /tibero/data  ➤ rm -rf *dtf *.ctl *.log

tibero@localhost /tibero/data  ➤ ls -alrt
total 16
drwx------. 3 tibero dba 4096 Dec 12 14:57 java
drwxr-xr-x. 9 tibero dba 4096 Dec 12 17:04 ..
-rw-r--r--. 1 tibero dba   88 Dec 12 17:13 .passwd
drwxr-xr-x. 3 tibero dba 4096 Dec 12 17:13 .
10티베로 기동하여 모드 및 장애 상황 확인

tibero@localhost ~ ➤ tbboot
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

********************************************************
* Critical Warning : Raise svmode failed. The reason is
*   TBR-24001 :  Unable to open control file.
*   Current server mode is NOMOUNT.
********************************************************


Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started suspended at NOMOUNT mode.

11티베로 종료 및 핫 백업본 리스토어

tibero@localhost ~ ➤ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

tibero@localhost /tibero  ➤ cp /tibero/data_bak/*.dtf /tibero/data/.
tibero@localhost /tibero  ➤ ls -alrt /tibero/data/.
total 561376
drwx------. 3 tibero dba      4096 Dec 12 14:57 java
drwxr-xr-x. 9 tibero dba      4096 Dec 12 17:04 ..
-rw-r--r--. 1 tibero dba        88 Dec 12 17:13 .passwd
-rw-------. 1 tibero dba 104857600 Dec 12 17:18 syssub001.dtf
-rw-------. 1 tibero dba 104857600 Dec 12 17:18 temp001.dtf
-rw-------. 1 tibero dba 104857600 Dec 12 17:18 system001.dtf
-rw-------. 1 tibero dba  16777216 Dec 12 17:18 test001.dtf
-rw-------. 1 tibero dba  16777216 Dec 12 17:18 test002.dtf
-rw-------. 1 tibero dba  16777216 Dec 12 17:18 test_idx_001.dtf
-rw-------. 1 tibero dba 209715200 Dec 12 17:18 undo001.dtf
drwxr-xr-x. 3 tibero dba      4096 Dec 12 17:18 .
-rw-------. 1 tibero dba 104857600 Dec 12 17:18 usr001.dtf

12노마운트 기동 및 컨트롤 파일 복구

tibero@localhost /tibero  ➤ tbboot nomount
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NOMOUNT mode).

 

vi /home/tibero/ctl_bak.sql ➤ ---- Set #2. NORESETLOGS case 삭제

 

tibero@localhost /tibero  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

 

SQL> @/home/tibero/ctl_bak.sql

Control File created.
 

tibero@localhost /tibero  ➤ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

13티베로 마운트 모드 기동 및 복구 수행

tibero@localhost /tibero  ➤ tbboot mount
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
 

tibero@localhost /tibero  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

 

SQL> ALTER SYSTEM SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS';

System altered.

 

SQL> alter database recover automatic database until time '2025/12/12 17:10:00';
TBR-1070: Incomplete media recovery is finished, but resetlogs is required.

14티베로 종료

tibero@localhost /tibero  ➤ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

15티베로 기동 및 복구 마무리

tibero@localhost /tibero  ➤ tbboot resetlogs
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL RESETLOGS mode).

tibero@localhost /tibero  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

 

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/tibero/data/temp001.dtf' SIZE 100M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 32G;

Tablespace 'TEMP' altered.

16건수 확인

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   100001

1 row selected.

 

부분 백업 기능

증분 백업 , 차등 백업에 대해 설명합니다.

 

수행 (증분 백업)

수행 순서시나리오
1복구 관리자(tbrmgr)를 통한 Online Full Backup
2테이블 건수 조회
3데이터 입력
4테이블 건수 조회
5Incremental Backup 1
6데이터 입력
7테이블 건수 조회
8Incremental Backup 2
9데이터 입력
10테이블 건수 조회
11Incremental Backup 3
12티베로 종료 및 데이터 파일 삭제
13티베로 기동하여 마운트 모드 및 장애 상황 확인 후 다시 종료
14tbrmgr Recovery
15건수 조회(Incremental Backup 3 시점과 동일해야함)

 

결과 (증분 백업)

수행 순서시나리오
1복구 관리자(tbrmgr)를 통한 Online Full Backup

tibero@localhost /tibero  ➤ export TB_BACKUP=/tibero/BACKUP
tibero@localhost /tibero  ➤ mkdir -p $TB_BACKUP/full
tibero@localhost /tibero  ➤ tbrmgr backup -o $TB_BACKUP/full -v

==============================================================================
=   Recovery Manager(RMGR) starts                                            =
=                                                                            =
=   TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.         =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /tibero/BACKUP/full

==============================================================================
   RMGR - Backup (FULL)
==============================================================================
Initializing the backup progress, it may take few minutes...

BACKUP  (set_id:  1, ts_id:  0, df_id:  0)
from   /tibero/data/system001.dtf
100.0% |===============================>|   12800/12800   blks    8.17s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  1, df_id:  1)
from   /tibero/data/undo001.dtf
100.0% |===============================>|   25600/25600   blks   11.19s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  3, df_id:  2)
from   /tibero/data/usr001.dtf
100.0% |===============================>|   12800/12800   blks    5.08s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  4, df_id:  3)
from   /tibero/data/syssub001.dtf
100.0% |===============================>|   12800/12800   blks    6.61s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  5, df_id:  4)
from   /tibero/data/test001.dtf
100.0% |===============================>|    2048/2048    blks    0.00s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  5, df_id:  5)
from   /tibero/data/test002.dtf
100.0% |===============================>|    2048/2048    blks    1.03s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  6, df_id:  6)
from   /tibero/data/test_idx_001.dtf
100.0% |===============================>|    2048/2048    blks    1.06s
Synchronizing...

Switching an online logfile...

Backing up the control file...
Control file backup succeeded

Database backup succeeded

RMGR backup ends

2테이블 건수 조회

tibero@localhost /tibero  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   100001

3데이터 입력
 

SQL> INSERT INTO TEST.T1
SELECT ROWNUM ,
'A'||TO_CHAR(ROWNUM),
'B'||TO_CHAR(ROWNUM),
ROUND(ROWNUM/50)
FROM DUAL CONNECT BY ROWNUM<=50000;


50000 rows inserted.

SQL> COMMIT;
Commit completed.

4테이블 건수 조회
 

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   150001

1 row selected.

5Incremental Backup 1

tibero@localhost /tibero  ➤ tbrmgr backup -o $TB_BACKUP/incremental -i -v

==============================================================================
=   Recovery Manager(RMGR) starts                                            =
=                                                                            =
=   TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.         =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /tibero/BACKUP/incremental

==============================================================================
   RMGR - Backup (INCREMENTAL)
==============================================================================
Initializing the backup progress, it may take few minutes...

BACKUP  (set_id:  2, ts_id:  0, df_id:  0)
from   /tibero/data/system001.dtf
100.0% |===============================>|      20/20      blks    0.00s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  1, df_id:  1)
from   /tibero/data/undo001.dtf
100.0% |===============================>|     511/511     blks    1.01s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  3, df_id:  2)
from   /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    1.03s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  4, df_id:  3)
from   /tibero/data/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  5, df_id:  4)
from   /tibero/data/test001.dtf
100.0% |===============================>|     105/105     blks    0.00s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  5, df_id:  5)
from   /tibero/data/test002.dtf
100.0% |===============================>|     132/132     blks    0.00s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  6, df_id:  6)
from   /tibero/data/test_idx_001.dtf
100.0% |===============================>|     716/716     blks    0.00s
Synchronizing...

Switching an online logfile...

Backing up the control file...
Control file backup succeeded

Database backup succeeded

RMGR backup ends

6데이터 입력

tibero@localhost /tibero  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.


SQL> INSERT INTO TEST.T1
SELECT ROWNUM ,
'A'||TO_CHAR(ROWNUM),
'B'||TO_CHAR(ROWNUM),
ROUND(ROWNUM/50)
FROM DUAL CONNECT BY ROWNUM<=50000; 

50000 rows inserted.

 

SQL> COMMIT;

Commit completed.
 

7테이블 건수 조회

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   200001

1 row selected.

8Incremental Backup 2

tibero@localhost /tibero  ➤ tbrmgr backup -o $TB_BACKUP/incremental -i -v

==============================================================================
=   Recovery Manager(RMGR) starts                                            =
=                                                                            =
=   TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.         =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /tibero/BACKUP/incremental

==============================================================================
   RMGR - Backup (INCREMENTAL)
==============================================================================
Initializing the backup progress, it may take few minutes...

BACKUP  (set_id:  3, ts_id:  0, df_id:  0)
from   /tibero/data/system001.dtf
100.0% |===============================>|       2/2       blks    0.00s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  1, df_id:  1)
from   /tibero/data/undo001.dtf
100.0% |===============================>|     191/191     blks    2.06s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  3, df_id:  2)
from   /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    1.03s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  4, df_id:  3)
from   /tibero/data/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  5, df_id:  4)
from   /tibero/data/test001.dtf
100.0% |===============================>|     134/134     blks    0.00s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  5, df_id:  5)
from   /tibero/data/test002.dtf
100.0% |===============================>|      80/80      blks    0.00s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  6, df_id:  6)
from   /tibero/data/test_idx_001.dtf
100.0% |===============================>|     688/688     blks    0.00s
Synchronizing...

Switching an online logfile...

Backing up the control file...
Control file backup succeeded

Database backup succeeded

RMGR backup ends

9데이터 입력

tibero@localhost /tibero  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> INSERT INTO TEST.T1
SELECT ROWNUM ,
'A'||TO_CHAR(ROWNUM),
'B'||TO_CHAR(ROWNUM),
ROUND(ROWNUM/50)
FROM DUAL CONNECT BY ROWNUM<=50000;
 

50000 rows inserted.

SQL> COMMIT;

Commit completed.

10테이블 건수 조회

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   250001

11Incremental Backup 3

tibero@localhost /tibero  ➤ tbrmgr backup -o $TB_BACKUP/incremental -i -v

==============================================================================
=   Recovery Manager(RMGR) starts                                            =
=                                                                            =
=   TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.         =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /tibero/BACKUP/incremental

==============================================================================
   RMGR - Backup (INCREMENTAL)
==============================================================================
Initializing the backup progress, it may take few minutes...

BACKUP  (set_id:  4, ts_id:  0, df_id:  0)
from   /tibero/data/system001.dtf
100.0% |===============================>|       8/8       blks    0.00s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  1, df_id:  1)
from   /tibero/data/undo001.dtf
100.0% |===============================>|     860/860     blks    2.05s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  3, df_id:  2)
from   /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  4, df_id:  3)
from   /tibero/data/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  5, df_id:  4)
from   /tibero/data/test001.dtf
100.0% |===============================>|      96/96      blks    0.00s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  5, df_id:  5)
from   /tibero/data/test002.dtf
100.0% |===============================>|     131/131     blks    0.00s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  6, df_id:  6)
from   /tibero/data/test_idx_001.dtf
100.0% |===============================>|    1148/1148    blks    0.00s
Synchronizing...

Switching an online logfile...

Backing up the control file...
Control file backup succeeded

Database backup succeeded

RMGR backup ends

12티베로 종료 및 데이터 파일 삭제

tibero@localhost /tibero/BACKUP  ➤ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

tibero@localhost /tibero/BACKUP  ➤ rm -rf /tibero/data/*.dtf

13티베로 기동하여 마운트 모드 및 장애 상황 확인 후 다시 종료

tibero@localhost /tibero/BACKUP  ➤ tbboot
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

********************************************************
* Critical Warning : Raise svmode failed. The reason is
*   TBR-1024 :  Database needs media recovery: open failed(/tibero/data/system001.dtf).
*   Current server mode is MOUNT.
********************************************************


Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started suspended at MOUNT mode.
 

tibero@localhost /tibero/BACKUP  ➤ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

14tbrmgr Recovery

tibero@localhost /tibero/BACKUP  ➤ tbrmgr recover -o $TB_BACKUP/incremental -v

==============================================================================
=   Recovery Manager(RMGR) starts                                            =
=                                                                            =
=   TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.         =
==============================================================================
RMGR '-o' option used
: restoring from /tibero/BACKUP/incremental

==============================================================================
   RMGR - recovery (COMPLETE)
==============================================================================
Shutting down the instance...

tbdown failed. proc info file is deleted.
Hint: Please check if the tbsvr instance was already stopped.
info file is deleted.
unlink failed.: No such file or directory

Control file #0 (/tibero/data/c1.ctl) is accessible
Control file #1 (/tibero/data/c2.ctl) is accessible

All control files are accessible. No need to restore the backup control file.


Booting up the instance...

Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
Initializing the restore progress, it may take few minutes...


RMGR begins restoring backup files.
Full backup set_id: 1
Last incremental backup set_id: 4

RESTORE (set_id:  1, ts_id:  0, df_id:  0) - FULL BACKUP
to     /tibero/data/system001.dtf
100.0% |===============================>|   12800/12800   blks    1.19s
Synchronizing...
RESTORE (set_id:  1, ts_id:  1, df_id:  1) - FULL BACKUP
to     /tibero/data/undo001.dtf
100.0% |===============================>|   25600/25600   blks    2.03s
Synchronizing...
RESTORE (set_id:  1, ts_id:  3, df_id:  2) - FULL BACKUP
to     /tibero/data/usr001.dtf
100.0% |===============================>|   12800/12800   blks    1.01s
Synchronizing...
RESTORE (set_id:  1, ts_id:  4, df_id:  3) - FULL BACKUP
to     /tibero/data/syssub001.dtf
100.0% |===============================>|   12800/12800   blks    1.05s
Synchronizing...
RESTORE (set_id:  1, ts_id:  5, df_id:  4) - FULL BACKUP
to     /tibero/data/test001.dtf
100.0% |===============================>|    2048/2048    blks    1.08s
Synchronizing...
RESTORE (set_id:  1, ts_id:  5, df_id:  5) - FULL BACKUP
to     /tibero/data/test002.dtf
100.0% |===============================>|    2048/2048    blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  6, df_id:  6) - FULL BACKUP
to     /tibero/data/test_idx_001.dtf
100.0% |===============================>|    2048/2048    blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  0, df_id:  0) - INCREMENTAL BACKUP
to     /tibero/data/system001.dtf
100.0% |===============================>|      20/20      blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  1, df_id:  1) - INCREMENTAL BACKUP
to     /tibero/data/undo001.dtf
100.0% |===============================>|     511/511     blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  3, df_id:  2) - INCREMENTAL BACKUP
to     /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  4, df_id:  3) - INCREMENTAL BACKUP
to     /tibero/data/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  5, df_id:  4) - INCREMENTAL BACKUP
to     /tibero/data/test001.dtf
100.0% |===============================>|     105/105     blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  5, df_id:  5) - INCREMENTAL BACKUP
to     /tibero/data/test002.dtf
100.0% |===============================>|     132/132     blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  6, df_id:  6) - INCREMENTAL BACKUP
to     /tibero/data/test_idx_001.dtf
100.0% |===============================>|     716/716     blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  0, df_id:  0) - INCREMENTAL BACKUP
to     /tibero/data/system001.dtf
100.0% |===============================>|       2/2       blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  1, df_id:  1) - INCREMENTAL BACKUP
to     /tibero/data/undo001.dtf
100.0% |===============================>|     191/191     blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  3, df_id:  2) - INCREMENTAL BACKUP
to     /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    1.09s
Synchronizing...
RESTORE (set_id:  3, ts_id:  4, df_id:  3) - INCREMENTAL BACKUP
to     /tibero/data/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  5, df_id:  4) - INCREMENTAL BACKUP
to     /tibero/data/test001.dtf
100.0% |===============================>|     134/134     blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  5, df_id:  5) - INCREMENTAL BACKUP
to     /tibero/data/test002.dtf
100.0% |===============================>|      80/80      blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  6, df_id:  6) - INCREMENTAL BACKUP
to     /tibero/data/test_idx_001.dtf
100.0% |===============================>|     688/688     blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  0, df_id:  0) - INCREMENTAL BACKUP
to     /tibero/data/system001.dtf
100.0% |===============================>|       8/8       blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  1, df_id:  1) - INCREMENTAL BACKUP
to     /tibero/data/undo001.dtf
100.0% |===============================>|     860/860     blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  3, df_id:  2) - INCREMENTAL BACKUP
to     /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  4, df_id:  3) - INCREMENTAL BACKUP
to     /tibero/data/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  5, df_id:  4) - INCREMENTAL BACKUP
to     /tibero/data/test001.dtf
100.0% |===============================>|      96/96      blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  5, df_id:  5) - INCREMENTAL BACKUP
to     /tibero/data/test002.dtf
100.0% |===============================>|     131/131     blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  6, df_id:  6) - INCREMENTAL BACKUP
to     /tibero/data/test_idx_001.dtf
100.0% |===============================>|    1148/1148    blks    0.00s
Synchronizing...
Settling...

Database restoration succeeded

recoverSQL: ALTER DATABASE RECOVER AUTOMATIC
Database automatic recovery succeeded

Shutting down the instance...


Tibero instance terminated (NORMAL mode).

Booting up the instance...

Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
RMGR recovery ends

15건수 조회(Incremental Backup 3 시점과 동일해야함)

tibero@localhost /tibero/BACKUP  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> SELECT COUNT(*) FROM TEST.T1;


 COUNT(*)
----------
   250001

1 row selected.
 

 

수행 (차등 백업)

수행 순서시나리오
1tbrmgr 풀 백업 파일 복사
2테이블 건수 조회
3데이터 입력
4테이블 건수 조회
5Cumulative Backup 1
6데이터 입력
7테이블 거수 조회
8Cumulative Backup 2
9데이터 입력
10테이블 거수 조회
11Cumulative Backup 3
12티베로 종료 및 데이터 파일 전체 삭제
13티베로 기동하여 마운트 모드 및 장애 상황 확인 후 다시 종료
14tbrmgr Recovery
15건수 조회(Cumulative Backup 3 시점과 동일해야함)

 

 

결과 (차등 백업)

수행 순서시나리오
1tbrmgr 풀 백업 파일 복사
cp -r $TB_BACKUP/full $TB_BACKUP/cumulative
2테이블 건수 조회

tibero@localhost /tibero/BACKUP  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

 

SQL> select count(*) from test.t1;

 COUNT(*)
----------
   250001

1 row selected.

3데이터 입력

SQL> select count(*) from test.t1;

 COUNT(*)
----------
   250001

1 row selected.

 

SQL> INSERT INTO TEST.T1
SELECT ROWNUM ,
'A'||TO_CHAR(ROWNUM),
'B'||TO_CHAR(ROWNUM),
ROUND(ROWNUM/50)
FROM DUAL CONNECT BY ROWNUM<=50000; 

50000 rows inserted.

 

SQL> COMMIT;

Commit completed.

4테이블 건수 조회

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   300001

1 row selected.
 

5Cumulative Backup 1

tibero@localhost /tibero  ➤ tbrmgr backup -o $TB_BACKUP/cumulative -C -v

==============================================================================
=   Recovery Manager(RMGR) starts                                            =
=                                                                            =
=   TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.         =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /tibero/BACKUP/cumulative

==============================================================================
   RMGR - Backup (CUMULATIVE INCREMENTAL)
==============================================================================
Initializing the backup progress, it may take few minutes...

BACKUP  (set_id:  5, ts_id:  0, df_id:  0)
from   /tibero/data/system001.dtf
100.0% |===============================>|     736/736     blks    1.05s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  1, df_id:  1)
from   /tibero/data/undo001.dtf
100.0% |===============================>|    5850/5850    blks    1.02s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  3, df_id:  2)
from   /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  4, df_id:  3)
from   /tibero/data/syssub001.dtf
100.0% |===============================>|    5099/5099    blks    2.10s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  5, df_id:  4)
from   /tibero/data/test001.dtf
100.0% |===============================>|     365/365     blks    0.00s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  5, df_id:  5)
from   /tibero/data/test002.dtf
100.0% |===============================>|     471/471     blks    0.00s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  6, df_id:  6)
from   /tibero/data/test_idx_001.dtf
100.0% |===============================>|    1356/1356    blks    0.00s
Synchronizing...

Switching an online logfile...

Backing up the control file...
Control file backup succeeded

Database backup succeeded

RMGR backup ends

6데이터 입력

tibero@localhost /tibero  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.


SQL> INSERT INTO TEST.T1
SELECT ROWNUM ,
'A'||TO_CHAR(ROWNUM),
'B'||TO_CHAR(ROWNUM),
ROUND(ROWNUM/50)
FROM DUAL CONNECT BY ROWNUM<=50000; 

50000 rows inserted.

 

SQL> commit;

Commit completed.

7테이블 건 조회

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   350001

8Cumulative Backup 2

tibero@localhost /tibero  ➤ tbrmgr backup -o $TB_BACKUP/cumulative -C -v

==============================================================================
=   Recovery Manager(RMGR) starts                                            =
=                                                                            =
=   TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.         =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /tibero/BACKUP/cumulative

==============================================================================
   RMGR - Backup (CUMULATIVE INCREMENTAL)
==============================================================================
Initializing the backup progress, it may take few minutes...

BACKUP  (set_id:  6, ts_id:  0, df_id:  0)
from   /tibero/data/system001.dtf
100.0% |===============================>|     736/736     blks    0.00s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  1, df_id:  1)
from   /tibero/data/undo001.dtf
100.0% |===============================>|    6023/6023    blks    0.00s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  3, df_id:  2)
from   /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  4, df_id:  3)
from   /tibero/data/syssub001.dtf
100.0% |===============================>|    5099/5099    blks    0.00s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  5, df_id:  4)
from   /tibero/data/test001.dtf
100.0% |===============================>|     464/464     blks    0.00s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  5, df_id:  5)
from   /tibero/data/test002.dtf
100.0% |===============================>|     581/581     blks    0.00s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  6, df_id:  6)
from   /tibero/data/test_idx_001.dtf
100.0% |===============================>|    1372/1372    blks    0.00s
Synchronizing...

Switching an online logfile...

Backing up the control file...
Control file backup succeeded

Database backup succeeded

RMGR backup ends

9데이터 입력

tibero@localhost /tibero  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> INSERT INTO TEST.T1
SELECT ROWNUM ,
'A'||TO_CHAR(ROWNUM),
'B'||TO_CHAR(ROWNUM),
ROUND(ROWNUM/50)
FROM DUAL CONNECT BY ROWNUM<=50000;

50000 rows inserted.

 

SQL> COMMIT;

Commit completed.
 

10테이블 수 조회

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   400001

1 row selected.
 

11Cumulative Backup 3

tibero@localhost /tibero  ➤ tbrmgr backup -o $TB_BACKUP/cumulative -C -v

==============================================================================
=   Recovery Manager(RMGR) starts                                            =
=                                                                            =
=   TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.         =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /tibero/BACKUP/cumulative

==============================================================================
   RMGR - Backup (CUMULATIVE INCREMENTAL)
==============================================================================
Initializing the backup progress, it may take few minutes...

BACKUP  (set_id:  7, ts_id:  0, df_id:  0)
from   /tibero/data/system001.dtf
100.0% |===============================>|     736/736     blks    1.00s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  1, df_id:  1)
from   /tibero/data/undo001.dtf
100.0% |===============================>|    6244/6244    blks    1.05s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  3, df_id:  2)
from   /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  4, df_id:  3)
from   /tibero/data/syssub001.dtf
100.0% |===============================>|    5099/5099    blks    0.00s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  5, df_id:  4)
from   /tibero/data/test001.dtf
100.0% |===============================>|     514/514     blks    0.00s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  5, df_id:  5)
from   /tibero/data/test002.dtf
100.0% |===============================>|     710/710     blks    0.00s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  6, df_id:  6)
from   /tibero/data/test_idx_001.dtf
100.0% |===============================>|    1436/1436    blks    0.00s
Synchronizing...

Switching an online logfile...

Backing up the control file...
Control file backup succeeded

Database backup succeeded

RMGR backup ends

 

tibero@localhost /tibero  ➤ ls -al $TB_BACKUP/cumulative
total 1200204
drwxr-xr-x. 2 tibero dba      4096 Dec 15 09:58 .
drwxr-xr-x. 5 tibero dba      4096 Dec 15 09:52 ..
-rw-------. 1 tibero dba 104857600 Dec 15 09:52 bkp_20251212_1_0_0_51003
-rw-------. 1 tibero dba 209715200 Dec 15 09:52 bkp_20251212_1_1_1_51003
-rw-------. 1 tibero dba 104857600 Dec 15 09:52 bkp_20251212_1_3_2_51003
-rw-------. 1 tibero dba 104857600 Dec 15 09:52 bkp_20251212_1_4_3_51003
-rw-------. 1 tibero dba  16777216 Dec 15 09:52 bkp_20251212_1_5_4_51003
-rw-------. 1 tibero dba  16777216 Dec 15 09:52 bkp_20251212_1_5_5_51003
-rw-------. 1 tibero dba  16777216 Dec 15 09:52 bkp_20251212_1_6_6_51003
-rw-------. 1 tibero dba  75743232 Dec 15 09:52 bkp_20251212_1_cf_51003
-rw-------. 1 tibero dba   6029312 Dec 15 09:54 bkp_20251215_5_0_0_51003
-rw-------. 1 tibero dba  47923200 Dec 15 09:54 bkp_20251215_5_1_1_51003
-rw-------. 1 tibero dba      8192 Dec 15 09:55 bkp_20251215_5_3_2_51003
-rw-------. 1 tibero dba  41771008 Dec 15 09:55 bkp_20251215_5_4_3_51003
-rw-------. 1 tibero dba   2990080 Dec 15 09:55 bkp_20251215_5_5_4_51003
-rw-------. 1 tibero dba   3858432 Dec 15 09:55 bkp_20251215_5_5_5_51003
-rw-------. 1 tibero dba  11108352 Dec 15 09:55 bkp_20251215_5_6_6_51003
-rw-------. 1 tibero dba  75743232 Dec 15 09:55 bkp_20251215_5_cf_51003
-rw-------. 1 tibero dba   6029312 Dec 15 09:56 bkp_20251215_6_0_0_51003
-rw-------. 1 tibero dba  49340416 Dec 15 09:56 bkp_20251215_6_1_1_51003
-rw-------. 1 tibero dba      8192 Dec 15 09:56 bkp_20251215_6_3_2_51003
-rw-------. 1 tibero dba  41771008 Dec 15 09:56 bkp_20251215_6_4_3_51003
-rw-------. 1 tibero dba   3801088 Dec 15 09:56 bkp_20251215_6_5_4_51003
-rw-------. 1 tibero dba   4759552 Dec 15 09:56 bkp_20251215_6_5_5_51003
-rw-------. 1 tibero dba  11239424 Dec 15 09:56 bkp_20251215_6_6_6_51003
-rw-------. 1 tibero dba  75743232 Dec 15 09:56 bkp_20251215_6_cf_51003
-rw-------. 1 tibero dba   6029312 Dec 15 09:58 bkp_20251215_7_0_0_51003
-rw-------. 1 tibero dba  51150848 Dec 15 09:58 bkp_20251215_7_1_1_51003
-rw-------. 1 tibero dba      8192 Dec 15 09:58 bkp_20251215_7_3_2_51003
-rw-------. 1 tibero dba  41771008 Dec 15 09:58 bkp_20251215_7_4_3_51003
-rw-------. 1 tibero dba   4210688 Dec 15 09:58 bkp_20251215_7_5_4_51003
-rw-------. 1 tibero dba   5816320 Dec 15 09:58 bkp_20251215_7_5_5_51003
-rw-------. 1 tibero dba  11763712 Dec 15 09:58 bkp_20251215_7_6_6_51003
-rw-------. 1 tibero dba  75743232 Dec 15 09:58 bkp_20251215_7_cf_51003

12티베로 종료 및 데이터 파일 전체 삭제

tibero@localhost /tibero  ➤ tbdown

Tibero instance terminated (NORMAL mode).

 

tibero@localhost /tibero  ➤ rm /tibero/data/*.dtf

13티베로 기동하여 마운트 모드 및 장애 상황 확인 후 다시 종료

tibero@localhost /tibero  ➤ tbboot
Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

********************************************************
* Critical Warning : Raise svmode failed. The reason is
*   TBR-1024 :  Database needs media recovery: open failed(/tibero/data/system001.dtf).
*   Current server mode is MOUNT.
********************************************************


Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started suspended at MOUNT mode.

 


tibero@localhost /tibero  ➤ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

14tbrmgr Recovery

tibero@localhost /tibero  ➤ tbrmgr recover -o $TB_BACKUP/cumulative -v

==============================================================================
=   Recovery Manager(RMGR) starts                                            =
=                                                                            =
=   TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.         =
==============================================================================
RMGR '-o' option used
: restoring from /tibero/BACKUP/cumulative

==============================================================================
   RMGR - recovery (COMPLETE)
==============================================================================
Shutting down the instance...

tbdown failed. proc info file is deleted.
Hint: Please check if the tbsvr instance was already stopped.
info file is deleted.
unlink failed.: No such file or directory

Control file #0 (/tibero/data/c1.ctl) is accessible
Control file #1 (/tibero/data/c2.ctl) is accessible

All control files are accessible. No need to restore the backup control file.


Booting up the instance...

Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
Initializing the restore progress, it may take few minutes...


RMGR begins restoring backup files.
Full backup set_id: 1
Last incremental backup set_id: 7

RESTORE (set_id:  1, ts_id:  0, df_id:  0) - FULL BACKUP
to     /tibero/data/system001.dtf
100.0% |===============================>|   12800/12800   blks    1.07s
Synchronizing...
RESTORE (set_id:  1, ts_id:  1, df_id:  1) - FULL BACKUP
to     /tibero/data/undo001.dtf
100.0% |===============================>|   25600/25600   blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  3, df_id:  2) - FULL BACKUP
to     /tibero/data/usr001.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  4, df_id:  3) - FULL BACKUP
to     /tibero/data/syssub001.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  5, df_id:  4) - FULL BACKUP
to     /tibero/data/test001.dtf
100.0% |===============================>|    2048/2048    blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  5, df_id:  5) - FULL BACKUP
to     /tibero/data/test002.dtf
100.0% |===============================>|    2048/2048    blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  6, df_id:  6) - FULL BACKUP
to     /tibero/data/test_idx_001.dtf
100.0% |===============================>|    2048/2048    blks    0.00s
Synchronizing...
RESTORE (set_id:  7, ts_id:  0, df_id:  0) - INCREMENTAL BACKUP
to     /tibero/data/system001.dtf
100.0% |===============================>|     736/736     blks    0.00s
Synchronizing...
RESTORE (set_id:  7, ts_id:  1, df_id:  1) - INCREMENTAL BACKUP
to     /tibero/data/undo001.dtf
100.0% |===============================>|    6244/6244    blks    1.04s
Synchronizing...
RESTORE (set_id:  7, ts_id:  3, df_id:  2) - INCREMENTAL BACKUP
to     /tibero/data/usr001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  7, ts_id:  4, df_id:  3) - INCREMENTAL BACKUP
to     /tibero/data/syssub001.dtf
100.0% |===============================>|    5099/5099    blks    3.12s
Synchronizing...
RESTORE (set_id:  7, ts_id:  5, df_id:  4) - INCREMENTAL BACKUP
to     /tibero/data/test001.dtf
100.0% |===============================>|     514/514     blks    1.04s
Synchronizing...
RESTORE (set_id:  7, ts_id:  5, df_id:  5) - INCREMENTAL BACKUP
to     /tibero/data/test002.dtf
100.0% |===============================>|     710/710     blks    0.00s
Synchronizing...
RESTORE (set_id:  7, ts_id:  6, df_id:  6) - INCREMENTAL BACKUP
to     /tibero/data/test_idx_001.dtf
100.0% |===============================>|    1436/1436    blks    0.00s
Synchronizing...
Settling...

Database restoration succeeded

recoverSQL: ALTER DATABASE RECOVER AUTOMATIC
Database automatic recovery succeeded

Shutting down the instance...


Tibero instance terminated (NORMAL mode).

Booting up the instance...

Change core dump dir to /home/tibero/tibero7/bin/prof.
Listener port = 8629

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
RMGR recovery ends

15건수 조회(Cumulative Backup 3 시점과 동일해야함)

tibero@localhost /tibero  ➤ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> SELECT COUNT(*) FROM TEST.T1;

 COUNT(*)
----------
   400001

1 row selected

 

 

관련 대상