oracle增加文件组,增加redolog组和组成员

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 完成。