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