Re: Strange ARCHIVE LOG LIST

Hi,
Did you count the number of groups of redo logs. Mays be you have a lot and the diffrence can be equal to that number.

mathias FATENE

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message news: tqsje4j0tsr50b_at_news.demon.nl...
>
> "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 Mon Sep 24 2001 - 17:20:13 CDT