In this article, i am going to show you how to change the online redolog file size. The existing configuration is having 3 redolog groups with one member in each group. Each member in group is 50MB in size. Now we are going to change the size of these online redolog group members from 50MB to 300MB.
SQL> select group#,thread#,MEMBERS,bytes/1024/1024 from v$log;
GROUP# THREAD# MEMBERS BYTES/1024/1024
---------- ---------- ---------- ---------------
1 1 1 50
2 1 1 50
3 1 1 50
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/home/apps/oem12c/oradata/oem12c/redo03.log
/home/apps/oem12c/oradata/oem12c/redo02.log
/home/apps/oem12c/oradata/oem12c/redo01.log
SQL> alter database add logfile thread 1 group 4 ('/home/apps/oem12c/oradata/oem12c/redo04.log') size 300M;
Database altered.
SQL> alter database add logfile thread 1 group 5 ('/home/apps/oem12c/oradata/oem12c/redo05.log') size 300M;
Database altered.
SQL> alter database add logfile thread 1 group 6 ('/home/apps/oem12c/oradata/oem12c/redo06.log') size 300M;
Database altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
GROUP# THREAD# MEMBERS STATUS BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
1 1 1 INACTIVE 50
2 1 1 CURRENT 50
3 1 1 INACTIVE 50
4 1 1 UNUSED 300
5 1 1 UNUSED 300
6 1 1 UNUSED 300
6 rows selected.
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system checkpoint;
System altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
GROUP# THREAD# MEMBERS STATUS BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
2 1 1 INACTIVE 50
4 1 1 CURRENT 300
5 1 1 UNUSED 300
6 1 1 UNUSED 300
SQL> alter database drop logfile group 2;
Database altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
GROUP# THREAD# MEMBERS STATUS BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
4 1 1 CURRENT 300
5 1 1 UNUSED 300
6 1 1 UNUSED 300
SQL>
Hope this helps
SRI
Posts
Post a Comment
Thank you for visiting our site and leaving your valuable comment.