tbrmgr 테스트 하는 중

eungjj·2025년 11월 1일
Tibero

- TIBERO

목록 보기
8/8
online Full Backup
경로 미지정시
default dest : 
SQL> show param rmgr

NAME                         TYPE     VALUE
---------------------------- -------- ----------------------------------------
RMGR_BACKUP_DEST             DIRNAME  C:\tibero_engine\tibero6\database\tibero6\backup\
C:\tibero_engine>tbrmgr backup
==================================================================
= Recovery Manager(RMGR) starts                                  =
=                                                                =
= TmaxData Corporation Copyright (c) 2008-. All rights reserved. =
==================================================================

RMGR -o option not used: backed up at RMGR_BACKUP_DEST
=============================================
  RMGR - ONLINE backup
=============================================
DB connected
archive log check succeeded
BACKUP (set_id:1, ts_id:0, df_id:0)
 100.00% |=======================================>|  12800/12800  blks 0.16s
Synchronizing...
BACKUP (set_id:1, ts_id:1, df_id:1)
 100.00% |=======================================>| 131072/131072 blks 2.66s
Synchronizing...
BACKUP (set_id:1, ts_id:3, df_id:2)
 100.00% |=======================================>|  12800/12800  blks 0.16s
Synchronizing...
BACKUP (set_id:1, ts_id:4, df_id:3)
 100.00% |=======================================>|  12800/12800  blks 0.13s
Synchronizing...

Switching an online log file...
Database full backup succeeded
DB disconnected
RMGR backup ends

경로 지정 -o 옵션
C:\tibero_engine>tbrmgr backup -o C:\tibero_backup\tibero6\backup\
==================================================================
= Recovery Manager(RMGR) starts                                  =
=                                                                =
= TmaxData Corporation Copyright (c) 2008-. All rights reserved. =
==================================================================
=============================================
  RMGR - ONLINE backup
=============================================
DB connected
archive log check succeeded
BACKUP (set_id:3, ts_id:0, df_id:0)
 100.00% |=======================================>|  12800/12800  blks 0.19s
Synchronizing...
BACKUP (set_id:3, ts_id:1, df_id:1)
 100.00% |=======================================>| 131072/131072 blks 2.19s
Synchronizing...
BACKUP (set_id:3, ts_id:3, df_id:2)
 100.00% |=======================================>|  12800/12800  blks 0.20s
Synchronizing...
BACKUP (set_id:3, ts_id:4, df_id:3)
 100.00% |=======================================>|  12800/12800  blks 0.16s
Synchronizing...

Switching an online log file...
Database full backup succeeded
DB disconnected
RMGR backup ends
With Archive Log 옵션 적용
C:\tibero_engine>tbrmgr backup --with-archivelog
==================================================================
= Recovery Manager(RMGR) starts                                  =
=                                                                =
= TmaxData Corporation Copyright (c) 2008-. All rights reserved. =
==================================================================

RMGR -o option not used: backed up at RMGR_BACKUP_DEST
=============================================
  RMGR - ONLINE backup
=============================================
DB connected
archive log check succeeded
BACKUP (set_id:2, ts_id:0, df_id:0)
 100.00% |=======================================>|  12800/12800  blks 0.10s
Synchronizing...
BACKUP (set_id:2, ts_id:1, df_id:1)
 100.00% |=======================================>| 131072/131072 blks 2.03s
Synchronizing...
BACKUP (set_id:2, ts_id:3, df_id:2)
 100.00% |=======================================>|  12800/12800  blks 0.19s
Synchronizing...
BACKUP (set_id:2, ts_id:4, df_id:3)
 100.00% |=======================================>|  12800/12800  blks 0.13s
Synchronizing...

Switching an online log file...
Backing up archive log files...
Archivelog log-t0-r0-s4.arc (thread: 0, low_tsn: 177106, next_tsn: 177219) copied
Database full backup succeeded
DB disconnected
RMGR backup ends
체크!!!
set line 200
col START_TIME for a20
col FINISH_TIME for a20
select * from V$BACKUP_SET;


    SET_ID START_TIME           FINISH_TIME           START_TSN FINISH_TSN RESETLOGS_TSN   BASE_SET   SIZE(MB) IS_PARTIAL IS_INCREMENTAL WITH_ARCHIVELOG
---------- -------------------- -------------------- ---------- ---------- ------------- ---------- ---------- ---------- -------------- ---------------
         1 2025/04/15 13:59:11  2025/04/15 13:59:15      177086     177103             0          0       1386 NO         NO             NO
         2 2025/04/15 14:03:54  2025/04/15 14:03:58      177200     177216             0          0       1386 NO         NO             YES
         3 2025/04/15 14:12:19  2025/04/15 14:12:23      177538     177554             0          0       1386 NO         NO             NO

3 rows selected.

arch 옵션준거 > WITH_ARCHIVELOG YES 로 뜬당


SQL> set line 200
SQL> col MIN_LOG_TIME for a20
SQL> col MAX_LOG_TIME for a20
SQL> col RESETLOG_TIME for a20
SQL> select * from V$BACKUP_ARCHIVED_LOG;

    SET_ID    THREAD# MIN_LOG_TSN MAX_LOG_TSN MIN_LOG_TIME         MAX_LOG_TIME         MIN_LOG_SEQUENCE MAX_LOG_SEQUENCE RESETLOG_TSN RESETLOG_TIME
---------- ---------- ----------- ----------- -------------------- -------------------- ---------------- ---------------- ------------ --------------------
         2          0      177106      177219 2025/04/15 13:59:18  2025/04/15 14:04:01                 4                4            0

1 row selected.

With Archive Log 옵션을 적용한 Incremental Backup
C:\tibero_engine>tbrmgr backup -i --with-archivelog -o C:\tibero_backup\tibero6\backup\
==================================================================
= Recovery Manager(RMGR) starts                                  =
=                                                                =
= TmaxData Corporation Copyright (c) 2008-. All rights reserved. =
==================================================================
=============================================
  RMGR - INCREMENTAL backup
=============================================
DB connected
archive log check succeeded
BACKUP (set_id:4, ts_id:0, df_id:0)
 100.00% |=======================================>|  12800/12800  blks 0.03s
Synchronizing...
BACKUP (set_id:4, ts_id:1, df_id:1)
 100.00% |=======================================>| 131072/131072 blks 0.54s
Synchronizing...
BACKUP (set_id:4, ts_id:3, df_id:2)
 100.00% |=======================================>|  12800/12800  blks 0.06s
Synchronizing...
BACKUP (set_id:4, ts_id:4, df_id:3)
 100.00% |=======================================>|  12800/12800  blks 0.06s
Synchronizing...

Switching an online log file...
Backing up archive log files...
Archivelog log-t0-r0-s6.arc (thread: 0, low_tsn: 177557, next_tsn: 181478) copied
Database incremental backup succeeded
DB disconnected
RMGR backup ends
체크!!!
set line 200
col START_TIME for a20
col FINISH_TIME for a20
select * from V$BACKUP_SET;

    SET_ID START_TIME           FINISH_TIME           START_TSN FINISH_TSN RESETLOGS_TSN   BASE_SET   SIZE(MB) IS_PARTIAL IS_INCREMENTAL WITH_ARCHIVELOG
---------- -------------------- -------------------- ---------- ---------- ------------- ---------- ---------- ---------- -------------- ---------------
         1 2025/04/15 13:59:11  2025/04/15 13:59:15      177086     177103             0          0       1386 NO         NO             NO
         2 2025/04/15 14:03:54  2025/04/15 14:03:58      177200     177216             0          0       1386 NO         NO             YES
         3 2025/04/15 14:12:19  2025/04/15 14:12:23      177538     177554             0          0       1386 NO         NO             NO
         4 2025/04/15 14:28:08  2025/04/15 14:28:09      181459     181475             0          3         59 NO         YES            YES

4 rows selected.
아카이브 
SQL> select * from V$BACKUP_ARCHIVED_LOG;

    SET_ID    THREAD# MIN_LOG_TSN MAX_LOG_TSN MIN_LOG_TIME                                                     MAX_LOG_TIME                                                     MIN_LOG_SEQUENCE
---------- ---------- ----------- ----------- ---------------------------------------------------------------- ---------------------------------------------------------------- ----------------
MAX_LOG_SEQUENCE RESETLOG_TSN RESETLOG_TIME
---------------- ------------ ----------------------------------------------------------------
         2          0      177106      177219 2025/04/15 13:59:18                                              2025/04/15 14:04:01                                                             4
               4            0

         4          0      177557      181478 2025/04/15 14:12:26                                              2025/04/15 14:28:12                                                             6
               6            0


2 rows selected.
그냥 옵션없이 냅다 tbrmgr recover 쳤는디 가장 최근 backup set 으로 되나봄

C:\>tbrmgr recover
==================================================================
= Recovery Manager(RMGR) starts                                  =
=                                                                =
= TmaxData Corporation Copyright (c) 2008-. All rights reserved. =
==================================================================
=============================================
  RMGR - recovery
=============================================
Tibero instance terminated (ABNORMAL mode).

info file is deleted.
 unlink failed.
Control file #0 (C:\tibero_data\tibero6\control\c1.ctl) is accessible

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



Tibero 6

TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (MOUNT mode).
DB connected

RMGR BEGIN RESTORE
 full backup set_id: 5
 last incremental backup set_id: 5

Applying FULL BACKUP (set_id:5, ts_id:0, df_id:0)
 100.00% |=======================================>|  12800/12800  blks 0.21s
Synchronizing...
Applying FULL BACKUP (set_id:5, ts_id:1, df_id:1)
 100.00% |=======================================>| 131072/131072 blks 1.65s
Synchronizing...
Applying FULL BACKUP (set_id:5, ts_id:3, df_id:2)
 100.00% |=======================================>|  12800/12800  blks 0.21s
Synchronizing...
Applying FULL BACKUP (set_id:5, ts_id:4, df_id:3)
 100.00% |=======================================>|  12800/12800  blks 0.21s
Synchronizing...
Applying FULL BACKUP (set_id:5, ts_id:5, df_id:4)
 100.00% |=======================================>|  12800/12800  blks 0.21s
Synchronizing...

Database restore succeeded

recoverSQL: ALTER DATABASE RECOVER AUTOMATIC
Database automatic recovery succeeded
DB disconnected

Tibero instance terminated (NORMAL mode).


Tibero 6

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

뭐야 안됐는디요
SQL> select count(*)
   2 from orders;

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

1 row selected.
profile
eungjj
이전 포스트

9. DBeaver 디비버 티베로 연결하기

0개의 댓글