Adding online redo log files to a group and what are the steps to add online redo log file member to an existing redo log group?
meda Changed status to publish 08/03/2022
There are many options to create logfile to an existing log group. One of the options are using ALTER DATABASE ADD LOGFILE MEMBER SQL statement.
We are also required to specify the name, location and group to which the log file is going to be added.
SQL> ALTER DATABASE ADD LOGFILE MEMBER ‘location of log file’ TO GROUP <number>
Example :
SQL> conn sys/orcl@to_primary as sysdba Connected. SQL> alter database add logfile member 'D:\app\Admin\virtual\oradata\orcl\REDO01B.LOG' to group 1; Database altered. SQL>
meda Edited answer 21/02/2022