Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: archivelog leads to crashes...?
"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 UKReceived on Tue Mar 16 2004 - 03:02:46 CST
![]() |
![]() |