Oracle 学习之--Buffer Cache深入解析
SQL> select * from v$log;GROUP# THREAD#SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
5 1 952 10485760 2 YES INACTIVE 1360633 23-JUL-14
6 1 953 10485760 2 NOCURRENT 1360669 23-JUL-14
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD#SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
5 1 954 10485760 2 YES INACTIVE 1360952 23-JUL-14
6 1 955 10485760 2 NOCURRENT 1360962 23-JUL-14
日志：
Completed checkpoint up to RBA , SCN: 1360669
Wed Jul 23 15:08:08 2014
Beginning log switch checkpoint up to RBA , SCN: 1360952
Thread 1 advanced to log sequence 954
Current log# 5 seq# 954 mem# 0: +DG1/prod/onlinelog/group_5.263.848858213
Current log# 5 seq# 954 mem# 1: +RCY1/prod/onlinelog/group_5.256.848858217
Wed Jul 23 15:08:25 2014
Thread 1 cannot allocate new log, sequence 955
Checkpoint not complete
Current log# 5 seq# 954 mem# 0: +DG1/prod/onlinelog/group_5.263.848858213
Current log# 5 seq# 954 mem# 1: +RCY1/prod/onlinelog/group_5.256.848858217
Wed Jul 23 15:08:33 2014
Completed checkpoint up to RBA , SCN: 1360952
Wed Jul 23 15:08:34 2014
Beginning log switch checkpoint up to RBA , SCN: 1360962
Thread 1 advanced to log sequence 955
Current log# 6 seq# 955 mem# 0: +DG1/prod/onlinelog/group_6.264.848858253
Current log# 6 seq# 955 mem# 1: +RCY1/prod/onlinelog/group_6.257.848858259
Wed Jul 23 15:08:36 2014
Completed checkpoint up to RBA , SCN: 1360962
页:
[1]