Re: can not allocate log, archival required..

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