假如你的redolog 分为三个组,每个组至少有两个成员,并且这三个组最好别放在同一块物理磁盘上,分别放在两三个不同的物理磁盘上,这样这三个组是通过log switch 是自动切换的,等第一组写完进行切换到第二组,第三组是一个循环的过程,

oracle强制切换redo log组步骤

1、desc v$log;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER
 THREAD#                                            NUMBER
 SEQUENCE#                                          NUMBER
 BYTES                                              NUMBER
 MEMBERS                                            NUMBER
 ARCHIVED                                           VARCHAR2(3)
 STATUS                                             VARCHAR2(16)
 FIRST_CHANGE#                                      NUMBER
 FIRST_TIME                                         DATE
2、select group#,thread#,sequence#,status from v$log;

    GROUP#    THREAD#  SEQUENCE# STATUS
---------- ---------- ---------- ----------------
         1          1          8 INACTIVE
         2          1          9 CURRENT
         3          1          7 INACTIVE
3、alter system switch logfile;

System altered.
4、
SQL> select group#,thread#,sequence#,status from v$log;

    GROUP#    THREAD#  SEQUENCE# STATUS
---------- ---------- ---------- ----------------
         1          1          8 INACTIVE
         2          1          9 ACTIVE
         3          1         10 CURRENT

很明显上面状态列已经发生了变化。