假如你的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
很明显上面状态列已经发生了变化。