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
|
| 2 | Pre-check
|
| 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
|
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.
Granted. conn test/test
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
|
select count(*) from test.t1; COUNT(*) 0 1 row selected.
SELECT TABLESPACE_NAME FROM DBA_TABLESPACES;
--------------------------------------------------------------------------------
SELECT FILE_NAME FROM DBA_DATA_FILES; | |
| 3 | Execute Begin Backup and verify |
ALTER DATABASE BEGIN BACKUP; Database altered. SELECT * FROM V$BACKUP; FILE# STATUS CHANGE# TIME exit | |
| 4 | Perform hot backup |
ls -al /dev/raw
| |
| 5 | Execute End Backup and perform 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 | |
| 6 | Insert data |
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 |
SELECT COUNT(*) FROM TEST.T1; COUNT(*) 50000 1 row selected. | |
| 8 | Shutdown Tibero and delete all data files |
- Node1
| |
| 9 | Start Tibero, check mount mode and error status |
tbboot ********************************************************
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 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 |
| 11 | Copy archivelog files from NODE2 to NODE1 |
| --NODE2 scp /data/tta02/tbarch/*.arc tta01@xxx.xxx.xx.x:/data/tta01/tbarch tta01@192.168.53.186's password: log-t1-r0-s1.arc 100% 82MB 10.3MB/s 00:08 | |
| 12 | Start Tibero in mount mode and perform recovery |
tbboot mount Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. 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 |
-- NODE1 tbboot Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
-- NODE2 tbboot Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 14 | Query table row count |
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 |
tbsql sys/tibero tbSQL 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Connected to Tibero.
SELECT NAME FROM V$CONTROLFILE; NAME
SELECT MEMBER FROM V$LOGFILE; MEMBER 6 rows selected.
SELECT FILE_NAME FROM DBA_DATAFILES; FILE_NAME
SELECT FILE_NAME FROM DBA_TEMP_FILES; FILE_NAME
| |
| 2 | Query table row count |
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 --Log --Data --Temp |
| 4 | Start Tibero |
-- NODE1 tbboot Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
-- NODE2 tbboot Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 5 | Insert 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. | |
| 6 | Query data |
SELECT COUNT(*) FROM TEST.T1; COUNT(*) 100000 | |
| 7 | Shutdown Tibero and delete all data files |
-- 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 | |
| 8 | Start Tibero and check mode and error status |
tbboot ******************************************************** * Current server mode is MOUNT. | |
| 9 | Shutdown Tibero and restore cold backup files |
tbdown immediate Tibero instance terminated (IMMEDIATE mode).
dd if=$TB_HOME/${TB_SID}_bak/raw51 of=/dev/raw/raw51 bs=8k | |
| 10 | Copy archivelog files from NODE2 to NODE1 |
| --NODE2 scp /data/tta02/tbarch/*.arc tta01@xxx.xxx.x.x:/data/tta02/tbarch | |
| 11 | Start Tibero and perform recovery |
tbboot mount Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. 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 Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 13 | Query table row count |
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 |
select count(*) from test.t1; COUNT(*) 100000 | |
| 2 | Execute Begin Backup |
alter database begin backup; Database altered. | |
| 3 | Perform hot backup |
| 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 |
--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 SQL> ALTER SYSTEM SWITCH LOGFILE; System altered. SQL> ALTER SYSTEM SWITCH LOGFILE; System altered. | |
| 5 | Query sysdate |
SQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'; Session altered.
SYSDATE 1 row selected. | |
| 6 | Insert data |
SQL> INSERT INTO TEST.T1 (ID) VALUES ('444444'); 1 row inserted.
SQL> commit; Commit completed. | |
| 7 | Query table row count |
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 SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered.
SQL> exit | |
| 9 | Shutdown Tibero and delete all data files (including Redo Logs) |
--NODE1, NODE2 --log delete dd if=/dev/zero of=/dev/raw/raw4 count=1 --ctl delete | |
| 10 | Start Tibero and check mode and error status |
tibero@localhost โค tbboot ********************************************************
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 11 | Shutdown Tibero and restore hot backup |
tibero@localhost โค tbdown immediate Tibero instance terminated (IMMEDIATE mode).
| |
| 12 | Start no-mount and recover control file |
tibero@localhost /tibero โค tbboot nomount Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
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 |
| --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 |
tibero@localhost /tibero โค tbboot mount Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. 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 4 '/dev/raw/raw7' SIZE 500M; SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 5 '/dev/raw/raw8' SIZE 500M; SQL> ALTER DATABASE ENABLE PRIVATE THREAD 1; 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'; | |
| 15 | Shutdown Tibero |
tibero@localhost /tibero โค tbdown immediate Tibero instance terminated (IMMEDIATE mode). | |
| 16 | Start Tibero and complete recovery |
tibero@localhost /tibero โค tbboot resetlogs Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. 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 |
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) |
[root@tech-tac0 /]$ export TB_BACKUP=$TB_HOME/backup ============================================================================== ============================================================================== BACKUP (set_id: 1, ts_id: 0, df_id: 0) Switching an online logfile... Backing up the control file... Database backup succeeded RMGR backup ends tbSQL 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Connected to Tibero.
SQL> conn test/test
| |
| 2 | Check table row count |
SQL> select count(*) from test.t1; COUNT(*) 1 row selected. | |
| 3 | Insert data |
SQL> INSERT INTO TEST.T1
SQL> COMMIT; | |
| 4 | Check table row count |
SQL> SELECT COUNT(*) FROM TEST.T1; COUNT(*) 1 row selected. | |
| 5 | Incremental Backup 1 |
[root@tech-tac0 /]$ tbrmgr backup -o $TB_BACKUP/incremental -i -v ============================================================================== ============================================================================== BACKUP (set_id: 2, ts_id: 0, df_id: 0) Switching an online logfile... Backing up the control file... Database backup succeeded RMGR backup ends | |
| 6 | Insert data |
tbsql sys/tibero tbSQL 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Connected to Tibero.
50000 rows inserted.
SQL> COMMIT; Commit completed. | |
| 7 | Check table row count |
SQL> SELECT COUNT(*) FROM TEST.T1; COUNT(*) 1 row selected. | |
| 8 | Incremental Backup 2 |
[root@tech-tac0 /]$ tbrmgr backup -o $TB_BACKUP/incremental -i -v ============================================================================== ============================================================================== BACKUP (set_id: 3, ts_id: 0, df_id: 0) Switching an online logfile... Backing up the control file... Database backup succeeded RMGR backup ends | |
| 9 | Insert data |
tbsql sys/tibero tbSQL 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Connected to Tibero. SQL> INSERT INTO TEST.T1 50000 rows inserted. SQL> COMMIT; Commit completed. | |
| 10 | Check table row count |
SQL> SELECT COUNT(*) FROM TEST.T1; COUNT(*) | |
| 11 | Incremental Backup 3 |
[root@tech-tac0 /]$ tbrmgr backup -o $TB_BACKUP/incremental -i -v ============================================================================== ============================================================================== BACKUP (set_id: 4, ts_id: 0, df_id: 0) Switching an online logfile... Backing up the control file... Database backup succeeded RMGR backup ends | |
| 12 | Shutdown Tibero and delete data files |
tbdown immediate Tibero instance terminated (IMMEDIATE mode).
rm -rf /share/tac/*.dtf | |
| 13 | Start Tibero and check mount mode and error state |
[root@tech-tac0 tac]$ tbboot ********************************************************
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero instance terminated (IMMEDIATE mode). | |
| 14 | Shutdown Node1, Node2 and stop tbcm |
[root@tech-tac0 tac]$ tbdown immediate Tibero instance terminated (IMMEDIATE mode). [root@tech-tac0 tac]$ tbcm -d | |
| 15 | Modify Node1 tip file |
############ TAC (Tibero Active Cluster) ## cm0 Comment out these lines in the file | |
| 16 | tbrmgr Recovery |
[root@tech-tac0 tac]$ tbrmgr recover -o $TB_BACKUP/incremental -v ============================================================================== ============================================================================== tbdown failed. proc info file is deleted. Control file #0 (/share/tac/tbctl1/c1.ctl) is accessible All control files are accessible. No need to restore the backup control file.
Change core dump dir to /root/tibero_engine/bin/prof. Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
RESTORE (set_id: 1, ts_id: 0, df_id: 0) - FULL BACKUP Database restoration succeeded recoverSQL: ALTER DATABASE RECOVER AUTOMATIC Shutting down the instance...
Booting up the instance... Change core dump dir to /root/tibero_engine/bin/prof. ********************************************************
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 17 | tbdown and restore tip file |
tbdown immediate Tibero instance terminated (IMMEDIATE mode). CLUSTER_DATABASE=Y ## cm0 | |
| 18 | Start tbcm and Node1, Node2 |
[root@tech-tac0 tac]$ tbcm -b TBCM 7.1.1 (Build 300983) TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero cluster manager started up. [root@tech-tac0 tac]$ cmrctl show Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 19 | Check row count (should match Incremental Backup 3 point) |
SQL> select count(*) from test.t1; COUNT(*) |
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 |
| cp -r $TB_BACKUP/full $TB_BACKUP/cumulative | |
| 2 | Check table row count |
select count(*) from test.t1; COUNT(*) 1 row selected. | |
| 3 | Insert data |
SQL> INSERT INTO TEST.T1 50000 rows inserted. SQL> commit; Commit completed. | |
| 4 | Check table row count |
SQL> select count(*) from test.t1; COUNT(*) 1 row selected. | |
| 5 | Cumulative Backup 1 |
tbrmgr backup -o $TB_BACKUP/cumulative -C -v ============================================================================== ============================================================================== BACKUP (set_id: 5, ts_id: 0, df_id: 0) Switching an online logfile... Backing up the control file... Database backup succeeded RMGR backup ends | |
| 6 | Insert data |
SQL> INSERT INTO TEST.T1 50000 rows inserted. SQL> commit; Commit completed. | |
| 7 | Check table row count |
SQL> SELECT COUNT(*) FROM TEST.T1; COUNT(*) 1 row selected. | |
| 8 | Cumulative Backup 2 |
tbrmgr backup -o $TB_BACKUP/cumulative -C -v ============================================================================== ============================================================================== BACKUP (set_id: 6, ts_id: 0, df_id: 0) Switching an online logfile... Backing up the control file... Database backup succeeded RMGR backup ends | |
| 9 | Insert data |
SQL> INSERT INTO TEST.T1 50000 rows inserted. SQL> commit; Commit completed. | |
| 10 | Check table row count |
SQL> SELECT COUNT(*) FROM TEST.T1; COUNT(*) 1 row selected | |
| 11 | Cumulative Backup 3 |
tbrmgr backup -o $TB_BACKUP/cumulative -C -v ============================================================================== ============================================================================== BACKUP (set_id: 7, ts_id: 0, df_id: 0) Switching an online logfile... Backing up the control file... Database backup succeeded RMGR backup ends | |
| 12 | Shutdown Node1, Node2 and delete data files |
tbdown immediate Tibero instance terminated (IMMEDIATE mode).
rm -rf *.dtf | |
| 13 | Start Tibero and check mount mode and error state |
tbboot ********************************************************
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 14 | Shutdown NODE1, NODE2 and stop tbcm |
-- Node1 , Node2 tbdown immediate Tibero instance terminated (IMMEDIATE mode).
tbcm -d | |
| 15 | Modify NODE1 tip file โ recovery must be done in single mode |
#CLUSTER_DATABASE=Y ## cm0 | |
| 16 | tbrmgr Recovery |
tbrmgr recover -o $TB_BACKUP/cumulative -v ============================================================================== ============================================================================== Tibero instance terminated (ABNORMAL mode). info file is deleted. Control file #0 (/share/tac/tbctl1/c1.ctl) is accessible All control files are accessible. No need to restore the backup control file.
Change core dump dir to /root/tibero_engine/bin/prof. Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
RESTORE (set_id: 1, ts_id: 0, df_id: 0) - FULL BACKUP Database restoration succeeded recoverSQL: ALTER DATABASE RECOVER AUTOMATIC Shutting down the instance...
Booting up the instance... Change core dump dir to /root/tibero_engine/bin/prof. ********************************************************
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 17 | tbdown and restore tip file |
CLUSTER_DATABASE=Y ## cm0 | |
| 18 | Start tbcm and NODE1, NODE2 |
tbcm -b TBCM 7.1.1 (Build 300983) TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero cluster manager started up. [root@tech-tac0 cumulative]$ tbboot Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. | |
| 19 | Check row count (should match Cumulative Backup 3 point) |
tbsql sys/tibero tbSQL 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Connected to Tibero. COUNT(*) 1 row selected. |