Skip to main content

Search

Welcome to Tibero GTS!

Redo Resizing through Redo Logfile Replacement

Document TypeㅣTechnical Information

CategoryㅣAdministration

Applicable Product Versionㅣ7FS02PS

Document NumberㅣTADTI047

 

Overview

Redo resizing is the task of adjusting the size of the Redo log buffer for performance optimization or troubleshooting, and since dynamic resizing of Redo logs is not possible, this guide explains how to replace them with new Redo files by creating temporary Redo groups.
 
 
 

Method

1. Check Existing Redo Logs

set linesize 200
col member for a40
select a.group#, a.member, b.bytes/1024/1024 MB, b.archived, b.status
from v$logfile a, v$log b
where a.group#=b.group#
order by 1,2;

SQL> select a.group#, a.member, b.bytes/1024/1024 MB, b.archived, b.status
2 from v$logfile a, v$log b
3 where a.group#=b.group#
4 order by 1,2;


GROUP# MEMBER MB ARCHIVED STATUS
ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
0 C:\tibero6\tbdata\redo01.redo 100 NO INACTIVE
1 C:\tibero6\tbdata\redo11.redo 100 NO CURRENT
2 C:\tibero6\tbdata\redo21.redo 100 NO INACTIVE

 

2. Add Temporary Redo Logs

alter database add logfile group 4('C:\tibero6\tbdata\redo041.redo') size 600M;
alter database add logfile group 5('C:\tibero6\tbdata\redo051.redo') size 600M;
alter database add logfile group 6('C:\tibero6\tbdata\redo061.redo') size 600M;

alter system switch logfile;
alter system switch logfile;
alter system switch logfile;

 

3. Drop Existing Redo Logs

alter database drop logfile group 0;
alter database drop logfile group 1;
alter database drop logfile group 2;

alter system switch logfile;
alter system switch logfile;
alter system switch logfile;

 

4. Add New Redo Logs (Created in Step 2) to Original Redo Groups

alter database add logfile group 0('C:\tibero6\tbdata\redo01.redo') size 600M;
alter database add logfile group 1('C:\tibero6\tbdata\redo11.redo') size 600M;
alter database add logfile group 2('C:\tibero6\tbdata\redo21.redo') size 600M;

 

5. Drop Temporary Redo Logs

alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;

 

 

 

 

 

Related to