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
阅读(1315) | 评论(1) | 转发(0) |
