Re: switch logfile, checkpoint, active and inactive logfile

Please, thanks!

Niy wrote:
> 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 - 21:23:26 CEST