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