Document Type | Technical Information
Category | Interface/Integration
Applicable Product Version | All Tibero Versions
Document Number | TIITI040
Overview
This explains how to query redo log groups, and if necessary, delete and recreate them.
Method
1. Query Existing Redo
SQL>select * from v$log; THREAD# GROUP# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- -------- -------- ------------- ------------------------------ 0 0 7 52428800 2 NO CURRENT 97527 2025/11/07 0 1 5 52428800 2 NO INACTIVE 56140 2025/11/06 0 2 6 52428800 2 NO INACTIVE 75597 2025/11/06
2. Delete Redo
SQL> alter database drop logfile group 2; Database altered. SQL> select * from v$log; THREAD# GROUP# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- -------- -------- ------------- ------------------------------ 0 0 7 52428800 2 NO CURRENT 97527 2025/11/07 0 1 5 52428800 2 NO INACTIVE 56140 2025/11/06 2 rows selected.
- Redo logs that are CURRENT cannot be deleted.
- If deletion is necessary, use the command
alter dabase switch log file;to switch the log, and once the status changes to inactive, delete it.
3. Create Redo
SQL> alter database add logfile group 2 ('/home/tibero/tibero7/database/redo021.redo') size 50m;
Database altered.
SQL> select * from v$log;
THREAD# GROUP# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- -------- ------------- ------------------------------
0 0 7 52428800 2 NO CURRENT 97527 2025/11/07
0 1 5 52428800 2 NO INACTIVE 56140 2025/11/06
0 2 0 52428800 1 NO UNUSED 0
3 rows selected.