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>
