oracle 手动切换redo,oracle强制切换redolog组

假如你的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

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