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: 26 Mar 2002 14:19:49 -0800
Message-ID: <9be11957.0203261419.741a8254@posting.google.com>


I guess not really - and I'll add my IT boss to that list ;-) One of these days, hopefully i'll take a DBA course.

I will check out ur website, thanks howard.

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a7grm9$qa4$1_at_lust.ihug.co.nz>...
> Yikes. I don't want to be cruel. But have you any idea what the principles
> underlying backup and recovery are? You do *not* delete archives unless
> absolutely necessary, and even then you make sure that the deletion doesn't
> compromise your recoverability.
>
> Please: take 20 minutes or so (ok, it may be 200 minutes) to skim my backup
> and recovery document at the website mentioned below (the Books link). Then
> decide. Concentrate on chapters 4, 5 6 and 7.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Tina Mourad" <tmourad_at_gmx.net> wrote in message
> news:9be11957.0203221145.2f680bd9_at_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 Tue Mar 26 2002 - 16:19:49 CST

Original text of this message

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