Tibero Directory 구조

login as: tibero
tibero@192.168.56.241's password:
Last login: Fri Apr  7 09:35:50 2023 from 192.168.56.1
[tibero@T1:/home/tibero]$ tbsql tibero/tmax

tbSQL 7

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

Connected to Tibero.

SQL> SELECT * FROM V$DATABASE;

      DBID NAME
---------- ----------------------------------------
DB_CREATE_DATE
--------------------------------------------------------------------------------
CF_CREATE_DATE
--------------------------------------------------------------------------------
CURRENT_TSN OPEN_MODE  RESETLOG_TSN
----------- ---------- ------------
RESETLOG_DATE
--------------------------------------------------------------------------------
PREV_RESETLOG_TSN
-----------------
PREV_RESETLOG_DATE
--------------------------------------------------------------------------------
LOG_MODE       CKPT_TSN
------------ ----------
CKPT_DATE
--------------------------------------------------------------------------------
CPU_NAME                         PLATFORM_NAME
-------------------------------- --------------------------------
CPU_MODEL
--------------------------------------------------------------------------------
OS_UPTIME
--------------------------------------------------------------------------------
1519386774 tibero
2023/04/06
2023/04/06
      71625 READ WRITE            0

                0

NOARCHIVELOG      42158
2023/04/06
X86                              LINUX_X86_64
12th Gen Intel(R) Core(TM) i5-12400
11:16:15 up 3 days, 23:11,  5 users,  load average: 0.00, 0.02, 0.05


1 row selected.

SQL>
SQL>
SQL>
SQL> SELECT NAME FROM V$CONTROLFILE;

NAME
--------------------------------------------------------------------------------
/tibero/tbdata/tibero/c1.ctl
/tibero/tbdata/tibero/c2.ctl

2 rows selected.


SQL> SELECT GROUP#, SEQUENCE#,STATUS FROM V$LOG;

    GROUP#  SEQUENCE# STATUS
---------- ---------- --------
         0          4 INACTIVE
         1          5 CURRENT
         2          3 INACTIVE

3 rows selected.

SQL> SELECT MEMBER FROM V$LOGFILE;

MEMBER
--------------------------------------------------------------------------------
/tibero/tbdata/tibero/log01.log
/tibero/tbdata/tibero/log11.log
/tibero/tbdata/tibero/log21.log

3 rows selected.

SQL>  SELECT GROUP#, SEQUENCE#,STATUS, BYTES/1024/1024 MB FROM V$LOG;

    GROUP#  SEQUENCE# STATUS           MB
---------- ---------- -------- ----------
         0          4 INACTIVE         50
         1          5 CURRENT          50
         2          3 INACTIVE         50

3 rows selected.



SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> ALTER DATABASE ADD LOGFILE GROUP 3
('/tibero/tbdata/tibero/log31.log'
,'/tibero/tbdata/tibero/log32.log')
SIZE 50M;   2    3    4

Database altered.

SQL> SELECT
   2 1
   3 FROM
   4 DUAL;

         1
----------
         1

1 row selected.

SQL> SELECT GROUP#, SEQUENCE#,STATUS, BYTES/1024/1024 MB FROM V$LOG;


    GROUP#  SEQUENCE# STATUS           MB
---------- ---------- -------- ----------
         0          4 INACTIVE         50
         1          5 CURRENT          50
         2          3 INACTIVE         50
         3         -1 UNUSED           50

4 rows selected.

SQL> 
SQL>