SQL> conn sys 
Enter Password:
Connected to Tibero.

SQL> conn syscat 
Enter Password: 
Connected to Tibero.

SQL> COL owner FORMAT a20 
SQL> SET PAGES 500

SQL> SELECT owner, object_type, status, count(*) 
FROM dba_objects
GROUP BY owner, object_type, status 
ORDER BY owner, object_type, status;

SQL> SET LINESIZE 120
SQL> COL object_name FORMAT A30 
SQL> COL owner FORMAT a20

SQL> SELECT owner, object_name, object_type, status 
FROM dba_objects
WHERE status='INVALID';

SQL> SET LINESIZE 120
SQL> COL file_name FORMAT A100

SQL> SELECT file_name FROM dba_data_files;

ora_link_remote=(
                (GATEWAY=(LISTENER=(HOST=12.34.56.78)
                                   (PORT=9999))
                         (TARGET=orcl) 
                         (TX_MODE=GLOBAL))
)

db2_link_remote=(
                (GATEWAY=(LISTENER=(HOST=12.34.56.78)
                         (PORT=9999))
                (TARGET=sample) 
                (TX_MODE=GLOBAL))
)

mssql_link_remote=(
                  (GATEWAY=(LISTENER=(HOST=12.34.56.78)
                                     (PORT=9093)) 
                           (TARGET=12.34.56.87:1433:master) 
                           (TX_MODE=LOCAL))
)

ase_link_remote=(
(GATEWAY=(LISTENER=(HOST=12.34.56.78)
(PORT=9093)) (TARGET=12.34.56.87:5000:master) (TX_MODE=LOCAL))
)

gp_link_remote=(
                (GATEWAY=(LISTENER=(HOST=12.34.56.78)
                                   (PORT=9093)) 
                         (TARGET=12.34.56.87:5432:mydb) 
                         (TX_MODE=LOCAL))
)

mysql_link_remote=(
                  (GATEWAY=(LISTENER=(HOST=12.34.56.78)
                                     (PORT=9093)) 
                           (TARGET=12.34.56.87:3306:mydb) 
                           (TX_MODE=LOCAL))
)

SQL> SET LINESIZE 120 
SQL> COL owner FORMAT a10
SQL> COL library_name FORMAT a30
SQL> COL file_spec FORMAT a50 
SQL> COL status FORMAT a10

SQL> SELECT owner, library_name, file_spec, status 
FROM DBA_LIBRARIES;

SQL> SET LINESIZE 120 
SQL> COL owner FORMAT a10 
SQL> COL name FORMAT a30
SQL> COL source FORMAT a50

SQL> SELECT owner, name, source 
FROM DBA_JAVA_CLASSES;

[os_user$]tbdown immediate 
[os_user$]ps -ef | grep tbsvr

[os_user$]mv tibero7 tibero7*_<version>_<date>* 
[os_user$]gunzip -v new_tibero_binary.tar.gz 
[os_user$]tar -xvf new_tibero_binary.tar

[tbtest@db1 ~]$ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

[tbtest@db1 ~]$ tbboot -v

Tibero 7 (DB 7.0 FS02) Build 260633
Linux bistro-build-centos_7 5.15.0-71-generic #78~20.04.1-Ubuntu SMP Wed Apr 19 
11:26:48 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux version (little-endian)
...
Compiled at Jun 1 2023 15:38:28 build seq 260633 init rev {2022-03-10}

[tbtest@db1 ~]$ date
2023. 06. 21. (수) 16:52:41 KST

[tbtest@db1 ~]$ mv tibero7 tibero7_260633_20230621
[tbtest@db1 ~]$ gunzip tibero7-bin-FS02-linux64_3.10-260359-20230518173125.tar.gz 
[tbtest@db1 ~]$ tar -xvf tibero7-bin-FS02-linux64_3.10-260359-20230518173125.tar 
tibero7/bin/svr_rename.sh
tibero7/bin/alterdd.sh 
tibero7/bin/tb_create_db.sh 
tibero7/bin/tbiv 
tibero7/bin/sm_sysmon_disk_state.sh 
tibero7/bin/tbprof 
tibero7/bin/tbinfo 
tibero7/bin/tbboot 
tibero7/bin/tbctl 
tibero7/bin/tbcmobs
...

[os_user$]cd ~/tibero7*_<version>_<date>* 
[os_user$]mv database $TB_HOME

$TB_HOME/client/epa/java/config/epa.cfg
$TB_HOME/client/epa/java/config/epalog.properties
$TB_HOME/client/bin/tbjavaepa

export BACKUP_TB_HOME=~/tibero7_<version>_<date> 
diff $TB_HOME/client/epa/java/config/epa.cfg
        $BACKUP_TB_HOME/client/epa/java/config/epa.cfg

cp -p $BACKUP_TB_HOME/client/epa/java/config/epa.cfg
$TB_HOME/client/epa/java/config/epa.cfg

[os_user$]cd $TB_HOME/config 
[os_user$]sh gen_tip.sh

[tbtest@db1 ~]$ cd tibero7/config 
[tbtest@db1 config]$ sh gen_tip.sh 
Using TB_SID "tibero"
/home/tbtest/tibero7/config/tibero.tip generated
/home/tbtest/tibero7/config/psm_commands generated
/home/tbtest/tibero7/client/config/tbdsn.tbr generated. 
Running client/config/gen_esql_cfg.sh
Done.

[os_user$]cd ~/tibero7*_<version>_<date>* 
[os_user$]cp -rp license $TB_HOME

[os_user$]cd ~/tibero7_260633_20230621/config 
[os_user$]cp -rp license $TB_HOME

[os_user$]cd ~/tibero7_*<version>_<date>*/config 
[os_user$]cp -p $TB_SID.tip $TB_HOME/config

[os_user$]cd ~/tibero7_260633_20230621/config 
[os_user$]cp -p $TB_SID.tip $TB_HOME/config

[os_user$]cd ~/tibero7_*<version>_<date>*/client/config 
[os_user$]cp -p tbdsn.tbr $TB_HOME/client/config

[os_user$]cd ~/tibero7_260633_20230621/client/config 
[os_user$]cp -p tbdsn.tbr $TB_HOME/client/config

[os_user$]cd ~/tibero7_*<version>_<date>*/client/config 
[os_user$]cp -p *.cfg $TB_HOME/client/config

[os_user$]cd ~/tibero7_260633_20230621/client/config 
[os_user$]cp *.cfg $TB_HOME/client/config

[os_user$]tbboot

[os_user$]cd $TB_HOME/scripts 
[os_user$]sh system.sh
Enter SYS password: tibero
Enter SYSCAT password: syscat
Create default system users & roles?(Y/N): N 
Create system tables related to profile?(Y/N): N 
Create TPR tables?(Y/N): N
Register dbms_stats job to Job Scheduler?(Y/N): N

[os_user$]cd $TB_HOME/instance/$TB_SID/log/ 
[os_user$]cat system_init.log | **"TBR-17001"** 
[os_user$]cat system_init.log | **"TBR-70004"**

[os_user$]$ tbsql sys

tbSQL 7

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

Enter Password: 
Connected to Tibero.

SQL> alter system recompile all;

[os_user$]cd $TB_HOME/scripts 
[os_user$]tbsql dbtech/dbtech

tbSQL 7

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

Connected to Tibero.

SQL> @revalidate_viewnsyn.sql

PSM completed.

SQL> SET LINESIZE 120
SQL> COL object_name FORMAT A30 
SQL> COL owner FORMAT a20

SQL> SELECT owner, object_name, object_type, status 
FROM dba_objects
WHERE status='INVALID';

SQL> alter function *<function_name>* compile; 
SQL> alter procedure *<procedure_name>* compile;

SQL> alter index index_name rebuild;

[Tibero_Node1]# tbdown immediate 
[Tibero_Node1]# tbcm -d

[Tibero_Node2]# tbdown immediate 
[Tibero_Node2]# tbcm -d

[Tibero_Node1]tbboot -v

[Tibero_Node1]# cd ~
[Tibero_Node1]# mv tibero7 tibero7_257078_20230717
[Tibero_Node1]# gunzip tibero7-bin-FS02-linux64_3.10-257446-20230113162027.tar.gz 
[Tibero_Node1]# tar -xvf tibero7-bin-FS02-linux64_3.10-257446-20230113162027.tar

[Tibero_Node2]# cd ~
[Tibero_Node2]# mv tibero7 tibero7_257078_20230717
[Tibero_Node2]# gunzip tibero7-bin-FS02-linux64_3.10-257446-20230113162027.tar.gz 
[Tibero_Node2]# tar -xvf tibero7-bin-FS02-linux64_3.10-257446-20230113162027.tar

[Tibero_Node1]# cd $TB_HOME/config 
[Tibero_Node1]# sh gen_tip.sh

[Tibero_Node2]# cd $TB_HOME/config 
[Tibero_Node2]# sh gen_tip.sh

[Tibero_Node1]# cd ~/tibero7_*<version>_<date>* 
[Tibero_Node1]# cp -rp license $TB_HOME

[Tibero_Node2]# cd ~/tibero7_*<version>_<date>* 
[Tibero_Node2]# cp -rp license $TB_HOME

[Tibero_Node1]# cd ~/tibero7_*<version>_<date>*/config 
[Tibero_Node1]# cp -p $TB_SID.tip $TB_HOME/config

[Tibero_Node2]# cd ~/tibero7_*<version>_<date>*/config 
[Tibero_Node2]# cp -p $TB_SID.tip $TB_HOME/config

[Tibero_Node1]# cd ~/tibero7_*<version>_<date>*/client/config 
[Tibero_Node1]# cp -p tbdsn.tbr $TB_HOME/client/config

[Tibero_Node2]# cd ~/tibero7_*<version>_<date>*/client/config 
[Tibero_Node2]# cp -p tbdsn.tbr $TB_HOME/client/config

[Tibero_Node1]# cd ~/tibero7*_<version>_<date>*/client/config 
[Tibero_Node1]# cp -p *.cfg $TB_HOME/client/config

[Tibero_Node2]# cd ~/tibero7*_<version>_<date>*/client/config 
[Tibero_Node2]# cp -p *.cfg $TB_HOME/client/config

[Tibero_Node1]# tbcm -b 
[Tibero_Node1]# tbboot

[Tibero_Node2]# tbcm -b 
[Tibero_Node2]# tbboot

[Tibero_Node1]# cd $TB_HOME/scripts 
[Tibero_Node1]# sh system.sh
Enter SYS password: tibero 
Enter SYSCAT password: syscat
Create default system users & roles?(Y/N): N 
Create system tables related to profile?(Y/N): N 
Create TPR tables?(Y/N): N
Register dbms_stats job to Job Scheduler?(Y/N): N

[Tibero_Node1]# cd $TB_HOME/instance/$TB_SID/log/ 
[Tibero_Node1]# cat system_init.log | grep **"TBR-17001"** 
[Tibero_Node1]# cat system_init.log | grep **"TBR-70004"**

[Tibero_Node1]# tbsql sys

tbSQL 7

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

Enter Password: 
Connected to Tibero.

SQL> alter system recompile all;

[Tibero_Node1]# cd $TB_HOME/scripts 
[Tibero_Node1]# tbsql dbtech/dbtech

tbSQL 7

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

Connected to Tibero.

SQL> @revalidate_viewnsyn.sql

PSM completed.

[os_user$]mv tibero7 tibero7_*<version>_<date>* 
[os_user$]gunzip -v new_tibero_binary.tar.gz 
[os_user$]tar -xvf new_tibero_binary.tar

[tbtest@db1 ~]$ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

[tbtest@db1 ~]$ tbboot -v

Tibero 7 (DB 7.0 FS02) Build 260633
Linux bistro-build-centos_7 5.15.0-71-generic #78~20.04.1-Ubuntu SMP Wed Apr 19 
11:26:48 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux version (little-endian)
...
Compiled at Jun 1 2023 15:38:28 build seq 260633 init rev {2022-03-10}

[tbtest@db1 ~]$ date
2023. 06. 21. (수) 16:52:41 KST

[tbtest@db1 ~]$ mv tibero7 tibero7_260633_20230621
[tbtest@db1 ~]$ gunzip tibero7-bin-FS02-linux64_3.10-260359-20230518173125.tar.gz 
[tbtest@db1 ~]$ tar -xvf tibero7-bin-FS02-linux64_3.10-260359-20230518173125.tar 
tibero7/bin/svr_rename.sh
tibero7/bin/alterdd.sh 
tibero7/bin/tb_create_db.sh 
tibero7/bin/tbiv 
tibero7/bin/sm_sysmon_disk_state.sh 
tibero7/bin/tbprof 
tibero7/bin/tbinfo 
tibero7/bin/tbboot 
tibero7/bin/tbctl 
tibero7/bin/tbcmobs
...

[os_user$]cd ~/tibero7_*<version>_<date>* 
[os_user$]mv database $TB_HOME

$TB_HOME/client/epa/java/config/epa.cfg
$TB_HOME/client/epa/java/config/epalog.properties
$TB_HOME/client/bin/tbjavaepa

export BACKUP_TB_HOME=~/tibero7_*<version>_<date>* 
diff $TB_HOME/client/epa/java/config/epa.cfg
$BACKUP_TB_HOME/client/epa/java/config/epa.cfg

cp -p $BACKUP_TB_HOME/client/epa/java/config/epa.cfg
$TB_HOME/client/epa/java/config/epa.cfg

[os_user$]cd $TB_HOME/config 
[os_user$]sh gen_tip.sh

[tbtest@db1 ~]$ cd tibero7/config 
[tbtest@db1 config]$ sh gen_tip.sh 
Using TB_SID "tibero"
/home/tbtest/tibero7/config/tibero.tip generated
/home/tbtest/tibero7/config/psm_commands generated
/home/tbtest/tibero7/client/config/tbdsn.tbr generated. 
Running client/config/gen_esql_cfg.sh
Done.

[os_user$]cd ~/tibero7_*<version>_<date>* 
[os_user$]cp -rp license $TB_HOME

[os_user$]cd ~/tibero7_260633_20230621/config 
[os_user$]cp -rp license $TB_HOME

[os_user$]cd ~/tibero7_*<version>_<date>*/config 
[os_user$]cp -p $TB_SID.tip $TB_HOME/config

[os_user$]cd ~/tibero7_260633_20230621/config 
[os_user$]cp -p $TB_SID.tip $TB_HOME/config

[os_user$]cd ~/tibero7_*<version>_<date>*/client/config 
[os_user$]cp -p tbdsn.tbr $TB_HOME/client/config

[os_user$]cd ~/tibero7_260633_20230621/client/config 
[os_user$]cp -p tbdsn.tbr $TB_HOME/client/config

[os_user$]cd ~/tibero7*_<version>_<date>*/client/config 
[os_user$]cp -p *.cfg $TB_HOME/client/config

[os_user$]cd ~/tibero7_260633_20230621/client/config 
[os_user$]cp *.cfg $TB_HOME/client/config

SQL> SET LINESIZE 120
SQL> COL object_name FORMAT A30 
SQL> COL owner FORMAT a20

SQL> SELECT owner, object_name, object_type, status 
FROM dba_objects
WHERE status='INVALID';

$ tbdown immediate
$ tbcm -d

$ mv ~/tibero7 ~/tibero7_260633_20230621

$ gunzip tibero7-bin-FS02-linux64_3.10-260359-20230518173125.tar.gz
$ tar -xvf tibero7-bin-FS02-linux64_3.10-260359-20230518173125.tar

$ cd $TB_HOME/config
$ sh gen_tip.sh

$ cp ~/tibero7_260633_20230621/config/$TB_SID.tip $TB_HOME/config
$ cp ~/tibero7_260633_20230621/client/config/tbdsn.tbr $TB_HOME/client/config
$ cp ~/tibero7_260633_20230621/client/config/*.cfg $TB_HOME/client/config
$ cp -R ~/tibero7_260633_20230621/license $TB_HOME

$ tbcm -b
$ tbboot

$ cd $TB_HOME/scripts
$ ./system.sh

$ tbsql sys
SQL> alter system recompile all; 
SQL> quit

$ tbsql tibero
SQL> @revalidate_viewnsyn.sql

SQL> SET LINESIZE 120
SQL> COL object_name FORMAT A30 
SQL> COL owner FORMAT a20

SQL> SELECT owner, object_name, object_type, status 
FROM dba_objects
WHERE status='INVALID';

ALTER *<OBJECT_TYPE> <OWNER.OBJECT_NAME>* COMPILE;

v$controlfile

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '<FILENAME>' REUSE NORESETLOGS;

SQL> ALTER TABLESPACE SYSTEM BEGIN BACKUP;

SQL> select * from v$backup;
    FILE#     STATUS	     CHANGE# TIME
---------     ---------      ------------
       0      ACTIVE	     21091
       1      NOT ACTIVE     0
       2      NOT ACTIVE     0
       3      NOT ACTIVE     0

SQL> !cp /home/tibero/tbdata/system001.dtf /home/tibero/tbdata_bak/system001.dtf

SQL> ALTER TABLESPACE SYSTEM END BACKUP;

SQL> select name from v$datafile; 
NAME
--------------------------------------------
/home/tibero/tbdata/system001.dtf
/home/tibero/tbdata/undo001.dtf
/home/tibero/tbdata/usr001.dtf
/home/tibero/tbdata/apm_ts.dtf

SQL> select group#, member from v$logfile; 
GROUP#  MEMBER
------  ----------------------------------
    0	/home/tibero/tbdata/redo01.redo
    1	/home/tibero/tbdata/redo11.redo
    2	/home/tibero/tbdata/redo21.redo

SQL> select name from v$controlfile; 
NAME
-------------------------------------
/home/tibero/tbdata/c1.ctl
/home/tibero/tbdata/c2.ctl

tbdown

$ cp /home/tibero/tbdata/*.dtf /home/tibero/tbdata_bak/
$ cp /home/tibero/tbdata/*.redo /home/tibero/tbdata_bak/
$ cp /home/tibero/tbdata/*.ctl /home/tibero/tbdata_bak/
또는
$ cp /home/tibero/tbdata/*.* /home/tibero/tbdata_bak/

V$RECOVER_FILE 
V$RECOVERY_FILE_STATUS 
V$LOGFILE V$CONTROLFILE 
V$LOG

$ tbboot -t resetlogs

DB_NAME=tibero 
LISTENER_PORT=8629
CONTROL_FILES="/home/tibero/tbdata/c1.ctl", "/home/tibero/tbdata/c2.ctl"
DB_CREATE_FILE_DEST="/home/tibero/tbdata" 
LOG_ARCHIVE_DEST="/home/tibero/tbarch" 
#CERTIFICATE_FILE="/home/tibero/tibero7/config/svr_wallet/tibero.crt" 
#PRIVKEY_FILE="/home/tibero/tibero7/config/svr_wallet/tibero.key" 
#WALLET_FILE="/home/tibero/tibero7/config/svr_wallet/WALLET"

MAX_SESSION_COUNT=100


TOTAL_SHM_SIZE=1024M

CREATE DATABASE "tibero"
USER SYS IDENTIFIED BY TIBERO 
MAXDATAFILES 4096
CHARACTER SET MSWIN949
LOGFILE GROUP 0 ('redo01.redo', 'redo02.redo') SIZE 50M, 
        GROUP 1 ('redo11.redo', 'redo12.redo') SIZE 50M, 
        GROUP 2 ('redo21.redo', 'redo22.redo') SIZE 50M
MAXLOGFILES 100
MAXLOGMEMBERS 8 ARCHIVELOG 
DATAFILE 'system001.dtf' SIZE 256M
        AUTOEXTEND ON NEXT 16M MAXSIZE 3072M
        DEFAULT TABLESPACE USR 
DATAFILE 'usr001.dtf' SIZE 128M
        AUTOEXTEND ON NEXT 16M MAXSIZE 3072M 
        DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE 'temp001.dtf' SIZE 512M
        AUTOEXTEND ON NEXT 16M MAXSIZE 10240M EXTENT MANAGEMENT 
        LOCAL AUTOALLOCATE UNDO TABLESPACE UNDO
DATAFILE 'undo001.dtf' SIZE 512M 
        AUTOEXTEND ON NEXT 16M MAXSIZE 10240M 
        EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

DROP TABLESPACE "MY_FILE001" INCLUDING CONTENTS AND DATAFILES; 
CREATE TABLESPACE "MY_FILE001" DATAFILE 'my_file001.dtf' SIZE 10M 
AUTOEXTEND ON NEXT 1M MAXSIZE 3G
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

DROP USER TIBERO CASCADE;
CREATE USER tibero IDENTIFIED BY tmax 
DEFAULT TABLESPACE MY_FILE001;

GRANT CONNECT, RESOURCE, DBA TO tibero;

$ tbboot
$ tbsql sys/tibero


SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS
'/home/tibero/tbdata/ctl_backup.sql' REUSE NORESETLOGS;


$ rm -f /home/tibero/tbdata/c1.ctl

$ tbdown

Tibero instance terminated (NORMAL mode).

$ tbboot
change core dump dir to /home/tibero/tibero7/bin/prof 
listener port = 8629
********************************************************
*	Warning: Control file open failed
*	/home/tibero/tbdata/SYSTEM/c1.ctl
********************************************************


********************************************************
*Critical Warning : Raise svmode failed. The reason is
*TBR-24003 : Unable to read control file.
*Current server mode is NOMOUNT.
********************************************************

Tibero 7

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

Tibero instance started suspended at NOMOUNT mode.

$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> @ctl_backup.sql 
Control File created.

SQL> exit 
Disconnected.
$ tbdown

Tibero instance terminated (NORMAL mode).

$ 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:
media recovery required(/home/tibero/tbdata/system001.dtf). 
Current server mode is MOUNT.
********************************************************

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. 
Tibero instance started suspended at MOUNT mode.

$ tbsql sys/tibero tbSQL 7

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

Connected to Tibero.

SQL> select * from v$recover_file;

    FILE#     ONLINE	 ERROR	                    CHANGE#     TIME
---------     -------    ------------------------   --------    --------
        0     ONLINE     media recovery required    18144       2023/07/15
        1     ONLINE	 media recovery	required    18144	2023/07/15
        2     ONLINE	 media recovery	required    18144	2023/07/15
        3     ONLINE	 media recovery	required    18144	2023/07/15
        4     ONLINE	 media recovery	required    18144	2023/07/15

rows selected.

SQL> alter database recover automatic database; 
Database altered.

SQL> select * from v$recover_file;
0 row selected.

SQL> exit Disconnected.
$ tbdown

Tibero instance terminated (NORMAL 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)

$ tbsql sys/tibero tbSQL 7

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

Connected to Tibero.

--백업한 컨트롤 파일 스크립트내의 주석 스크립트 부분을 활용하여 Temp 파일 생성
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/home/tibero/tbdata/temp001.dtf' 
SIZE 1G REUSE AUTOEXTEND OFF;
Tablespace 'TEMP' altered. 
SQL> exit

Disconnected.

$ rm -f /home/tibero/tbdata/c1.ctl
$ tbdown
$ tbboot
Change core dump dir to /home/test/tibero7/bin/prof. 
Listener port = 8629

********************************************************
*	Warning: Control file open failed
*	/home/tibero/tbdata/SYSTEM/c1.ctl
********************************************************

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. 
Tibero instance started up (NORMAL mode).

$ tail -f sys.log
[2023-07-15T16:03:06.098870] [CLC-28] [I] control file write failed: no fd for 
'/home/tibero/tbdata/SYSTEM/c1.ctl'
[2023-07-15T16:03:08.099663] [CLC-28] [I] control file read failed : 
'/home/tibero/tbdata/SYSTEM/c1.ctl' (blkno=1) (no fd)
[2023-07-15T16:03:08.100278] [CLC-28] [I] control file write failed: no fd for
'/home/tibero/tbdata/SYSTEM/c1.ctl'
[2023-07-15T16:03:10.101093] [CLC-28] [I] control file read failed : 
'/home/tibero/tbdata/SYSTEM/c1.ctl' (blkno=1) (no fd)
[2023-07-15T16:03:10.101527] [CLC-28] [I] control file write failed: no fd for
'/home/tibero/tbdata/SYSTEM/c1.ctl'
[2023-07-15T16:03:12.101537] [CLC-28] [I] control file read failed : 
'/home/tibero/tbdata/SYSTEM/c1.ctl' (blkno=1) (no fd)
[2023-07-15T16:03:12.102669] [CLC-28] [I] control file write failed: no fd for 
'/home/tibero/tbdata/SYSTEM/c1.ctl'
[2023-07-15T16:03:14.103789] [CLC-28] [I] control file read failed : 
'/home/tibero/tbdata/SYSTEM/c1.ctl' (blkno=1) (no fd)
[2023-07-15T16:03:14.105566] [CLC-28] [I] control file write failed: no fd for 
'/home/tibero/tbdata/SYSTEM/c1.ctl'
[2023-07-15T16:03:16.107421] [CLC-28] [I] control file read failed :
'/home/tibero/tbdata/SYSTEM/c1.ctl' (blkno=1) (no fd)
[2023-07-15T16:03:16.107935] [CLC-28] [I] control file write failed: no fd for 
'/home/tibero/tbdata/SYSTEM/c1.ctl'


$ tbdown

$ cp /home/tibero/tbdata/c2.ctl /home/tibero/tbdata/c1.ctl
$ tbboot

SQL> set line 200
SQL> col group# for 999 
SQL> col member for a50 
SQL> col SEQ# for 999 
SQL> col MB for 999
SQL> select a.group#, a.member, b.bytes/1024/1024 "MB", b.archived "ARC",
b.sequence# "SEQ#", b.status

from v$logfile a, v$log b 
where a.group#=b.group# 
order by 1;	

GROUP#     MEMBER	                MB	ARC	        SEQ#	STATUS
0	/home/tibero/tbdata/redo02.redo	50	YES		3	INACTIVE
1	/home/tibero/tbdata/redo11.redo	50	NO		4	CURRENT
1	/home/tibero/tbdata/redo12.redo	50	NO		4	CURRENT
2	/home/tibero/tbdata/redo21.redo	50	YES		2	INACTIVE
2	/home/tibero/tbdata/redo22.redo	50	YES		2	INACTIVE

6 rows selected.
SQL> !rm -f /home/tibero/tbdata/redo01.redo 
SQL> !ls /home/tibero/tbdata/redo01.redo
ls: /home/tibero/tbdata/redo01.redo: No such file or directory 
SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> set line 200
SQL> col group# for 999 
SQL> col member for a50 
SQL> col SEQ# for 999 
SQL> col MB for 999
SQL> select a.group#, a.member, b.bytes/1024/1024 "MB", b.archived "ARC", 
b.sequence# "SEQ#", b.status
from v$logfile a, v$log b
where a.group#=b.group# 
order by 1;

GROUP#     MEMBER	                    MB         ARC     SEQ#     STATUS
------   ---------------------            ----       -----    -----     --------
    0	 /home/tibero/tbdata/redo01.redo    50		NO	9	CURRENT
    0	 /home/tibero/tbdata/redo02.redo    50		NO	9	CURRENT
    1	 /home/tibero/tbdata/redo11.redo    50		YES	7	INACTIVE
    1	 /home/tibero/tbdata/redo12.redo    50		YES	7	INACTIVE
    2	 /home/tibero/tbdata/redo21.redo    50		YES	8	INACTIVE
    2	 /home/tibero/tbdata/redo22.redo    50		YES	8	INACTIVE


6 rows selected.

SQL> !

$vi /home/tibero/tibero7/instance/tibero/log/slog/sys.log
[2023-07-15T17:34:46.359823] [DDL-91] [I] Executing DDL: alter system switch logfile 
[2023-07-15T17:34:46.360003] [CLL-26] [I] switch log file 2 -> 0 ...
[2023-07-15T17:34:46.364365] [RLS-26] [I] lf hdrblk write: fno(2) cf_seq(143) seq(36) 
nab(1) low(0000.0000c5ed) next(0000.0000c5f2) st(33)
[2023-07-15T17:34:46.365318] [RLS-26] [I] lf hdrblk write: fno(2) cf_seq(143) seq(36) 
nab(1) low(0000.0000c5ed) next(0000.0000c5f2) st(33)
[2023-07-15T17:34:46.365433] [CFD-26] [I] open (stat) failed (errno=2, No such file or
directory) (flag=010002) (filename=/home/tibero/tbdata/redo01.redo)
[2023-07-15T17:34:46.365445] [CLL-26] [I] WARNING: LOG MEMBER missing during log switch,
filename: /home/tibero/tbdata/redo01.redo
[2023-07-15T17:34:46.365566] [CFD-26] [I] open (stat) failed (errno=2, No such file or 
directory) (flag=010002) (filename=/home/tibero/tbdata/redo01.redo)
[2023-07-15T17:34:46.366158] [RLS-26] [I] Failed to read 1 log blocks in logfile group #0
(member=1, blkno=0)
[2023-07-15T17:34:46.366206] [CLL-26] [I] One of the log member(lf id = 0, lm id = 1) is 
invalid, all must be valid
[2023-07-15T17:34:46.366820] [RLS-26] [I] lf hdrblk write: fno(0) cf_seq(143) seq(37) 
nab(4294967295) low(0000.0000c5f2) next(ffff.ffffffff) st(129)
[2023-07-15T17:34:46.366850] [RLS-26] [I] lf hdrblk write: fno(0) cf_seq(143) seq(37) 
nab(4294967295) low(0000.0000c5f2) next(ffff.ffffffff) st(129)
[2023-07-15T17:34:46.369945] [CLL-26] [I] LOGFILE SWITCHED. LF#2(seqno=36, blocks=0
next=0000.0000c5f2)

$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> alter system switch logfile;

System altered.

SQL> alter database drop logfile member '/home/tibero/tbdata/redo01.redo';

Database altered.

SQL> alter database add logfile member '/home/tibero/tbdata/redo01.redo' to group 0;

Database altered.

SQL> alter system switch logfile; 
System altered.

SQL> /
System altered.

SQL> /
System altered.

SQL> !
$vi /home/tibero/tibero7/instance/tibero/log/slog/sys.log

[2023-07-15T10:29:16.500746] [DDL-91] [I] Executing DDL: alter database add logfile 
member '/home/tibero/tbdata/redo01.redo' to group 0

[2023-07-15T10:29:16.687006] [DDL-91] [I] Alter database type 1 succeeded.

[2023-07-15T10:29:16.687169] [DDL-91] [I] DDL execution succeeded

[2023-07-15T10:29:35.029699] [DDL-91] [I] Executing DDL: alter system switch logfile

[2023-07-15T10:29:35.029934] [CLL-26] [I] switch log file 1 -> 2 …

[2023-07-15T10:29:35.032529] [RLS-26] [I] lf hdrblk write: fno(1) cf_seq(155) seq(38) 
nab(23) low(0000.0000c853) next(0000.0000c8ad) st(33)

[2023-07-15T10:29:35.033078] [RLS-26] [I] lf hdrblk write: fno(1) cf_seq(155) seq(38) 
nab(23) low(0000.0000c853) next(0000.0000c8ad) st(33)

[2023-07-15T10:29:35.034520] [RLS-26] [I] lf hdrblk write: fno(2) cf_seq(155) seq(39) 
nab(4294967295) low(0000.0000c8ad) next(ffff.ffffffff) st(129)

[2023-07-15T10:29:35.034964] [RLS-26] [I] lf hdrblk write: fno(2) cf_seq(155) seq(39) 
nab(4294967295) low(0000.0000c8ad) next(ffff.ffffffff) st(129)

[2023-07-15T10:29:35.038120] [CLL-26] [I] LOGFILE SWITCHED. LF#1(seqno=38, blocks=22
next=0000.0000c8ad)

[2023-07-15T10:29:35.038217] [DDL-91] [I] DDL execution succeeded

[2023-07-15T10:29:35.038881] [CLA-27] [I] LOG GROUP 1 (lsn=38) archive start.
(/home/tibero/tbdata/arch/log-t0-r0-s38.arc)


[2023-07-15T10:29:35.040019] [CLA-27] [I] LOG GROUP 1 (lsn=38) ARCHIVED.
(/home/tibero/tbdata/arch/log-t0-r0-s38.arc)

$ tbsql sys/tibero

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

Connected to Tibero.

SQL> set line 200
SQL> col group# for 999 
SQL> col member for a50 
SQL> col SEQ# for 999
SQL> col MB for 999
SQL> select a.group#, a.member, b.bytes/1024/1024 "MB", b.archived "ARC", 
b.sequence# "SEQ#", b.status
from v$logfile a, v$log b 
where a.group#=b.group# 
order by 1;

GROUP#     MEMBER	                    MB     ARC     SEQ#     STATUS
------    ---------------------------       ----   ----    -----    --------
    0	  /home/tibero/tbdata/redo01.redo    50	    YES      4	     INACTIVE
    0	  /home/tibero/tbdata/redo02.redo    50	    YES	     4	     INACTIVE
    1	  /home/tibero/tbdata/redo11.redo    50	    NO       5	     CURRENT
    1	  /home/tibero/tbdata/redo12.redo    50	    NO	     5	     CURRENT
    2	  /home/tibero/tbdata/redo21.redo    50	    YES	     3	     INACTIVE
    2	  /home/tibero/tbdata/redo22.redo    50	    YES	     3	     INACTIVE


6 rows selected.

SQL> !rm -f /home/tibero/tbdata/redo01.redo 
SQL> !rm -f /home/tibero/tbdata/redo02.redo 
SQL> !ls /home/tibero/tbdata/redo01.redo
ls: /home/tibero/tbdata/redo01.redo: No such file or directory 
SQL> !ls /home/tibero/tbdata/redo02.redo
ls: /home/tibero/tbdata/redo02.redo: No such file or directory

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> exit 
Disconnected.

$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> alter database drop logfile group 0;
Database altered.

SQL> alter database add logfile group 0 ('/home/tibero/tbdata/redo01.redo', 
'/home/tibero/tbdata/redo02.redo') size 50M;
Database altered.

SQL> set line 200
SQL> col group# for 999 
SQL> col member for a50 
SQL> col SEQ# for 999 
SQL> col MB for 999
SQL> select a.group#, a.member, b.bytes/1024/1024 "MB", b.archived "ARC",
b.sequence# "SEQ#", b.status

from v$logfile a, v$log b 
where a.group#=b.group# 
order by 1;	

GROUP#   MEMBER	                            MB	 ARC	SEQ#	STATUS
-------  --------------------------------  ----  ----   ------  --------
    0	 /home/tibero/tbdata/redo01.redo    50	 YES	-1	UNUSED
    0	 /home/tibero/tbdata/redo02.redo    50	 YES	-1	UNUSED
    1	 /home/tibero/tbdata/redo11.redo    50	 NO	 5	CURRENT
    1	 /home/tibero/tbdata/redo12.redo    50	 NO	 5	CURRENT
    2	 /home/tibero/tbdata/redo21.redo    50	 YES	 3	INACTIVE
    2	 /home/tibero/tbdata/redo22.redo    50	 YES	 3	INACTIVE
    
6 rows selected.

$ tbsql sys/tibero tbSQL 7

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

Connected to Tibero.

SQL> set line 200
SQL> col group# for 999 
SQL> col member for a50 
SQL> col SEQ# for 999 
SQL> col MB for 999
SQL> select a.group#, a.member, b.bytes/1024/1024 "MB", b.archived "ARC", 
b.sequence# "SEQ#", b.status
from v$logfile a, v$log b
where a.group#=b.group# 
order by 1;

GROUP#   MEMBER	                            MB	 ARC	SEQ#	STATUS
-------  --------------------------------  ----  ----   ------  --------
    0	 /home/tibero/tbdata/redo01.redo    50	 NO	7	CURRENT
    0	 /home/tibero/tbdata/redo02.redo    50	 NO	7	CURRENT
    1	 /home/tibero/tbdata/redo11.redo    50	 YES	5	CURRENT
    1	 /home/tibero/tbdata/redo12.redo    50	 YES	5	CURRENT
    2	 /home/tibero/tbdata/redo21.redo    50	 YES	6	INACTIVE
    2	 /home/tibero/tbdata/redo22.redo    50	 YES	6	INACTIVE

6 rows selected.

SQL> CREATE TABLE T1 (C1 VARCHAR(5));
Table 'T1' created.

SQL> INSERT INTO T1 (C1) VALUES ('00011');
1 row inserted.

SQL> COMMIT;
Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.

SQL> INSERT INTO T1 (C1) VALUES ('00012');
1 row inserted.

SQL> COMMIT;
Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.

SQL> INSERT INTO T1 (C1) VALUES ('00013');
1 row inserted.

SQL> COMMIT;
Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.

SQL> INSERT INTO T1 (C1) VALUES ('00014');
1 row inserted.

SQL> COMMIT;
Commit completed.

SQL> set line 200
SQL> col group# for 999 
SQL> col member for a50 
SQL> col SEQ# for 999 
SQL> col MB for 999
SQL> select a.group#, a.member, b.bytes/1024/1024 "MB", b.archived "ARC", 
b.sequence# "SEQ#", b.status
from v$logfile a, v$log b
where a.group#=b.group# 
order by 1;

GROUP#   MEMBER	                            MB	 ARC	SEQ#	STATUS
-------  --------------------------------  ----  ----   ------  --------
    0	 /home/tibero/tbdata/redo01.redo    50	 NO	10	CURRENT
    0	 /home/tibero/tbdata/redo02.redo    50	 NO	10	CURRENT
    1	 /home/tibero/tbdata/redo11.redo    50	 YES	8	INACTIVE
    1	 /home/tibero/tbdata/redo12.redo    50	 YES	8	INACTIVE
    2	 /home/tibero/tbdata/redo21.redo    50	 YES	9	INACTIVE
    2	 /home/tibero/tbdata/redo22.redo    50	 YES	9	INACTIVE

6 rows selected.

SQL> !rm -f /home/tibero/tbdata/redo01.redo 
SQL> !rm -f /home/tibero/tbdata/redo02.redo 
SQL> !ls /home/tibero/tbdata/redo01.redo
/home/tibero/tbdata/redo01.redo not found 
SQL> !ls /home/tibero/tbdata/redo02.redo
/home/tibero/tbdata/redo02.redo not found

SQL> exit 
Disconnected.

$ tbdown abort

Tibero instance terminated (ABORT mode).

$ cp /home/tibero/tbdata_bak/*.dtf /home/tibero/tbdata

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

SQL> set line 200 SQL> set line 200
SQL> col group# for 999
SQL> col member for a50 
SQL> col SEQ# for 999 
SQL> col MB for 999
SQL> select a.group#, a.member, b.bytes/1024/1024 "MB", b.archived "ARC", 
b.sequence# "SEQ#", b.status
from v$logfile a, v$log b 
where a.group#=b.group# 
order by 1;

GROUP#   MEMBER	                            MB	 ARC	SEQ#	STATUS
-------  --------------------------------  ----  ----   ------  --------
    0	 /home/tibero/tbdata/redo01.redo    50	 NO	10	CURRENT
    0	 /home/tibero/tbdata/redo02.redo    50	 NO	10	CURRENT
    1	 /home/tibero/tbdata/redo11.redo    50	 YES	8	INACTIVE
    1	 /home/tibero/tbdata/redo12.redo    50	 YES	8	INACTIVE
    2	 /home/tibero/tbdata/redo21.redo    50	 YES	9	INACTIVE
    2	 /home/tibero/tbdata/redo22.redo    50	 YES	9	INACTIVE

6 rows selected.

--next_change# - 1 값 조회
SQL>	set	line 200
SQL>	col	name for a40
SQL>	col	SEQ# for 999
SQL>	col	TSN for 999999999
SQL> select name, sequence# seq#, next_change#-1	tsn	
from v$archive_dest_files order by 2;		

NAME	                                        SEQ#		 TSN
--------------------------------------------   ------      -----------
/home/tibero/tbdata/arch/log-t0-r0-s7.arc	7		45589
/home/tibero/tbdata/arch/log-t0-r0-s8.arc	8		45597
/home/tibero/tbdata/arch/log-t0-r0-s9.arc	9		45606

3 rows selected.		

--TSN 정보가 없을 경우 Log 파일 덤프를 발생시킨다.
SQL> alter system dump logfile '/home/tibero/tbdata/arch/log-t0-r0-s9.arc';

System altered.

SQL> exit 
Disconnected.

$ cd $TB_HOME/instance/$TB_SID/dump/tracedump
$ ls -rlt

total 24
-rw-r--r-- 1 tibero dba 2688 Jul 15 19:08 tb_dump_47120982_37_2.trc

--next_tsn 값을 10진수로 변경 : 0000.0000b227 (hex) => 45607 (dec)
--next_tsn - 1 = 45606

$ grep next tb_dump_47120982_37_2.trc

low=0000.0000b21e 2023-07-10 18:59:28 next=0000.0000b227 2023-07-15 18:59:43
...(이하생략)

$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> alter database recover automatic database until change 45606;

Database altered.

SQL> exit 
Disconnected.

$ tbdown

Tibero instance terminated (NORMAL mode).

$ tbboot -t 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).

$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> select * from t1;

C1
--------
00011
00012
00013

3 rows selected.

$ tbsql sys/tibero tbSQL 7

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

Connected to Tibero.

SQL> CREATE TABLE T1 (C1 VARCHAR(5));
Table 'T1' created.

SQL> INSERT INTO T1 (C1) VALUES ('00011');
1 row inserted.

SQL> COMMIT;
Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.

SQL> INSERT INTO T1 (C1) VALUES ('00012');
1 row inserted.

SQL> COMMIT;
Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.

SQL> INSERT INTO T1 (C1) VALUES ('00013');
1 row inserted.

SQL> COMMIT;
Commit completed.

SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.

SQL> INSERT INTO T1 (C1) VALUES ('00014');
1 row inserted.

QL> COMMIT;
Commit completed.

SQL> set line 200
SQL> col group# for 999 
SQL> col member for a50 
SQL> col SEQ# for 999 
SQL> col MB for 999
SQL> select a.group#, a.member, b.bytes/1024/1024 "MB", b.archived "ARC", 
b.sequence# "SEQ#", b.status
from v$logfile a, v$log b
where a.group#=b.group# 
order by 1;

GROUP#   MEMBER	                            MB	 ARC	SEQ#	STATUS
-------  --------------------------------  ----  ----   ------  --------
    0	 /home/tibero/tbdata/redo01.redo    50	 NO	7	CURRENT
    0	 /home/tibero/tbdata/redo02.redo    50	 NO	7	CURRENT
    1	 /home/tibero/tbdata/redo11.redo    50	 NO	5	INACTIVE
    1	 /home/tibero/tbdata/redo12.redo    50	 NO	5	INACTIVE
    2	 /home/tibero/tbdata/redo21.redo    50	 NO	6	INACTIVE
    2	 /home/tibero/tbdata/redo22.redo    50	 NO	6	INACTIVE

6 rows selected.

SQL> !rm -f /home/tibero/tbdata/redo01.redo 
SQL> !rm -f /home/tibero/tbdata/redo02.redo 
SQL> !ls /home/tibero/tbdata/redo01.redo
/home/tibero/tbdata/redo01.redo not found
SQL> !ls /home/tibero/tbdata/redo02.redo
/home/tibero/tbdata/redo02.redo not found

SQL> exit 
Disconnected.

$ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

$ tbboot

change core dump dir to /home/tibero/tibero7/bin/prof 
listener port = 8629

********************************************************
*Critical Warning : Raise svmode failed. The reason is
*TBR-1042 : Unable to read log member file in group 0, member 1
(/home/tibero/tbdata/redo01.redo), block 0.
* Current server mode is MOUNT.
********************************************************

Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. 
Tibero instance started suspended at MOUNT mode.

$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;
Database altered.

SQL> exit 
Disconnected.

$ tbdown

Tibero instance terminated (NORMAL mode).

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

$ tbsql sys/tibero 
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero

SQL> !ls /home/tibero/tbdata/redo01.redo
/home/tibero/tbdata/redo01.redo
SQL> !ls /home/tibero/tbdata/redo02.redo
/home/tibero/tbdata/redo02.redo

/home/tibero/tbdata/redo02.redo

SQL> set line 200
SQL> col group# for 999 
SQL> col member for a50
SQL> col SEQ# for 999 
SQL> col MB for 999
SQL> select a.group#, a.member, b.bytes/1024/1024 "MB", b.archived "ARC",
b.sequence# "SEQ#", b.status
from v$logfile a, v$log b
where a.group#=b.group#
order by 1;

GROUP#   MEMBER	                            MB	 ARC	SEQ#	STATUS
-------  --------------------------------  ----  ----   ------  --------
    0	 /home/tibero/tbdata/redo01.redo    50	 NO	1	CURRENT
    0	 /home/tibero/tbdata/redo02.redo    50	 NO	1	CURRENT
    1	 /home/tibero/tbdata/redo11.redo    50	 NO	-1	UNUSED
    1	 /home/tibero/tbdata/redo12.redo    50	 NO	-1	UNUSED
    2	 /home/tibero/tbdata/redo21.redo    50	 NO	-1	UNUSED
    2	 /home/tibero/tbdata/redo22.redo    50	 NO	-1	UNUSED

6 rows selected.

SQL> select * from t1;

C1
-------
00011
00012
00013
00014

4 rows selected

$ tbboot
$ tbsql sys/tibero
$ rm –rf /home/tibero/tbdata/temp001.dtf

$ tbdown
$ ls -al /home/tibero/tbdata/temp001.dtf
ls: /home/tibero/tbdata/temp001.dtf: No such file or directory

$ tbboot
$ ls -al /home/tibero/tbdata/temp001.dtf
-rw------- 1 tibero dba 536870912 Jun 15 17:25 /home/tibero/tbdata/temp001.dtf

$ tbdown
$ cp –R /home/tibero/tbdata /home/tibero/tbdata_bak
$ tbboot


$ tbsql tibero/tmax


SQL> CREATE TABLE T1 (C1 VARCHAR(5)) TABLESPACE MY_FILE001;
Table 'T1' created.


SQL> INSERT INTO T1 (C1) VALUES ('00011');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00012');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00013');
1 row inserted.


SQL> COMMIT;
Commit completed.


SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.


SQL> /
System altered.


SQL> exit


$ tbdown
$ rm –f /home/tibero/tbdata/my_file001.dtf

$ cp /home/tibero/tbdata_bak/*.dtf /home/tibero/tbdata


$ tbboot mount


$ tbsql sys/tibero tbSQL 7


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


Connected to Tibero.



SQL> ALTER DATABASE RECOVER AUTOMATIC;
Database altered.


SQL> exit Disconnected.

$ tbdown


Tibero instance terminated (NORMAL mode).


$ tbboot


listener port = 8629


change core dump dir to /home/tibero_td/tibero7/bin/prof


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


Tibero instance started up (NORMAL mode).


$ tbsql tibero/tmax tbSQL 7


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

SQL> select * from t1;


C1
------
00011
00012
00013


3 rows selected.

$ tbdown


$ cp –R /home/tibero/tbdata /home/tibero/tbdata_bak


$ tbboot


$ tbsql tibero/tmax


SQL> CREATE TABLE T1 (C1 VARCHAR(5)) TABLESPACE MY_FILE001;
Table 'T1' created.


SQL> INSERT INTO T1 (C1) VALUES ('00011');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00012');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00013');
1 row inserted.


SQL> COMMIT;
Commit completed.


SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.


SQL> /
System altered.


SQL> /
System altered.


SQL> exit


$ tbdown
$ rm –f /home/tibero/tbdata/my_file001.dtf

$ cp /home/tibero/tbdata_bak/*.dtf /home/tibero/tbdata


$ tbboot mount


$ tbsql sys/tibero
tbSQL 7


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


Connected to Tibero.


SQL> ALTER DATABASE RECOVER;
Database altered.


SQL> ALTER DATABASE RECOVER LOGFILE '/home/tibero/tbarch/log-t0-r0-s1.arc'; 
Database altered.

SQL> ALTER DATABASE RECOVER LOGFILE '/home/tibero/tbarch/log-t0-r0-s2.arc'; 
Database altered.

SQL> ALTER DATABASE RECOVER LOGFILE '/home/tibero/tbarch/log-t0-r0-s3.arc'; 
Database altered.

SQL> select * from v$log;
THREAD#	GROUP# SEQUENCE#  BYTES	   MEMBERS ARCHIVED  STATUS   FIRST_CHANGE#  FIRST_TIME
------  ------ ---------  -------- ------- --------- ------   -------------  -----------	
0	0	4	  52428800  2	   NO	     CURRENT  14521          2023/07/15						
0	1	2	  52428800  2	   YES	     CURRENT  14516          2023/07/15						
0	2	3	  52428800  2	   YES	     CURRENT  14518	     2023/07/15						

3 rows selected.


SQL> select * from v$logfile;


GROUP#	STATUS_TYPE	MEMBER
------  ------------    ---------------------------------
0	ONLINE		/home/tibero/tbdata/redo01.redo
0	ONLINE		/home/tibero/tbdata/redo02.redo
1	ONLINE		/home/tibero/tbdata/redo11.redo
1	ONLINE		/home/tibero/tbdata/redo12.redo
2	ONLINE		/home/tibero/tbdata/redo21.redo
2	ONLINE		/home/tibero/tbdata/redo22.redo

6 rows selected.			


SQL> ALTER DATABASE RECOVER LOGFILE '/home/tibero/tbdata/redo01.redo'; 
Database altered.

SQL> exit Disconnected.

$ tbdown
Tibero instance terminated (NORMAL mode).


$ tbboot


listener port = 8629
change core dump dir to /home/tibero/tibero7/bin/prof


Tibero 7


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


Tibero instance started up (NORMAL mode).


$ tbsql tibero/tmax


tbSQL 7


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


Connected to Tibero.


SQL> select * from t1;


C1
-------
00011
00012
00013


3 rows selected.

$ tbdown
$ cp –R /home/tibero/tbdata /home/tibero/tbdata_bak
$ tbboot


$ tbsql tibero/tmax


SQL> CREATE TABLE T1 (C1 VARCHAR(5)) TABLESPACE MY_FILE001;
Table 'T1' created.


SQL> INSERT INTO T1 (C1) VALUES ('00011');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00012');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00013');
1 row inserted.


SQL> COMMIT;
Commit completed.


SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.


SQL> /
System altered.


SQL> /
System altered.


SQL> exit


$ tbdown
$ rm –f /home/tibero/tbdata/my_file001.dtf

$ tbboot mount


$ tbsql sys/tibero


SQL> ALTER DATABASE CREATE DATAFILE '/home/tibero/tbdata/my_file001.dtf'; 
Database altered.

SQL> ALTER DATABASE RECOVER AUTOMATIC;
Database altered.


SQL> exit


$ tbdown


$ tbboot


$ tbsql tibero/tmax


SQL> SELECT * FROM T1;


C1
-------
00011
00012
00013


3 rows selected.

$ tbdown
$ cp –R /home/tibero/tbdata /home/tibero/tbdata_bak
$ tbboot


$ tbsql tibero/tmax


SQL> CREATE TABLE T1 (C1 VARCHAR(5)) TABLESPACE MY_FILE001;
Table 'T1' created.


SQL> INSERT INTO T1 (C1) VALUES ('00011');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00012');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00013');
1 row inserted.


SQL> COMMIT;
Commit completed.


SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.


SQL> /
System altered.


SQL> /
System altered.


SQL> exit Disconnected.


$ rm –f /home/tibero/tbdata/my_file001.dtf

$ tbsql sys/tibero tbSQL 7

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

SQL> alter tablespace MY_FILE001 offline immediate; 
Tablespace 'MY_FILE001' altered.

SQL> exit Disconnected.

$ cp /home/tibero/tbdata_bak/my_file001.dtf /home/tibero/tbdata

$ tbsql sys/tibero

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

Connected to Tibero.

SQL> alter database recover automatic tablespace MY_FILE001; 
Database altered.

SQL> alter tablespace MY_FILE001 online; 
Tablespace 'MY_FILE001' altered.

SQL> conn tibero/tmax Connected to Tibero.

SQL> select * from t1;

C1
------
00011
00012
00013

3 rows selected.

alter database recover automatic database until change 15666 allow <BLOCK수> corruption;

alter database recover automatic database until time '2023/06/13 15:58:50' allow <BLOCK수
> corruption;

alter database recover until cancel allow <BLOCK수> corruption;

$ tbdown
$ cp –R /home/tibero/tbdata /home/tibero/tbdata_bak
$ tbboot
$ tbsql sys/tibero

SQL> SELECT *	FROM V$LOG;

SQL> select *	from v$log;


THREAD#	GROUP# SEQUENCE#  BYTES	    MEMBERS  ARCHIVED STATUS    FIRST_CHANGE#  FIRST_TIME
------  ------ ---------  --------  -------  -------- --------  -------------- ------------
0	0	1	  52428800  2	     YES      INACTIVE  0								
0	1	2	  52428800  2	     NO	      CURRENT   15543	       2023/07/15						
0	2      -1	  52428800  2	     NO	      UNUSED    0	

										
3 rows selected.


SQL> CREATE TABLE T1 (C1 VARCHAR(5));
Table 'T1' created.


SQL> INSERT INTO T1 (C1) VALUES ('00011');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00012');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00013');
1 row inserted.


SQL> COMMIT;
Commit completed.


SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.


SQL> INSERT INTO T1 (C1) VALUES ('00021');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00022');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00023');
1 row inserted.


SQL> COMMIT;
Commit completed.


SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.


SQL> INSERT INTO T1 (C1) VALUES ('00031');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00032');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00033');
1 row inserted.


SQL> COMMIT;
Commit completed.


SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.


SQL> INSERT INTO T1 (C1) VALUES ('00041');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00042');
1 row inserted.


SQL> INSERT INTO T1 (C1) VALUES ('00043');
1 row inserted.


SQL> COMMIT;
Commit completed.


SQL> exit Disconnected.

$ tbdown


Tibero instance terminated (NORMAL mode).
$ rm /home/tibero/tbdata/*.dtf


$ tbboot


listener port = 8629
change core dump dir to /home/tibero/tibero7/bin/prof


********************************************************
*Critical Warning : Raise svmode failed. The reason is
*TBR-1024 : Database needs media recovery:
open failed(/home/tibero/tbdata/system001.dtf).
*Current server mode is MOUNT.
********************************************************


Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).

$ tbdown


Tibero instance terminated (NORMAL mode).


$ cp /home/tibero/tbdata_bak/*.dtf /home/tibero/tbdata


$ tbboot mount


Listener port=8629
change core dump dir to /home/tibero/tibero7/bin/prof


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.


SQL> SELECT * FROM V$LOG;

SQL> select * from v$log;

THREAD#	GROUP# SEQUENCE#  BYTES	    MEMBERS  ARCHIVED STATUS    FIRST_CHANGE#  FIRST_TIME
------  ------ ---------  --------  -------  -------- --------  -------------- ------------
	
0	0	4	  52428800  2	     YES      INACTIVE  15652	       2023/07/15						
0	1	5	  52428800  2	     NO	      CURRENT   15667	       2023/07/15						
0	2	3	  52428800  2	     YES      INACTIVE  15619	       2023/07/15						

3 rows selected.


--next_change# - 1 값 조회
SQL> set line 200 
SQL> col name for a40 
SQL> col SEQ# for 999
SQL> col TSN for 999999999
SQL> select name, sequence# seq#, next_change#-1 tsn 
from v$archive_dest_files order by 2;

NAME						SEQ#		TSN
---------------------------------------         ----------      -------------
/home/tibero/tbarch/log-t0-r0-s1.arc		1		15542
/home/tibero/tbarch/log-t0-r0-s2.arc		2		15618
/home/tibero/tbarch/log-t0-r0-s3.arc		3		15651
/home/tibero/tbarch/log-t0-r0-s4.arc		4		15666

4 rows selected.

--TSN 정보가 없을 경우 Log 파일 덤프를 발생시킨다.
SQL> alter system dump logfile '/home/tibero/tbarch/log-t0-r0-s4.arc'; 
System altered.

SQL> exit 
Disconnected.

$ cd $TB_HOME/instance/$TB_SID/dump/tracedump
$ ls -rlt 
total 1
-rw-r--r-- 1 tibero dba 12420 Jun 15 22:37 tb_dump_13457_3_0.trc


--next_tsn 값을 10진수로 변경 : 0000.0000b227 (hex) => 15667 (dec)
--next_tsn - 1 = 15666
$ cat tb_dump_21951_18_2.trc | grep next


low=0000.00003d24 2023-06-14 09:21:26 next=0000.00003d33 2023-06-14 09:21:59


$ tbsql sys/tibero


tbSQL 7


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

SQL> alter database recover automatic database until change 15666; 
Database altered.

SQL> exit 
Disconnected.

$ tbdown


Tibero instance terminated (NORMAL mode).


$ tbboot -t resetlogs


listener port = 8629
change core dump dir to /home/tibero/tibero7/bin/prof


Tibero 7


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


Tibero instance started up (NORMAL RESETLOGS mode).


$ tbsql tibero/tmax


tbSQL 7


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


Connected to Tibero.



SQL> select * from t1;


C1
------
00021
00022
00023
00031
00032
00033
00011
00012
00013


9 rows selected.

$ tbdown

$ cp –R /home/tibero/tbdata /home/tibero/tbdata_bak

$ tbboot

$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> CREATE TABLE T1 (C1 VARCHAR(5));
Table 'T1' created.

SQL> INSERT INTO T1 (C1) VALUES ('00011');
1 row inserted.

SQL> COMMIT;
Commit completed.

SQL> select * from t1; 
C1
-----
00011

1 row selected.

SQL> !date
Thu Jun 15 15:58:50 KST 2023

SQL> INSERT INTO T1 (C1) VALUES ( '00021');
1 row inserted.

SQL> COMMIT;
Commit completed.

SQL> select * from t1;


C1
------
00011
00021

2 rows selected.


SQL> exit Disconnected.

$ tbdown


Tibero instance terminated (NORMAL mode).


$ rm /home/tibero/tbdata/*.dtf


$ tbboot


listener port = 8629


change core dump dir to /home/tibero/tibero7/bin/prof


********************************************************
*	Critical Warning : Raise svmode failed. The reason is
*	TBR-1024 : Database needs media recovery:


open failed(/home/tibero/tbdata/system001.dtf).


*	Current server mode is MOUNT.
********************************************************


Tibero 7


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


Tibero instance started suspended at MOUNT mode.

$ tbdown
Tibero instance terminated (NORMAL mode).

$ cp /home/tibero/tbdata_bak/*.dtf /home/tibero/tbdata

$ tbboot mount

listener port = 8629
change core dump dir to /home/tibero/tibero7/bin/prof

Tibero 7

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

Tibero instance started up (MOUNT mode).

$ export TB_NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'

$ tbsql sys/tibero


tbSQL 7


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


Connected to Tibero.


SQL> alter database recover automatic database until time '2023/06/13 15:58:50'; 
Database altered.

SQL> exit Disconnected.
$ tbdown


Tibero instance terminated (NORMAL mode).


$ tbboot resetlogs


listener port = 8629


change core dump dir to /home/tibero/tibero7/bin/prof Tibero 7


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


Tibero instance started up (NORMAL RESETLOGS mode).


$ tbsql tibero/tmax


tbSQL 7


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


Connected to Tibero.


SQL> select * from t1;


C1
------
00011

1 row selected.

$ tbdown
$ cp –R /home/tibero/tbdata /home/tibero/tbdata_bak


$ tbboot


listener port = 8629


change core dump dir to /home/tibero/tibero7/bin/prof Tibero 7


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


Tibero instance started up (NORMAL mode).


$ tbsql sys/tibero tbSQL 7


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


Connected to Tibero.


SQL> CREATE TABLE T1 (C1 VARCHAR(5)) TABLESPACE MY_FILE001;
Table 'T1' created.


SQL> INSERT INTO T1 (C1) VALUES ('00011');
1 row inserted.


SQL> COMMIT;
Commit completed.


SQL> select * from t1;


C1

00011


1 row selected.


SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.


SQL> col name format a40;
SQL> select name, sequence# from v$archived_log order by sequence#;


NAME	                                SEQUENCE#
------------------------------------    -----------
home/tibero/tbarch/log-t0-r0-s1.arc	1


1 row selected.


SQL> exit 
Disconnected.

$ tbdown
Tibero instance terminated (NORMAL mode).


$ rm /home/tibero/tbdata/*.dtf


$ tbboot


listener port = 8629
change core dump dir to /home/tibero/tibero7/bin/prof


******************************************************** 
Critical Warning : Raise svmode failed. The reason is 
TBR-1024 : Database needs media recovery:
open failed(/home/tibero/tbdata/system001.dtf). 
Current server mode is MOUNT.
********************************************************


Tibero 7


TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. 
Tibero instance started up (MOUNT mode).

$ tbdown

Tibero instance terminated (NORMAL mode).

$ cp /home/tibero/tbdata_bak/*.dtf /home/tibero/tbdata
$ tbboot mount

listener port = 8629
change core dump dir to /home/tibero/tibero7/bin/prof

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.

SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;
Database altered.

SQL> ALTER DATABASE RECOVER LOGFILE '/home/tibero/tbarch/log-t0-r0-s1.arc'; 
Database altered.

SQL> ALTER DATABASE RECOVER CANCEL;
Database altered.

SQL> exit 
Disconnected.

$ tbdown

Tibero instance terminated (NORMAL mode).

$ tbboot -t resetlogs

listener port = 8629
change core dump dir to /home/tibero/tibero7/bin/prof

Tibero 7

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

Tibero instance started up (NORMAL RESETLOGS mode).

$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero. SQL> select * from t1;

C1
------
00011

1 row selected.