Re: can not allocate log, archival required..

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Fri, 22 Mar 2002 20:58:30 -0500
Message-ID: <a7gnbn$ko4dt$1@ID-82084.news.dfncis.de>

On Fri, 22 Mar 2002 14:45:46 -0500, Tina Mourad wrote:

> 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

That means that you should take your oracle manuals to Arthur Andresen & Co. so they can shred them as youu are obviously not using them. That means that the bulky manuals are just consuming space on your shelve which could be put to a better use. If you have any of Rama Velpuri's books, take them to Andresen too, as he mentions things like archiving, backup and recovery.
RTFM.

-- 
Mladen Gogala

Received on Fri Mar 22 2002 - 19:58:30 CST