Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: can not allocate log, archival required..
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