Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: can not allocate log, archival required..

Re: can not allocate log, archival required..

From: Tina Mourad <tmourad_at_gmx.net>
Date: 22 Mar 2002 11:45:46 -0800
Message-ID: <9be11957.0203221145.2f680bd9@posting.google.com>


mroesicke_at_vrg.de (Martin Roesicke) wrote in message news:<147fe558.0203220527.6f3f26e6_at_posting.google.com>...
> "santosh sharma" <santysharma_at_yahoo.com> wrote in message news:<a7e0a2$kglq5$1_at_ID-84096.news.dfncis.de>...
> > "Tina Mourad" <tmourad_at_gmx.net> wrote in message
> > news:9be11957.0203211643.2c1a2cf6_at_posting.google.com...
> > > I get the DOS window warning "Oracle instance xxx can not allocate
> > > log, archival required".
> > >
> > > My init.ora does have the line
> > > LOG_ARCHIVE_START = TRUE
> > >
> > > thanks in advance..
> >
> >
> > May be your archive log destination is full. You should see more details in
> > alert file.
> > hth,
> > santysharma
>
> No,
>
> you have set "alter system archive log" to enable the automatic
> archiving, otherwise you have to archiving manually.
>
> Martin

Martin,
I just did "archive log list;" on the server manager prompt. Database Log Mode: Archive Mode
Automatic Archival: Enabled

So this means I'm getting the error b/c my destination is getting full? What is the threshold? Do I delete older ARC files? Is this the correct method?

Thanks Received on Fri Mar 22 2002 - 13:45:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US