Re: Strange ARCHIVE LOG LIST

"roblop" <roblop_at_friko2.onet.pl> wrote in message news:9olbhb$f1r$1_at_news2.ipartners.pl...
> My friend has Oracle 8.0.5 on NT 4.0 SP6A.
> He lost one tablespace and recover that. After it he type ARCHIVE LOG LIST
> and result below:
>
> SVRMGR> ARCHIVE LOG LIST;
> Database log mode Archive Mode
> Automatic archival Enabled
> Archive destination f:\archive
> Oldest online log sequence 24
> Next log sequence to archive 27
> Current log sequence 27
>
>
> Oldest online log sequence is less than Next log sequence to archive and
> it's OK. But diffrent must be ONE, not THREE.
>
> It's all OK or It's Oracle bug ?
>
> Regards, Roblop
>
>
>
>

This is quite normal.
I don't know why you think the difference must be always one. As soon as the database switches to sequence 28 (and archives sequence 27) sequence 24 will fall off and the display will look like

25
28
28

Oracle 8.0.5 has been desupped more than a year ago.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sun Sep 23 2001 - 15:55:31 CDT