Skip to main content
๐Ÿ““ Tibero Online Manual Click here ๐Ÿ““

Search

Welcome to Tibero GTS!

TTA BMT Function Verification Scenario (SINGLE Configuration) - Backup/Recovery

Document Type | Technical Information

Field | Management/Configuration 

Applicable Product Versions | Tibero5, Tibero6, Tibero7

Document Number | TADTI215

 

Overview

This document describes the BMT scenario to verify the normal operation of backup and recovery functions in a SINGLE environment.

 
 

Method

Complete Recovery Function After Online Backup

 

Execution

Execution OrderScenario
1

Create test data

  • Create tablespaces
  • Create test user and tables
 2

Pre-check

  • Check table row count
  • Check tablespaces
  • Verify data
 3Perform and verify Begin Backup
 4Perform hot backup
 5Perform End Backup and log switch
 6Insert data and perform log switch
 7 Query data
 8Shutdown Tibero and delete all data files
 9Start Tibero, check mount mode and error status
 10Shutdown Tibero and restore hot backup files
 11Start Tibero in mount mode and perform recovery
 12Start Tibero
 13Query table row count

 

Results

Execution OrderScenario
1

Create test data

  • Create tablespaces
  • Create test user and tables

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

Pre-check

  • Check table row count
  • Check tablespaces
  • Verify data

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
 

 3Perform and verify Begin 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.
 

 4Perform hot backup

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

 5Perform End Backup and log switch

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
 

 6Insert data and perform log switch

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 Query data

SELECT COUNT(*) FROM TEST.T1;

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

1 row selected.

 8Shutdown Tibero and delete all data files

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

rm -rf /tibero/data

 9Start Tibero, check mount mode and error status

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

Shutdown Tibero and restore hot backup files

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

 11Start Tibero in mount mode and perform recovery

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

 12Start Tibero

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

 13Query table row count

SELECT COUNT(*) FROM TEST.T1;

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

1 row selected.

 

Complete Recovery Function After Offline Backup (Cold Backup)

 

Execution

Execution OrderScenario
 1

Check backup targets

- Control files, redo logs, data files, temp files

 2Query table row count
 3Shutdown Tibero and perform cold backup
 4Start Tibero
 5Insert data
 6Query data
 7Shutdown Tibero and delete all data files
 8Check Tibero mode and error status
 9Shutdown Tibero and restore cold backup files
 10Start Tibero and perform recovery
 11Shutdown Tibero and start Tibero
12Query table row count

 

Results

Execution OrderScenario
 1

Check backup targets

- Control files, redo logs, data files, temp files

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.

 2Query table row count

SELECT COUNT(*) FROM TEST.T1;

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

 3

Shutdown Tibero and perform cold backup

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

cp -Rp /tibero/data /tibero/data_cold_backup

 

 4Start Tibero

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

 5Insert data

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.

 6Query data

SELECT COUNT(*) FROM TEST.T1;

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

 7Shutdown Tibero and delete all data files

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

rm -rf /tibero/data

 8Start Tibero and check mode and error status

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.

 9Shutdown Tibero and restore cold backup files

tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

 

mv /tibero/data_cold_backup /tibero/data

 10Start Tibero and perform recovery
 

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.

 11Shutdown Tibero and start Tibero
 

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

12Query table row count

select count(*) from test.t1;

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

 

Media Recovery Function

 

Execution

Execution OrderScenario
1Query table row count
2Perform Begin Backup
3Perform hot backup
4Perform End Backup and log switch
5Query Sysdate
6Insert data
7Query table row count
8Backup control file and perform log switch
9Shutdown Tibero and delete all data files (including Redo Logs)
10Start Tibero, check mount mode and error status
11Shutdown Tibero and restore hot backup files
12Start in nomount mode and recover control file
13Start in mount mode and perform recovery
14Shutdown Tibero
15Start Tibero and complete recovery
16Verify row count

 

Results

Execution OrderScenario
1Query table row count

select count(*) from test.t1;

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

2Perform Begin Backup

alter database begin backup;

Database altered.

3Perform hot backup

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

4Perform End Backup and log switch

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.

5Query Sysdate

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.

6Insert data

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

1 row inserted.

 

SQL> commit;

Commit completed.

7Query table row count

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

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

8Backup control file and perform log switch
 

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.

9Shutdown Tibero and delete all data files (including Redo Logs)
 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 .
10Start Tibero, check mode and error status

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.

11Shutdown Tibero and restore hot backup files

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

12Start in nomount mode and recover control file

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

13Start in mount mode and perform recovery

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.

14Shutdown Tibero

tibero@localhost /tibero  โžค tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

15Start Tibero and complete recovery

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.

16Verify row count

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

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

1 row selected.

 

Partial Backup Function

Explanation of incremental and differential backups.

 

Execution (Incremental Backup)

Execution OrderScenario
1Online Full Backup using Recovery Manager (tbrmgr)
2Query table row count
3Insert data
4Query table row count
5Incremental Backup 1
6Insert data
7Query table row count
8Incremental Backup 2
9Insert data
10Query table row count
11Incremental Backup 3
12Shutdown Tibero and delete data files
13Start Tibero, check mount mode and error status, then shutdown
14Recovery with tbrmgr
15Query row count (should match Incremental Backup 3 point)

 

Results (Incremental Backup)

Execution OrderScenario
1Online Full Backup using Recovery Manager (tbrmgr)

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

2Query table row count

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

3Insert data
 

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.

4Query table row count
 

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

6Insert data

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.
 

7Query table row count

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

9Insert data

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.

10Query table row count

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

12Shutdown Tibero and delete data files

tibero@localhost /tibero/BACKUP  โžค tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

tibero@localhost /tibero/BACKUP  โžค rm -rf /tibero/data/*.dtf

13Start Tibero, check mount mode and error status, then shutdown

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

14Recovery with tbrmgr

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:  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

15Query row count (should match Incremental Backup 3 point)

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.
 

 

Execution (Differential Backup)

Execution OrderScenario
1Copy tbrmgr full backup files
2Query table row count
3Insert data
4Query table row count
5Cumulative Backup 1
6Insert data
7Query table row count
8Cumulative Backup 2
9Insert data
10Query table row count
11Cumulative Backup 3
12Shutdown Tibero and delete all data files
13Start Tibero, check mount mode and error status, then shut down again
14tbrmgr Recovery
15Query row count (should match Cumulative Backup 3 point)

 

 

Results (Differential Backup)

Execution OrderScenario
1Copy tbrmgr full backup files
cp -r $TB_BACKUP/full $TB_BACKUP/cumulative
2Query table row count

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.

3Insert data

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.

4Query table row count

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

6Insert data

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.

7Query table row count

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

9Insert data

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.
 

10Query table row count

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

12Shutdown Tibero and delete all data files

tibero@localhost /tibero  โžค tbdown

Tibero instance terminated (NORMAL mode).

 

tibero@localhost /tibero  โžค rm /tibero/data/*.dtf

13Start Tibero, check mount mode and error status, then shut down again

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

15Query row count (should match Cumulative Backup 3 point)

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

 

 

Related to