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 完成。
转载于:https://blog.51cto.com/oklinux/846857