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

검색

Welcome to Tibero GTS!

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

문서유형ㅣ기술정보

분야ㅣ관리/환경설정 

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

문서번호ㅣTADTI212

 

개요

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

 

 

방법

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

온라인 백업 후 완전 복구를 설명합니다.

 

수행

수행 순서시나리오
1

테스트용 데이터 생성

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

사전 확인

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

 

결과

수행 순서시나리오
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
UNDO0
TEMP
USR
UNDO1
SYSSUB
6 rows selected.

 

SELECT FILE_NAME FROM DBA_DATA_FILES;
FILE_NAME
--------------------------------------------------------------------------------
/dev/raw/raw51
/dev/raw/raw53
/dev/raw/raw55
/dev/raw/raw54
/dev/raw/raw56
5 rows selected.

 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 rows selected.

exit
Disconnected.
 

 4핫 백업 진행

ls -al /dev/raw


mkdir -p $TB_HOME/${TB_SID}_hot


dd if=/dev/raw/raw51 of=$TB_HOME/${TB_SID}_hot/raw51 bs=8k
dd if=/dev/raw/raw53 of=$TB_HOME/${TB_SID}_hot/raw53 bs=8k
dd if=/dev/raw/raw54 of=$TB_HOME/${TB_SID}_hot/raw54 bs=8k
dd if=/dev/raw/raw55 of=$TB_HOME/${TB_SID}_hot/raw55 bs=8k
dd if=/dev/raw/raw56 of=$TB_HOME/${TB_SID}_hot/raw56 bs=8k

 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

 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.

 7 데이터 조회

SELECT COUNT(*) FROM TEST.T1;

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

1 row selected.

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

- Node1
tbdown
Tibero instance terminated (NORMAL mode).


- Node2
tbdown
Tibero instance terminated (NORMAL mode).


dd if=/dev/zero of=/dev/raw/raw51 count=1
dd if=/dev/zero of=/dev/raw/raw53 count=1
dd if=/dev/zero of=/dev/raw/raw54 count=1
dd if=/dev/zero of=/dev/raw/raw55 count=1
dd if=/dev/zero of=/dev/raw/raw56 count=1

 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).

 

dd if=$TB_HOME/${TB_SID}_hot/raw51 of=/dev/raw/raw51 bs=8k
dd if=$TB_HOME/${TB_SID}_hot/raw53 of=/dev/raw/raw53 bs=8k
dd if=$TB_HOME/${TB_SID}_hot/raw54 of=/dev/raw/raw54 bs=8k
dd if=$TB_HOME/${TB_SID}_hot/raw55 of=/dev/raw/raw55 bs=8k
dd if=$TB_HOME/${TB_SID}_hot/raw56 of=/dev/raw/raw56 bs=8k

11NODE2 의 archivelog 파일을 NODE1 로 복사
--NODE2
scp /data/tta02/tbarch/*.arc tta01@xxx.xxx.xx.x:/data/tta01/tbarch
tta01@192.168.53.186's password: 
log-t1-r0-s1.arc       
100%   82MB  10.3MB/s   00:08
 12티베로 마운트 모트 기동 및 복구 수행

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).

 13티베로 기동

-- NODE1

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).

 

-- NODE2

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).

 14테이블 건수 조회

SELECT COUNT(*) FROM TEST.T1;

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

1 row selected.

 

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

수행

수행 순서시나리오
 1

 백업 대상 확인

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

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

 

결과

수행 순서시나리오
 1

백업 대상 확인

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

tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

 

SELECT NAME FROM V$CONTROLFILE;

NAME
-------------------------------
/dev/raw/raw1
/dev/raw/raw2
2 rows selected.

 

SELECT MEMBER FROM V$LOGFILE;

MEMBER
--------------------------------------------------------------------------------
/dev/raw/raw3
/dev/raw/raw4
/dev/raw/raw5
/dev/raw/raw6
/dev/raw/raw7
/dev/raw/raw8

6 rows selected.

 

SELECT FILE_NAME FROM DBA_DATAFILES;

FILE_NAME
--------------------------------------------------------------------------------
/dev/raw/raw51
/dev/raw/raw53
/dev/raw/raw55
/dev/raw/raw54
/dev/raw/raw56
5 rows selected.

 

SELECT FILE_NAME FROM DBA_TEMP_FILES;

FILE_NAME
--------------------------------------------------------------------------------
/dev/raw/raw52


1 row selected.

 2테이블 건수 조회

SELECT COUNT(*) FROM TEST.T1;

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

 3

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

-- NODE1

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

-- NODE2

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

mkdir -p $TB_HOME/${TB_SID}_bak

--Control
dd if=/dev/raw/raw1 of=$TB_HOME/${TB_SID}_bak/raw1 bs=8k
dd if=/dev/raw/raw2 of=$TB_HOME/${TB_SID}_bak/raw2 bs=8k

--Log
dd if=/dev/raw/raw3 of=$TB_HOME/${TB_SID}_bak/raw3 bs=8k
dd if=/dev/raw/raw4 of=$TB_HOME/${TB_SID}_bak/raw4 bs=8k
dd if=/dev/raw/raw5 of=$TB_HOME/${TB_SID}_bak/raw5 bs=8k
dd if=/dev/raw/raw6 of=$TB_HOME/${TB_SID}_bak/raw6 bs=8k
dd if=/dev/raw/raw7 of=$TB_HOME/${TB_SID}_bak/raw7 bs=8k
dd if=/dev/raw/raw8 of=$TB_HOME/${TB_SID}_bak/raw8 bs=8k
 

--Data
dd if=/dev/raw/raw51 of=$TB_HOME/${TB_SID}_bak/raw51 bs=8k
dd if=/dev/raw/raw53 of=$TB_HOME/${TB_SID}_bak/raw53 bs=8k
dd if=/dev/raw/raw54 of=$TB_HOME/${TB_SID}_bak/raw54 bs=8k
dd if=/dev/raw/raw55 of=$TB_HOME/${TB_SID}_bak/raw55 bs=8k
dd if=/dev/raw/raw56 of=$TB_HOME/${TB_SID}_bak/raw56 bs=8k
 

--Temp
dd if=/dev/raw/raw52 of=$TB_HOME/${TB_SID}_bak/raw52 bs=8

 4티베로 기동

-- NODE1

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).

 

-- NODE2

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티베로 종료 및 데이터 파일 전체 삭제

-- NODE1

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

-- NODE2

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

dd if=/dev/zero of=/dev/raw/raw51 count=1
dd if=/dev/zero of=/dev/raw/raw53 count=1
dd if=/dev/zero of=/dev/raw/raw54 count=1
dd if=/dev/zero of=/dev/raw/raw55 count=1
dd if=/dev/zero of=/dev/raw/raw56 count=1

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

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: wrong database file(/dev/raw/raw51).   

*   Current server mode is MOUNT.
********************************************************
Tibero 7  
TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started suspended at MOUNT mode.

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

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

dd if=$TB_HOME/${TB_SID}_bak/raw51 of=/dev/raw/raw51 bs=8k
dd if=$TB_HOME/${TB_SID}_bak/raw53 of=/dev/raw/raw53 bs=8k
dd if=$TB_HOME/${TB_SID}_bak/raw54 of=/dev/raw/raw54 bs=8k
dd if=$TB_HOME/${TB_SID}_bak/raw55 of=/dev/raw/raw55 bs=8k
dd if=$TB_HOME/${TB_SID}_bak/raw56 of=/dev/raw/raw56 bs=8k

10NODE2 의 archivelog 파일을 NODE1 로 복사
--NODE2
scp /data/tta02/tbarch/*.arc tta01@xxx.xxx.x.x:/data/tta02/tbarch
 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.

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

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).

13테이블 건수 조회

select count(*) from test.t1;

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

 

매체 복구 (Media Recovery) 기능

수행

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

 

결과

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

select count(*) from test.t1;

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

2Begin Backup 수행

alter database begin backup;

Database altered.

3핫 백업 진행
ls -al /dev/raw
dd if=/dev/raw/raw51 of=$TB_HOME/${TB_SID}_hot/raw51 bs=8k
dd if=/dev/raw/raw53 of=$TB_HOME/${TB_SID}_hot/raw53 bs=8k
dd if=/dev/raw/raw54 of=$TB_HOME/${TB_SID}_hot/raw54 bs=8k
dd if=/dev/raw/raw55 of=$TB_HOME/${TB_SID}_hot/raw55 bs=8k
dd if=/dev/raw/raw56 of=$TB_HOME/${TB_SID}_hot/raw56 bs=8k
4End Backup 수행 및 로그 스위치 수행

--NODE1

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.

 

-- NODE1, NODE2
-- NODE2 도  반드시 log switch 를  해줘야함
-- 그렇지 않으면 복구 시 archive 파일 too old 라는 오류 발생

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.

 

-- NODE1, NODE2
-- NODE2 도  반드시 log switch 를  해줘야함

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 까지)
 

--NODE1, NODE2
tbdown
Tibero instance terminated (NORMAL mode).

--data delete
dd if=/dev/zero of=/dev/raw/raw51 count=1
dd if=/dev/zero of=/dev/raw/raw53 count=1
dd if=/dev/zero of=/dev/raw/raw54 count=1
dd if=/dev/zero of=/dev/raw/raw55 count=1
dd if=/dev/zero of=/dev/raw/raw56 count=1

--log delete
dd if=/dev/zero of=/dev/raw/raw3 count=1

dd if=/dev/zero of=/dev/raw/raw4 count=1
dd if=/dev/zero of=/dev/raw/raw5 count=1
dd if=/dev/zero of=/dev/raw/raw6 count=1
dd if=/dev/zero of=/dev/raw/raw7 count=1
dd if=/dev/zero of=/dev/raw/raw8 count=1

--ctl delete
dd if=/dev/zero of=/dev/raw/raw1 count=1

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).


dd if=$TB_HOME/${TB_SID}_hot/raw51 of=/dev/raw/raw51 bs=8k
dd if=$TB_HOME/${TB_SID}_hot/raw53 of=/dev/raw/raw53 bs=8k
dd if=$TB_HOME/${TB_SID}_hot/raw54 of=/dev/raw/raw54 bs=8k
dd if=$TB_HOME/${TB_SID}_hot/raw55 of=/dev/raw/raw55 bs=8k
dd if=$TB_HOME/${TB_SID}_hot/raw56 of=/dev/raw/raw56 bs=8k

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).

13NODE2 의 archivelog 파일을 NODE1 로 복사
--NODE2
scp /tibero/tbarch/*arc tibero@xxx.xxx.xxx.xxx:/tibero/tbarch tibero@xxx.xxx.xxx.xxx's 
14티베로 마운트 모드 기동 및 복구 수행

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.

--ctl.sql 을  열어보면  THREAD1 logfile 추가하는  명령어가  있음
SQL> ALTER DATABASE ADD LOGFILE THREAD 1  GROUP 3 '/dev/raw/raw6' SIZE 500M;
Database altered.
 

SQL> ALTER DATABASE ADD LOGFILE THREAD 1  GROUP 4 '/dev/raw/raw7' SIZE 500M;
Database altered.
 

SQL> ALTER DATABASE ADD LOGFILE THREAD 1  GROUP 5 '/dev/raw/raw8' SIZE 500M;
Database altered.
 

SQL> ALTER DATABASE ENABLE PRIVATE THREAD 1;
Database altered.

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.

15티베로 종료

tibero@localhost /tibero  ➤ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

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

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 '/dev/raw52' 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
 12NODE1,NODE2 종료 및 데이터 파일 삭제
 13티베로 기동하여 마운트 모드 및 장애 상황 확인
 14Node1, Node2 종료 및 tbcm 종료
15Node1 tip 파일 정
 16tbrmgr Recovery
 17건수 조회(Incremental Backup 3 시점과 동일해야함)
18tbcm 기동 및 Node1, Node2 동
19건수 조회 (Incremental Backup3 과 동일해야 함)

 

결과 (증분 백업)

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

[root@tech-tac0 /]$ export TB_BACKUP=$TB_HOME/backup
[root@tech-tac0 /]$ mkdir -p $TB_BACKUP/ful
[root@tech-tac0 /]$ 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 /root/tibero_engine/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   /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|   12800/12800   blks    1.02s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  1, df_id:  1)
from   /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  3, df_id:  2)
from   /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  4, df_id:  3)
from   /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|  130560/130560  blks    1.04s
Synchronizing...
BACKUP  (set_id:  1, ts_id:  5, df_id:  4)
from   /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...

Switching an online logfile...

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

Database backup succeeded

RMGR backup ends
[root@tech-tac0 /]$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

 

 

SQL> conn test/test
Connected to Tibero.

 

2테이블 건수 조회

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

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

1 row selected.

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(*)
----------
   50000

1 row selected.

5Incremental Backup 1

[root@tech-tac0 /]$ 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 /root/tibero_engine/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   /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|      42/42      blks    0.00s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  1, df_id:  1)
from   /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|      36/36      blks    0.00s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  3, df_id:  2)
from   /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|     232/232     blks    0.00s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  4, df_id:  3)
from   /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  2, ts_id:  5, df_id:  4)
from   /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|      23/23      blks    0.00s
Synchronizing...

Switching an online logfile...

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

Database backup succeeded

RMGR backup ends

6데이터 입력

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(*)
----------
   100000

1 row selected.

8Incremental Backup 2

[root@tech-tac0 /]$ 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 /root/tibero_engine/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   /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|       3/3       blks    0.00s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  1, df_id:  1)
from   /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|      27/27      blks    0.00s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  3, df_id:  2)
from   /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|     225/225     blks    0.00s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  4, df_id:  3)
from   /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  3, ts_id:  5, df_id:  4)
from   /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|       9/9       blks    0.00s
Synchronizing...

Switching an online logfile...

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

Database backup succeeded

RMGR backup ends

9데이터 입력

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(*)
----------
   150000

11Incremental Backup 3

[root@tech-tac0 /]$ 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 /root/tibero_engine/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   /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|       9/9       blks    0.00s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  1, df_id:  1)
from   /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|      27/27      blks    0.00s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  3, df_id:  2)
from   /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|     236/236     blks    0.00s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  4, df_id:  3)
from   /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
BACKUP  (set_id:  4, ts_id:  5, df_id:  4)
from   /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|      19/19      blks    0.00s
Synchronizing...

Switching an online logfile...

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

Database backup succeeded

RMGR backup ends

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

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

 

rm -rf /share/tac/*.dtf

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

[root@tech-tac0 tac]$ tbboot
Change core dump dir to /root/tibero_engine/bin/prof.
Listener port = 8629

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


Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started suspended at MOUNT mode.
[root@tech-tac0 tac]$ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

14Node1,Node2 종료 및 tbcm 종료

[root@tech-tac0 tac]$ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

[root@tech-tac0 tac]$ tbcm -d
CM DOWN SUCCESS!

15Node1 tip 파일 수정

############ TAC (Tibero Active Cluster)
#### Must
#CLUSTER_DATABASE=Y
#_USE_O_DIRECT=Y

## cm0
#THREAD=0
#UNDO_TABLESPACE=UNDO0
#CM_PORT=28629
#LOCAL_CLUSTER_ADDR=10.10.10.231
#LOCAL_CLUSTER_PORT=18629
 

해당 파일 주석 처리

16tbrmgr Recovery

[root@tech-tac0 tac]$ 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 /root/tibero_engine/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 (/share/tac/tbctl1/c1.ctl) is accessible
Control file #1 (/share/tac/tbctl2/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 /root/tibero_engine/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     /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  1, df_id:  1) - FULL BACKUP
to     /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  3, df_id:  2) - FULL BACKUP
to     /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  4, df_id:  3) - FULL BACKUP
to     /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|  130560/130560  blks    1.04s
Synchronizing...
RESTORE (set_id:  1, ts_id:  5, df_id:  4) - FULL BACKUP
to     /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  0, df_id:  0) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|      42/42      blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  1, df_id:  1) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|      36/36      blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  3, df_id:  2) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|     232/232     blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  4, df_id:  3) - INCREMENTAL BACKUP
to     /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  2, ts_id:  5, df_id:  4) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|      23/23      blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  0, df_id:  0) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|       3/3       blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  1, df_id:  1) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|      27/27      blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  3, df_id:  2) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|     225/225     blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  4, df_id:  3) - INCREMENTAL BACKUP
to     /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  3, ts_id:  5, df_id:  4) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|       9/9       blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  0, df_id:  0) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|       9/9       blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  1, df_id:  1) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|      27/27      blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  3, df_id:  2) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|     236/236     blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  4, df_id:  3) - INCREMENTAL BACKUP
to     /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  4, ts_id:  5, df_id:  4) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|      19/19      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 /root/tibero_engine/bin/prof.
Listener port = 8629

********************************************************
* Critical Warning : Raise svmode failed. The reason is
*   TBR-1053 :  Unable to run database in single instance mode.
*   Current server mode is MOUNT.
********************************************************


Tibero 7

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

17tbdown 및 tip 파일 원상복구

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

CLUSTER_DATABASE=Y
_USE_O_DIRECT=Y

## cm0
THREAD=0
UNDO_TABLESPACE=UNDO0
CM_PORT=28629
LOCAL_CLUSTER_ADDR=10.10.10.231
LOCAL_CLUSTER_PORT=18629

18tbcm 기동 및 Node1, Node2 기동

[root@tech-tac0 tac]$ tbcm -b
CM Guard daemon started up.
import resources from '/root/tibero_engine/config/cm0_res_file'...

TBCM 7.1.1 (Build 300983)

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

Tibero cluster manager started up.
Local node name is (cm0:28629).

[root@tech-tac0 tac]$ cmrctl show
Resource List of Node cm0
=====================================================================
 CLUSTER     TYPE        NAME       STATUS           DETAIL
----------- -------- -------------- -------- ------------------------
    COMMON  network           net0       UP (private) 10.10.10.231/29000
    COMMON  cluster           cls0       UP inc: net0, pub: N/A
      cls0     file         cls0:0       UP /share/tac/CMFILE/CMFILE
      cls0  service         testdb     DOWN Database, Active Cluster (auto-restart: OFF)
      cls0       db        testdb0     DOWN testdb, /root/tibero_engine, failed retry cnt: 0
=====================================================================

[root@tech-tac0 tac]$ tbboot
Change core dump dir to /root/tibero_engine/bin/prof.
Listener port = 8629

Tibero 7

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

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

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

 COUNT(*)
----------
   150000

 

수행 (차등 백업)

수행 순서시나리오
 1tbrmgr 풀 백업 파일 복사
 2테이블 건수 조회
 3데이터 입력
 4테이블 건수 조회
 5Cumulative Backup 1
 6데이터 입력
 7테이블 거수 조회
 8Cumulative Backup 2
 9데이터 입력
 10테이블 건수 조회
 11Cumulative Backup 3
12NODE1, NODE2 종료 및 데이터 파일 삭제
13티베로 기동하여 마운트 모드 및 장애 상황 확인
14NODE1, NODE2 종료 및 tbcm 종료
15NODE1 tip 파일 수정 – single 형태로 복구를 진행해야 함
 16tbrmgr Recovery
 17tbdown 및 tip 파일 원복
 18tbcm 기동 및 NODE1, NODE2 기동
 19건수 조회(Cumulative Backup 3 시점과 동일해야함)

 

결과 (차등 백업)

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

select count(*) from test.t1;

 COUNT(*)
----------
   150000

1 row selected.

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(*)
----------
   200000

1 row selected.

5Cumulative Backup 1

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 /root/tibero_engine/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   /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|      54/54      blks    0.00s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  1, df_id:  1)
from   /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|     212/212     blks    0.00s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  3, df_id:  2)
from   /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|     848/848     blks    0.00s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  4, df_id:  3)
from   /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    2.07s
Synchronizing...
BACKUP  (set_id:  5, ts_id:  5, df_id:  4)
from   /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|      24/24      blks    0.00s
Synchronizing...

Switching an online logfile...

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

Database backup succeeded

RMGR backup ends
 

6데이터 입력

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(*)
----------
   250000

1 row selected.

8Cumulative Backup 2

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 /root/tibero_engine/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   /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|      54/54      blks    0.00s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  1, df_id:  1)
from   /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|     231/231     blks    0.00s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  3, df_id:  2)
from   /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|    1042/1042    blks    1.03s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  4, df_id:  3)
from   /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    2.06s
Synchronizing...
BACKUP  (set_id:  6, ts_id:  5, df_id:  4)
from   /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|      24/24      blks    0.00s
Synchronizing...

Switching an online logfile...

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

Database backup succeeded

RMGR backup ends

9데이터 입력

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(*)
----------
   300000

1 row selected

11Cumulative Backup 3

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 /root/tibero_engine/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   /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|      57/57      blks    0.00s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  1, df_id:  1)
from   /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|     248/248     blks    0.00s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  3, df_id:  2)
from   /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|    1252/1252    blks    1.03s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  4, df_id:  3)
from   /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    2.06s
Synchronizing...
BACKUP  (set_id:  7, ts_id:  5, df_id:  4)
from   /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|      24/24      blks    0.00s
Synchronizing...

Switching an online logfile...

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

Database backup succeeded

RMGR backup ends

12Node1, Node2 종료 및 데이터 파일 삭제

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

rm -rf *.dtf

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

tbboot
Change core dump dir to /root/tibero_engine/bin/prof.
Listener port = 8629

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


Tibero 7

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

14NODE1, NODE2 종료 및 tbcm 종료

-- Node1 , Node2

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

tbcm -d
CM DOWN SUCCESS!

15NODE1 tip 파일 수정 – single 형태로 복구를 진행해야함

#CLUSTER_DATABASE=Y
#_USE_O_DIRECT=Y

## cm0
#THREAD=0
#UNDO_TABLESPACE=UNDO0
#CM_PORT=28629
#LOCAL_CLUSTER_ADDR=10.10.10.231
#LOCAL_CLUSTER_PORT=18629

16tbrmgr Recovery

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 /root/tibero_engine/backup/cumulative

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

Tibero instance terminated (ABNORMAL mode).

info file is deleted.
unlink failed.: No such file or directory

Control file #0 (/share/tac/tbctl1/c1.ctl) is accessible
Control file #1 (/share/tac/tbctl2/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 /root/tibero_engine/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     /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|   12800/12800   blks    0.03s
Synchronizing...
RESTORE (set_id:  1, ts_id:  1, df_id:  1) - FULL BACKUP
to     /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  3, df_id:  2) - FULL BACKUP
to     /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
RESTORE (set_id:  1, ts_id:  4, df_id:  3) - FULL BACKUP
to     /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|  130560/130560  blks    1.04s
Synchronizing...
RESTORE (set_id:  1, ts_id:  5, df_id:  4) - FULL BACKUP
to     /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|   12800/12800   blks    0.00s
Synchronizing...
RESTORE (set_id:  7, ts_id:  0, df_id:  0) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/system001.dtf
100.0% |===============================>|      57/57      blks    0.00s
Synchronizing...
RESTORE (set_id:  7, ts_id:  1, df_id:  1) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/undo001.dtf
100.0% |===============================>|     248/248     blks    0.00s
Synchronizing...
RESTORE (set_id:  7, ts_id:  3, df_id:  2) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/usr001.dtf
100.0% |===============================>|    1252/1252    blks    0.00s
Synchronizing...
RESTORE (set_id:  7, ts_id:  4, df_id:  3) - INCREMENTAL BACKUP
to     /share/tac/tbdata/syssub001.dtf
100.0% |===============================>|       1/1       blks    0.00s
Synchronizing...
RESTORE (set_id:  7, ts_id:  5, df_id:  4) - INCREMENTAL BACKUP
to     /share/tac/tbdata/system/undo101.dtf
100.0% |===============================>|      24/24      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 /root/tibero_engine/bin/prof.
Listener port = 8629

********************************************************
* Critical Warning : Raise svmode failed. The reason is
*   TBR-1053 :  Unable to run database in single instance mode.
*   Current server mode is MOUNT.
********************************************************


Tibero 7

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

17tbdown 및 tip 파일 원복

CLUSTER_DATABASE=Y
_USE_O_DIRECT=Y

## cm0
THREAD=0
UNDO_TABLESPACE=UNDO0
CM_PORT=28629
LOCAL_CLUSTER_ADDR=10.10.10.231
LOCAL_CLUSTER_PORT=18629

18tbcm 기동 및 NODE1, NODE2 기동

tbcm -b
CM Guard daemon started up.
import resources from '/root/tibero_engine/config/cm0_res_file'...

TBCM 7.1.1 (Build 300983)

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

Tibero cluster manager started up.
Local node name is (cm0:28629).

[root@tech-tac0 cumulative]$ tbboot
Change core dump dir to /root/tibero_engine/bin/prof.
Listener port = 8629

Tibero 7

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

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

tbsql sys/tibero

tbSQL 7

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

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

 COUNT(*)
----------
   300000

1 row selected.

 

 

 

관련 대상