1、先查看redolog组情况

   select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                   IS_
---------- ------- ------- ---------------------------------------- ---
         3         ONLINE  /u01/oradata/chris/redo03.log            NO
         2         ONLINE  /u01/oradata/chris/redo02.log            NO
         1         ONLINE  /u01/oradata/chris/redo01.log            NO

2、增加redolog文件组

alter database add logfile group 4 ('/u01/oradata/chris/redo04.log') size 50M;

3、SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                   IS_
---------- ------- ------- ---------------------------------------- ---
         3         ONLINE  /u01/oradata/chris/redo03.log            NO
         2         ONLINE  /u01/oradata/chris/redo02.log            NO
         1         ONLINE  /u01/oradata/chris/redo01.log            NO
         4         ONLINE  /u01/oradata/chris/redo04.log            NO

已经添加成功并分配了大小。

4、添加组成员

alter database add logfile member '/u01/oradata/chris/redo04a.rdo' to group 4;

5、进行查看

   select * from v$logfile;

 GROUP# STATUS  TYPE    MEMBER                                   IS_
---------- ------- ------- ---------------------------------------- ---
         3         ONLINE  /u01/oradata/chris/redo03.log            NO
         2         ONLINE  /u01/oradata/chris/redo02.log            NO
         1         ONLINE  /u01/oradata/chris/redo01.log            NO
         4         ONLINE  /u01/oradata/chris/redo04.log            NO
         4 INVALID ONLINE  /u01/oradata/chris/redo04a.rdo           NO
ok 完成。