switch logfile, checkpoint, active and inactive logfile
From: Niy <niy38_at_hotmail.com>
Date: 22 Apr 2003 17:07:57 -0700
Message-ID: <55dd405a.0304221607.58916a5b_at_posting.google.com>
------------- ---------
------------- ---------
Date: 22 Apr 2003 17:07:57 -0700
Message-ID: <55dd405a.0304221607.58916a5b_at_posting.google.com>
I can not understand following: why switch logfile doesn't trigger
a checkpoint? only until I issue "alter system checkpoint", then
the "active" logfile change to "inactive"? I don't enable archivelog.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
2 1 84 104857600 1 NO CURRENT 11891725 22-APR-03 3 1 83 10485760 2 NO ACTIVE 11887925 22-APR-03
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------FIRST_CHANGE# FIRST_TIM
------------- ---------
2 1 84 104857600 1 NO ACTIVE 11891725 22-APR-03 3 1 85 10485760 2 NO CURRENT 11893588 22-APR-03
SQL> alter system checkpoint;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------FIRST_CHANGE# FIRST_TIM
------------- ---------
2 1 84 104857600 1 NO INACTIVE 11891725 22-APR-03 3 1 85 10485760 2 NO CURRENT 11893588 22-APR-03Received on Wed Apr 23 2003 - 02:07:57 CEST