Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will be explaining Add Member to Redo Log Group and Increasing the Size of a Redo Log Group.
A new member is added to an existing redo log group as follows;
1 2 3 | SQL> alter database add logfile member '/u01/app/oracle/oradata/traindb/redo01b.log' to group 1; Database altered. |
Let’s check the newly added member to the group;
1 2 3 4 5 6 7 8 | SQL> select group#, members,status from v$log; GROUP# MEMBERS STATUS ---------- ---------- ---------------- 1 2 INACTIVE 2 1 INACTIVE 3 1 CURRENT 4 1 INACTIVE |
Redo log groups cannot be directly increased in size. To increase the size, it is necessary to add a new redo log group.
