How To Add Member To Redo Log Group

Onur ARDAHANLI

1 year ago

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;

	SQL> alter database add logfile member '/u01/app/oracle/oradata/traindb/redo01b.log' to group 1;
	
	Database altered.

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;

	SQL> select group#, members,status from v$log;
	
	    GROUP#    MEMBERS STATUS
	---------- ---------- ----------------
	         1          2 INACTIVE
	         2          1 INACTIVE
	         3          1 CURRENT
	         4          1 INACTIVE

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.