Re: can not allocate log, archival required..

No worries. I only mentioned this because the others had already diagnosed the problem as a full archive destination, so yes... at some point, you'll want to delete old archives, but the key word there is "old", so understanding the principles involved should let you decide with a fair degree of confidence what counts as "old" and disposable.

The short answer is: any archives taken prior to a new, complete backup can be considered (technically) disposable. But prudence (and some bad experiences in a server room!) have taught me that it is always better to buy a new hard disk than to be too ruthless in getting rid of old archives.

Hope that doco is of some use. And that you get your problem fixed *safely*!!

Regards
HJR

--
------------------------------------------
Resources for Oracle : www.hjrdba.com
============================


"Tina Mourad" <tmourad_at_gmx.net> wrote in message
news:9be11957.0203261419.741a8254_at_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