Document Type | Technical Information

Field | Management/Configuration

Applicable Product Versions | Tibero5, Tibero6, Tibero7

Document Number | TADTI212

Overview

This document describes the BMT scenario to verify the proper operation of backup and recovery functions in the TAC environment.

Method

Full Recovery Function After Online Backup

This section explains full recovery after online backup.

Execution

Execution Order	Scenario
1	Create test data Create tablespace Create test user and table
2	Pre-check Check table row count Verify tablespace Verify data
3	Execute and verify Begin Backup
4	Perform hot backup
5	Execute End Backup and perform log switch
6	Insert data and perform log switch
7	Query data
8	Shutdown Tibero and delete all data files
9	Start Tibero, check mount mode and error status
10	Shutdown Tibero and restore hot backup files
11	Copy archivelog files from NODE2 to NODE1
12	Start Tibero in mount mode and perform recovery
13	Start Tibero
14	Query table row count

Result

Execution Order	Scenario
1	Create test data Create tablespace Create test user and table
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	Pre-check Check table row count Verify tablespace Verify data
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.
3	Execute Begin Backup and verify
3	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	Perform hot backup
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
5	Execute End Backup and perform log switch
5	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 data
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	Query data
7	SELECT COUNT() FROM TEST.T1; COUNT() ---------- 50000 1 row selected.
8	Shutdown Tibero and delete all data files
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	Start Tibero, check mount mode and error status
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	Shutdown Tibero and restore hot backup 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
11	Copy archivelog files from NODE2 to NODE1
11	--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	Start Tibero in mount mode and perform recovery
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	Start Tibero
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	Query table row count
14	SELECT COUNT() FROM TEST.T1; COUNT() ---------- 50000 1 row selected.

Full Recovery Function After Offline Backup (Cold Backup)

Execution

Execution Order	Scenario
1	Check backup targets - Control files, redo logs, data files, temp files
2	Query table row count
3	Shutdown Tibero and perform cold backup
4	Start Tibero
5	Insert data
6	Query data
7	Shutdown Tibero and delete all data files
8	Check Tibero mode and error status
9	Shutdown Tibero and restore cold backup files
10	Copy archivelog files from NODE2 to NODE1
11	Start Tibero and perform recovery
12	Shutdown Tibero and start Tibero
13	Query table row count

Result

Execution Order	Scenario
1	Check backup targets - Control files, redo logs, data files, temp files
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	Query table row count
2	SELECT COUNT() FROM TEST.T1; COUNT() ---------- 50000
3	Shutdown Tibero and perform cold backup -- 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	Start Tibero
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	Insert data
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	Query data
6	SELECT COUNT() FROM TEST.T1; COUNT() ---------- 100000 1 row selected.
7	Shutdown Tibero and delete all data files
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	Start Tibero and check mode and error status
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	Shutdown Tibero and restore cold backup files
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
10	Copy archivelog files from NODE2 to NODE1
10	--NODE2 scp /data/tta02/tbarch/*.arc tta01@xxx.xxx.x.x:/data/tta02/tbarch
11	Start 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.
12	Shutdown 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).
13	Query table row count
13	select count() from test.t1; COUNT() ---------- 100000

Media Recovery Function

Execution

Execution Order	Scenario
1	Query table row count
2	Execute Begin Backup
3	Perform hot backup
4	Execute End Backup and perform log switch
5	Query sysdate
6	Insert data
7	Query table row count
8	Backup control file and perform log switch
9	Shutdown Tibero and delete all data files (including Redo Logs)
10	Start Tibero, check mount mode and error status
11	Shutdown Tibero and restore hot backup
12	Start no-mount and recover control file
13	Copy archivelog files from NODE2 to NODE1
14	Start Tibero in mount mode and perform recovery
15	Shutdown Tibero
16	Start Tibero and complete recovery
17	Check row count

Result

Execution Order	Scenario
1	Query table row count
1	select count() from test.t1; COUNT() ---------- 100000
2	Execute Begin Backup
2	alter database begin backup; Database altered.
3	Perform hot backup
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
4	Execute End Backup and perform log switch
4	--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 must also perform log switch -- Otherwise, recovery will fail with archive file too old error SQL> ALTER SYSTEM SWITCH LOGFILE; System altered. SQL> ALTER SYSTEM SWITCH LOGFILE; System altered.
5	Query sysdate
5	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	Insert data
6	SQL> INSERT INTO TEST.T1 (ID) VALUES ('444444'); 1 row inserted. SQL> commit; Commit completed.
7	Query table row count
7	SQL> SELECT COUNT() FROM TEST.T1; COUNT() ---------- 100001
8	Backup control file and perform log switch
	SQL> alter database backup controlfile to trace as '/home/tibero/ctl_bak.sql' reuse resetlogs; Database altered. -- NODE1, NODE2 -- NODE2 must also perform 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	Shutdown Tibero and delete all data files (including Redo Logs)
	--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	Start Tibero and check mode and error status
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	Shutdown Tibero and restore hot backup
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	Start no-mount and recover control file
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 ➤ ---- Removed Set #2. NORESETLOGS case tibero@localhost /tibero ➤ tbsql sys/tibero tbSQL 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Connected to Tibero. SQL> @/home/tibero/ctl_bak.sql Control File created. tibero@localhost /tibero ➤ tbdown immediate Tibero instance terminated (IMMEDIATE mode).
13	Copy archivelog files from NODE2 to NODE1
13	--NODE2 scp /tibero/tbarch/*arc tibero@xxx.xxx.xxx.xxx:/tibero/tbarch tibero@xxx.xxx.xxx.xxx's
14	Start Tibero in mount mode and perform recovery
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. -- Opening ctl.sql shows commands adding THREAD1 logfiles 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	Shutdown Tibero
15	tibero@localhost /tibero ➤ tbdown immediate Tibero instance terminated (IMMEDIATE mode).
16	Start Tibero and complete recovery
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	Check row count
16	SQL> SELECT COUNT() FROM TEST.T1; COUNT() ---------- 100001 1 row selected.

Partial Backup Function

This section explains incremental and differential backups.

Execution (Incremental Backup)

Execution Order	Scenario
1	Online Full Backup via Recovery Manager (tbrmgr)
2	Query table row count
3	Insert data
4	Query table row count
5	Incremental Backup 1
6	Insert data
7	Query table row count
8	Incremental Backup 2
9	Insert data
10	Query table row count
11	Incremental Backup 3
12	Shutdown NODE1 and NODE2 and delete data files
13	Start Tibero, check mount mode and error status
14	Shutdown Node1, Node2 and tbcm
15	Organize tip files on Node1
16	Perform tbrmgr Recovery
17	Query count (should match Incremental Backup 3 point)
18	Start tbcm and Node1, Node2
19	Query count (should match Incremental Backup 3)

Results (Incremental Backup)

Step	Scenario
1	Online Full Backup using Recovery Manager (tbrmgr)
1	[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	Check table row count
2	SQL> select count() from test.t1; COUNT() ---------- 0 1 row selected.
3	Insert 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.
4	Check table row count
	SQL> SELECT COUNT() FROM TEST.T1; COUNT() ---------- 50000 1 row selected.
5	Incremental Backup 1
5	[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	Insert data
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	Check table row count
7	SQL> SELECT COUNT() FROM TEST.T1; COUNT() ---------- 100000 1 row selected.
8	Incremental Backup 2
8	[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	Insert data
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	Check table row count
10	SQL> SELECT COUNT() FROM TEST.T1; COUNT() ---------- 150000
11	Incremental Backup 3
11	[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	Shutdown Tibero and delete data files
12	tbdown immediate Tibero instance terminated (IMMEDIATE mode). rm -rf /share/tac/*.dtf
13	Start Tibero and check mount mode and error state
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).
14	Shutdown Node1, Node2 and stop tbcm
14	[root@tech-tac0 tac]$ tbdown immediate Tibero instance terminated (IMMEDIATE mode). [root@tech-tac0 tac]$ tbcm -d CM DOWN SUCCESS!
15	Modify Node1 tip file
15	############ 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 Comment out these lines in the file
16	tbrmgr Recovery
16	[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
17	tbdown and restore tip file
17	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
18	Start tbcm and Node1, Node2
18	[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	Check row count (should match Incremental Backup 3 point)
19	SQL> select count() from test.t1; COUNT() ---------- 150000

Execution (Cumulative Backup)

Step	Scenario
1	Copy tbrmgr full backup files
2	Check table row count
3	Insert data
4	Check table row count
5	Cumulative Backup 1
6	Insert data
7	Check table row count
8	Cumulative Backup 2
9	Insert data
10	Check table row count
11	Cumulative Backup 3
12	Shutdown NODE1, NODE2 and delete data files
13	Start Tibero and check mount mode and error state
14	Shutdown NODE1, NODE2 and stop tbcm
15	Modify NODE1 tip file – recovery must be done in single mode
16	tbrmgr Recovery
17	tbdown and restore tip file
18	Start tbcm and NODE1, NODE2
19	Check row count (should match Cumulative Backup 3 point)

Results (Cumulative Backup)

Step	Scenario
1	Copy tbrmgr full backup files
1	cp -r $TB_BACKUP/full $TB_BACKUP/cumulative
2	Check table row count
2	select count() from test.t1; COUNT() ---------- 150000 1 row selected.
3	Insert data
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	Check table row count
4	SQL> select count() from test.t1; COUNT() ---------- 200000 1 row selected.
5	Cumulative Backup 1
5	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	Insert data
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	Check table row count
7	SQL> SELECT COUNT() FROM TEST.T1; COUNT() ---------- 250000 1 row selected.
8	Cumulative Backup 2
8	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	Insert data
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	Check table row count
10	SQL> SELECT COUNT() FROM TEST.T1; COUNT() ---------- 300000 1 row selected
11	Cumulative Backup 3
11	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
12	Shutdown Node1, Node2 and delete data files
12	tbdown immediate Tibero instance terminated (IMMEDIATE mode). rm -rf *.dtf
13	Start Tibero and check mount mode and error state
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.
14	Shutdown NODE1, NODE2 and stop tbcm
14	-- Node1 , Node2 tbdown immediate Tibero instance terminated (IMMEDIATE mode). tbcm -d CM DOWN SUCCESS!
15	Modify NODE1 tip file – recovery must be done in single mode
15	#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
16	tbrmgr Recovery
16	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
17	tbdown and restore tip file
17	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
18	Start tbcm and NODE1, NODE2
18	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	Check row count (should match Cumulative Backup 3 point)
19	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.

Related to

Search

Welcome to Tibero GTS!

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

Overview

Method

Full Recovery Function After Online Backup

Execution

Result

Full Recovery Function After Offline Backup (Cold Backup)

Execution

Result

Media Recovery Function

Execution

Result

Partial Backup Function

Execution (Incremental Backup)

Results (Incremental Backup)

Execution (Cumulative Backup)

Results (Cumulative Backup)

업무 외 시간 안내

Search

Welcome to Tibero GTS!

Overview

Method

Full Recovery Function After Online Backup

Execution

Result

Full Recovery Function After Offline Backup (Cold Backup)

Execution

Result

Media Recovery Function

Execution

Result

Partial Backup Function

Execution (Incremental Backup)

Results (Incremental Backup)

Execution (Cumulative Backup)

Results (Cumulative Backup)