"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
news:40561367$0$31902$afc38c87_at_news.optusnet.com.au...
> Understand what "putting a database into archivelog mode" actually means.
It
> means setting a bit in the control file which says "you are no longer
> permitted to over-write the contents of the online redo logs unless they
> have been archived".
>
> And that's it.
>
> It says nothing about actually *taking* the archives in the first place.
>
> Therefore, you've just successfully instructed your database to fill up
all
> the online logs and then come to a grinding halt, because no further
online
> logs are available, and the ones you've got can't be over-written.
Fantastic stuff isn't it. You decide you want to run in archivelog mode and
Oracle insists that there is a possibility that you wish to archive
manually. Right up there with pctincrease=50 and compress=y for me.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Mar 16 2004 - 03:02:46 CST
