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>


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-03
Received on Wed Apr 23 2003 - 02:07:57 CEST

Original text of this message