Skip to main content

Search

Welcome to Tibero GTS!

Additional Recovery After Incomplete Recovery by Applying New Archive Files

Document Type | Technical Information

Category | Backup/Recovery

Applicable Product Version | Tibero 7.2.3

Document Number | TBATI043

 

Overview

This document describes how to perform additional recovery by applying new archive files after incomplete recovery in Tibero.
 
 

Test Configuration Environment

  • Server Name: Tibero
  • OS version: CentOS Stream release 10 (Coughlan)
  • DB Version: Tibero 7.2.3

 

 

Method

 

Use Case

This is a method that can be used to minimize downtime of the AS-IS system when building the TO-BE system using the AS-IS backup.

After copying the AS-IS backup and the archive logs created up to that point to the TO-BE system, perform incomplete recovery on the TO-BE system up to the copied archive logs. Then, without opening the TO-BE system with resetlogs, copy the AS-IS archive logs that were created during the TO-BE system recovery process again to the TO-BE system and continue with the recovery in succession.

 

Scenario

This scenario was conducted on a single instance, and in the case of TAC, a process to register the resource in advance is required.

Additionally, due to environmental constraints, one machine was used for both asis and tobe roles, so engine installation and environment file settings are omitted.

 

Create Test User

[tibero@node1 ~]$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> create user test identified by test;

User 'TEST' created.

SQL> grant dba to test;

Granted.

 

Create Test Table

SQL> conn test/test
Connected to Tibero.

SQL> CREATE TABLE RECOVERY_TEST (
    SEQ NUMBER PRIMARY KEY,
    DESCRIPTION VARCHAR2(100)
);   2    3    4 

Table 'RECOVERY_TEST' created.

 

Database Backup

(Archive switch required after end backup)
SQL> alter database begin backup;

Database altered.

SQL> !cp /home/tibero/tbdata/*.dtf /home/tibero/backup/
SQL> alter database backup controlfile to trace as '/home/tibero/c1.sql' resetlogs;

Database altered.

SQL> alter database end backup;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

 

Load Test Data 1

SQL> INSERT INTO RECOVERY_TEST VALUES (1, '1');

1 row inserted.

SQL> COMMIT;

Commit completed.

 

Check Current Archive Sequence and Switch

SQL> SELECT SEQUENCE# FROM V$ARCHIVED_LOG ORDER BY 1;

 SEQUENCE#
----------
         3

1 row selected.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

 

Load Test Data 2~5

SQL> INSERT INTO RECOVERY_TEST VALUES (2, '2');

1 row inserted.

SQL> COMMIT;

Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> 
SQL> 
SQL> INSERT INTO RECOVERY_TEST VALUES (3, '3');

1 row inserted.

SQL> COMMIT;

Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> 
SQL> 
SQL> INSERT INTO RECOVERY_TEST VALUES (4, '4');

1 row inserted.

SQL> COMMIT;

Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> 
SQL> 
SQL> INSERT INTO RECOVERY_TEST VALUES (5, '5');

1 row inserted.

SQL> COMMIT;

Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

 

Check Loaded Data and Shutdown

SQL> SELECT SEQ FROM RECOVERY_TEST ORDER BY 1;

       SEQ
----------
         1
         2
         3
         4
         5

5 rows selected.

SQL> q
Disconnected.
[tibero@node1 ~]$ tbdown

Tibero instance terminated (NORMAL mode).

 

Recreate Control File for Incomplete Recovery

[tibero@node1 ~]$ tbboot nomount
Change core dump dir to /home/tibero/tibero7/bin/prof.
/usr/bin/pstack or /usr/bin/gstack is required to dump the callstack.
****************************************************
* The following path was not found.
* /usr/bin/pstack or /usr/bin/gstack
* pstack or gstack is required to dump the callstack.
****************************************************
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NOMOUNT mode).
[tibero@node1 ~]$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> @c1

Control File created.

SQL> q
Disconnected.

[tibero@node1 ~]$ tbdown

Tibero instance terminated (NORMAL mode).

 

Move Backup Files and Archives

In real situations, only copy the archives created on asis.
[tibero@node1 ~/backup]$ cd /home/tibero/backup/
[tibero@node1 ~/backup]$ ls -rlt
Total 160160
-rw-------. 1 tibero dba  60817408 Dec 16  16:24 syssub001.dtf
-rw-------. 1 tibero dba 104857600 Dec 16  16:24 system001.dtf
-rw-------. 1 tibero dba 209715200 Dec 16  16:24 undo001.dtf
-rw-------. 1 tibero dba 104857600 Dec 16  16:24 temp001.dtf
-rw-------. 1 tibero dba 104857600 Dec 16  16:24 usr001.dtf
[tibero@node1 ~/backup]$ cp * /home/tibero/tbdata
[tibero@node1 ~]$ cd /home/tibero/tbarch
[tibero@node1 ~/tbarch]$ ls -rlt
Total 212
-rw-------. 1 tibero dba    512 Dec 16  16:23 log-t0-r45122-s1.arc
-rw-------. 1 tibero dba 171008 Dec 16  16:24 log-t0-r45122-s2.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s3.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s4.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s5.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s6.arc
-rw-------. 1 tibero dba   5120 Dec 16  16:24 log-t0-r45122-s7.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s8.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s9.arc
-rw-------. 1 tibero dba   2048 Dec 16  16:25 log-t0-r45122-s10.arc
-rw-------. 1 tibero dba   2048 Dec 16  16:25 log-t0-r45122-s11.arc
[tibero@node1 ~/tbarch]$ mkdir notyet
[tibero@node1 ~/tbarch]$ mv log-t0-r45122-s10.arc log-t0-r45122-s11.arc log-t0-r45122-s9.arc notyet/
[tibero@node1 ~/tbarch]$ ls -rlt
Total 200
-rw-------. 1 tibero dba    512 Dec 16  16:23 log-t0-r45122-s1.arc
-rw-------. 1 tibero dba 171008 Dec 16  16:24 log-t0-r45122-s2.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s3.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s4.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s5.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s6.arc
-rw-------. 1 tibero dba   5120 Dec 16  16:24 log-t0-r45122-s7.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s8.arc
drwxr-xr-x. 2 tibero dba     92 Dec 16  16:27 notyet

 

First Incomplete Recovery After Mount Mode Startup

[tibero@node1 ~/backup]$ tbboot mount
Change core dump dir to /home/tibero/tibero7/bin/prof.
/usr/bin/pstack or /usr/bin/gstack is required to dump the callstack.
****************************************************
* The following path was not found.
* /usr/bin/pstack or /usr/bin/gstack
* pstack or gstack is required to dump the callstack.
****************************************************
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
[tibero@node1 ~/backup]$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> select * from v$archive_dest_files;

NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s1.arc
         0          1         45122
2025/12/16
       45123             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s2.arc
         0          2         45123
2025/12/16
       45238             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s3.arc
         0          3         45238
2025/12/16
       45240             45122
2025/12/16


NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s4.arc
         0          4         45240
2025/12/16
       45243             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s5.arc
         0          5         45243
2025/12/16
       45245             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s6.arc
         0          6         45245
2025/12/16
       45248             45122
2025/12/16


NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s7.arc
         0          7         45248
2025/12/16
       45274             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s8.arc
         0          8         45274
2025/12/16
       45279             45122
2025/12/16


8 rows selected.

SQL> alter database recover automatic;
TBR-1147: Need log file (thread 0 seq 9) to recover from TSN 45279.
Recovery done until 2025/12/16 16:25:04 TSN 45277.
Recovery is incomplete and resetlogs is required.

[tibero@node1 ~/backup]$ tbdown

Tibero instance terminated (NORMAL mode).

 

Move Additional Archives for Recovery

In real situations, copy the additional ASIS archives generated during TOBE recovery.
[tibero@node1 ~/backup]$ cd /home/tibero/tbarch/
[tibero@node1 ~/tbarch]$ ls -rlt
Total 200
-rw-------. 1 tibero dba    512 Dec 16  16:23 log-t0-r45122-s1.arc
-rw-------. 1 tibero dba 171008 Dec 16  16:24 log-t0-r45122-s2.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s3.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s4.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s5.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s6.arc
-rw-------. 1 tibero dba   5120 Dec 16  16:24 log-t0-r45122-s7.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s8.arc
drwxr-xr-x. 2 tibero dba     92 Dec 16  16:27 notyet
[tibero@node1 ~/tbarch]$ cd notyet/
[tibero@node1 ~/tbarch/notyet]$ ls -rlt
Total 12
-rw-------. 1 tibero dba 1536 Dec 16  16:25 log-t0-r45122-s9.arc
-rw-------. 1 tibero dba 2048 Dec 16  16:25 log-t0-r45122-s10.arc
-rw-------. 1 tibero dba 2048 Dec 16  16:25 log-t0-r45122-s11.arc
[tibero@node1 ~/tbarch/notyet]$ mv log-t0-r45122-s9.arc ..
[tibero@node1 ~/tbarch/notyet]$ cd ..
[tibero@node1 ~/tbarch]$ ls -rlt
Total 204
-rw-------. 1 tibero dba    512 Dec 16  16:23 log-t0-r45122-s1.arc
-rw-------. 1 tibero dba 171008 Dec 16  16:24 log-t0-r45122-s2.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s3.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s4.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s5.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s6.arc
-rw-------. 1 tibero dba   5120 Dec 16  16:24 log-t0-r45122-s7.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s8.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s9.arc
drwxr-xr-x. 2 tibero dba     64 Dec 16  16:31 notyet

 

Second Incomplete Recovery After Mount Mode Startup

[tibero@node1 ~/tbarch]$ tbboot mount
Change core dump dir to /home/tibero/tibero7/bin/prof.
/usr/bin/pstack or /usr/bin/gstack is required to dump the callstack.
****************************************************
* The following path was not found.
* /usr/bin/pstack or /usr/bin/gstack
* pstack or gstack is required to dump the callstack.
****************************************************
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
[tibero@node1 ~/tbarch]$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> select * from v$archive_dest_files;

NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s1.arc
         0          1         45122
2025/12/16
       45123             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s2.arc
         0          2         45123
2025/12/16
       45238             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s3.arc
         0          3         45238
2025/12/16
       45240             45122
2025/12/16


NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s4.arc
         0          4         45240
2025/12/16
       45243             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s5.arc
         0          5         45243
2025/12/16
       45245             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s6.arc
         0          6         45245
2025/12/16
       45248             45122
2025/12/16


NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s7.arc
         0          7         45248
2025/12/16
       45274             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s8.arc
         0          8         45274
2025/12/16
       45279             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s9.arc
         0          9         45279
2025/12/16
       45284             45122
2025/12/16


9 rows selected.

SQL> alter database recover automatic;
TBR-1147: Need log file (thread 0 seq 10) to recover from TSN 45284.
Recovery done until 2025/12/16 16:25:04 TSN 45281.
Recovery is incomplete and resetlogs is required.

SQL> quit
Disconnected.
[tibero@node1 ~/tbarch]$ tbdown

Tibero instance terminated (NORMAL mode).

 

Move Additional Archives for Recovery

This process is performed once more for testing purposes. In real situations, after stopping asis, no more archive files should be generated.
[tibero@node1 ~/tbarch]$ cd /home/tibero/tbarch/
[tibero@node1 ~/tbarch]$ ls -rlt
Total 204
-rw-------. 1 tibero dba    512 Dec 16  16:23 log-t0-r45122-s1.arc
-rw-------. 1 tibero dba 171008 Dec 16  16:24 log-t0-r45122-s2.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s3.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s4.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s5.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s6.arc
-rw-------. 1 tibero dba   5120 Dec 16  16:24 log-t0-r45122-s7.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s8.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s9.arc
drwxr-xr-x. 2 tibero dba     64 Dec 16  16:31 notyet
[tibero@node1 ~/tbarch]$ cd notyet/
[tibero@node1 ~/tbarch/notyet]$ ls -rlt
Total 8
-rw-------. 1 tibero dba 2048 Dec 16  16:25 log-t0-r45122-s10.arc
-rw-------. 1 tibero dba 2048 Dec 16  16:25 log-t0-r45122-s11.arc
[tibero@node1 ~/tbarch/notyet]$ mv log-t0-r45122-s10.arc ..
[tibero@node1 ~/tbarch/notyet]$ cd ..
[tibero@node1 ~/tbarch]$ ls -rlt
Total 208
-rw-------. 1 tibero dba    512 Dec 16  16:23 log-t0-r45122-s1.arc
-rw-------. 1 tibero dba 171008 Dec 16  16:24 log-t0-r45122-s2.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s3.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s4.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s5.arc
-rw-------. 1 tibero dba    512 Dec 16  16:24 log-t0-r45122-s6.arc
-rw-------. 1 tibero dba   5120 Dec 16  16:24 log-t0-r45122-s7.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s8.arc
-rw-------. 1 tibero dba   1536 Dec 16  16:25 log-t0-r45122-s9.arc
-rw-------. 1 tibero dba   2048 Dec 16  16:25 log-t0-r45122-s10.arc
drwxr-xr-x. 2 tibero dba     35 Dec 16  16:33 notyet

 

Third Incomplete Recovery After Mount Mode Startup

[tibero@node1 ~]$ tbboot mount
Change core dump dir to /home/tibero/tibero7/bin/prof.
/usr/bin/pstack or /usr/bin/gstack is required to dump the callstack.
****************************************************
* The following path was not found.
* /usr/bin/pstack or /usr/bin/gstack
* pstack or gstack is required to dump the callstack.
****************************************************
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
[tibero@node1 ~]$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> select * from v$archive_dest_files;

NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s1.arc
         0          1         45122
2025/12/16
       45123             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s2.arc
         0          2         45123
2025/12/16
       45238             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s3.arc
         0          3         45238
2025/12/16
       45240             45122
2025/12/16


NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s4.arc
         0          4         45240
2025/12/16
       45243             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s5.arc
         0          5         45243
2025/12/16
       45245             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s6.arc
         0          6         45245
2025/12/16
       45248             45122
2025/12/16


NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s7.arc
         0          7         45248
2025/12/16
       45274             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s8.arc
         0          8         45274
2025/12/16
       45279             45122
2025/12/16

/home/tibero/tbarch/log-t0-r45122-s9.arc
         0          9         45279
2025/12/16
       45284             45122
2025/12/16


NAME
-------------------------------------------------------------------------------------------------------------------------------------
   THREAD#  SEQUENCE# FIRST_CHANGE#
---------- ---------- -------------
FIRST_TIME
--------------------------------------------------------------------------------------------------------------------------------
NEXT_CHANGE# RESETLOGS_CHANGE#
------------ -----------------
RESETLOGS_TIME
--------------------------------------------------------------------------------------------------------------------------------
/home/tibero/tbarch/log-t0-r45122-s10.arc
         0         10         45284
2025/12/16
       45289             45122
2025/12/16


10 rows selected.

SQL> alter database recover automatic;
TBR-1147: Need log file (thread 0 seq 11) to recover from TSN 45289.
Recovery done until 2025/12/16 16:25:04 TSN 45287.
Recovery is incomplete and resetlogs is required.

SQL> q
Disconnected.
[tibero@node1 ~]$ tbdown

Tibero instance terminated (NORMAL mode).

 

Start with Resetlogs and Check Number of Recovered Data

(Since the og-t0-r45122-s11.arc file was excluded from recovery, it is normal for 4 records to be confirmed.)

[tibero@node1 ~]$ tbboot resetlogs
Change core dump dir to /home/tibero/tibero7/bin/prof.
/usr/bin/pstack or /usr/bin/gstack is required to dump the callstack.
****************************************************
* The following path was not found.
* /usr/bin/pstack or /usr/bin/gstack
* pstack or gstack is required to dump the callstack.
****************************************************
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL RESETLOGS mode).
[tibero@node1 ~]$ tbsql test/test

tbSQL 7

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

Connected to Tibero.

SQL> SELECT SEQ FROM RECOVERY_TEST ORDER BY 1;

       SEQ
----------
         1
         2
         3
         4

4 rows selected.

 

 

 

Related to