switch logfile发生延迟的全局检查点

switch logfile发生延迟的全局检查点
> SELECT GROUP#,SEQUENCE#,STATUS,ARCHIVED,FIRST_CHANGE# FROM V$LOG;

    GROUP#  SEQUENCE# STATUS           ARC FIRST_CHANGE#
---------- ---------- ---------------- --- -------------
         1          2 CURRENT          NO     2460254629
         2          1 INACTIVE         YES    2460234626
         3          0 UNUSED           YES             0

> select FILE#,checkpoint_change#,recover, fuzzy from v$datafile_header;

     FILE# CHECKPOINT_CHANGE# REC FUZ
---------- ------------------ --- ---
         1         2460287034 NO  YES
         2         2460287034 NO  YES
         3         2460287034 NO  YES
         4         2460287034 NO  YES
         5         2460287034 NO  YES
         6         2460287034 NO  YES
         7         2460287034 NO  YES
         8         2460287034 NO  YES

8 rows selected.

> select FILE#,status,CHECKPOINT_CHANGE#,last_change#,name from v$datafile;

     FILE# STATUS  CHECKPOINT_CHANGE# LAST_CHANGE# NAME
---------- ------- ------------------ ------------ --------------------------------------------------
         1 SYSTEM          2460287034              D:\ORACLE\ORADATA\FOX\SYSTEM01.DBF
         2 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\UNDOTBS01.DBF
         3 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\INDX01.DBF
         4 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\TBS01.DBF
         5 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\USERS01.DBF
         6 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\DEMO01.DBF
         7 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\TBS02.DBF
         8 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\RMAN.DBF

8 rows selected.

> alter system switch logfile;

System altered.

> select FILE#,status,CHECKPOINT_CHANGE#,last_change#,name from v$datafile;

     FILE# STATUS  CHECKPOINT_CHANGE# LAST_CHANGE# NAME
---------- ------- ------------------ ------------ --------------------------------------------------
         1 SYSTEM          2460287034              D:\ORACLE\ORADATA\FOX\SYSTEM01.DBF
         2 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\UNDOTBS01.DBF
         3 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\INDX01.DBF
         4 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\TBS01.DBF
         5 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\USERS01.DBF
         6 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\DEMO01.DBF
         7 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\TBS02.DBF
         8 ONLINE          2460287034              D:\ORACLE\ORADATA\FOX\RMAN.DBF

8 rows selected.

> select FILE#,checkpoint_change#,recover, fuzzy from v$datafile_header;

     FILE# CHECKPOINT_CHANGE# REC FUZ
---------- ------------------ --- ---
         1         2460287034 NO  YES
         2         2460287034 NO  YES
         3         2460287034 NO  YES
         4         2460287034 NO  YES
         5         2460287034 NO  YES
         6         2460287034 NO  YES
         7         2460287034 NO  YES
         8         2460287034 NO  YES

8 rows selected.

> SELECT GROUP#,SEQUENCE#,STATUS,ARCHIVED,FIRST_CHANGE# FROM V$LOG;

    GROUP#  SEQUENCE# STATUS           ARC FIRST_CHANGE#
---------- ---------- ---------------- --- -------------
         1          2 ACTIVE           YES    2460254629
         2          1 INACTIVE         YES    2460234626
         3          3 CURRENT          NO     2460287150

> alter system switch logfile;

System altered.

> SELECT GROUP#,SEQUENCE#,STATUS,ARCHIVED,FIRST_CHANGE# FROM V$LOG;

    GROUP#  SEQUENCE# STATUS           ARC FIRST_CHANGE#
---------- ---------- ---------------- --- -------------
         1          2 INACTIVE         YES    2460254629
         2          4 CURRENT          NO     2460287160
         3          3 INACTIVE         YES    2460287150

> select FILE#,checkpoint_change#,recover, fuzzy from v$datafile_header;

     FILE# CHECKPOINT_CHANGE# REC FUZ
---------- ------------------ --- ---
         1         2460287160 NO  YES
         2         2460287160 NO  YES
         3         2460287160 NO  YES
         4         2460287160 NO  YES
         5         2460287160 NO  YES
         6         2460287160 NO  YES
         7         2460287160 NO  YES
         8         2460287160 NO  YES

8 rows selected.

> select FILE#,status,CHECKPOINT_CHANGE#,last_change#,name from v$datafile;

     FILE# STATUS  CHECKPOINT_CHANGE# LAST_CHANGE# NAME
---------- ------- ------------------ ------------ --------------------------------------------------
         1 SYSTEM          2460287160              D:\ORACLE\ORADATA\FOX\SYSTEM01.DBF
         2 ONLINE          2460287160              D:\ORACLE\ORADATA\FOX\UNDOTBS01.DBF
         3 ONLINE          2460287160              D:\ORACLE\ORADATA\FOX\INDX01.DBF
         4 ONLINE          2460287160              D:\ORACLE\ORADATA\FOX\TBS01.DBF
         5 ONLINE          2460287160              D:\ORACLE\ORADATA\FOX\USERS01.DBF
         6 ONLINE          2460287160              D:\ORACLE\ORADATA\FOX\DEMO01.DBF
         7 ONLINE          2460287160              D:\ORACLE\ORADATA\FOX\TBS02.DBF
         8 ONLINE          2460287160              D:\ORACLE\ORADATA\FOX\RMAN.DBF

8 rows selected.

> spool off