oracle添加删除重做日志成员

1.添加新的重做日志成员的语法:
alter database [数据库]
add logfile member ['文件名' [reuse][,'文件名'] [reuse]].. to {group 正整数}
2.添加日志成员的实例:
SQL> alter database add logfile member
  2  '/oradata/law/law/redo01a.log'to group 1,
  3  '/oradata/law/law/redo02a.log' to group 2,
  4  '/oradata/law/law/redo03a.log' to group 3;

Database altered.
SQL> select group#,members from v$log;

GROUP#    MEMBERS
------ ----------
     1          2
     2          2
     3          2

SQL> select * from v$logfile;

GROUP# STATUS  TYPE    MEMBER                    IS_
------ ------- ------- ------------------------- ---
     3         ONLINE  /oradata/law/law/redo03.l NO
                       og

     2 STALE   ONLINE  /oradata/law/law/redo02.l NO
                       og

     1         ONLINE  /oradata/law/law/redo01.l NO