Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Archive Log

Re: Archive Log

From: Karl E. Taylor <ktaylor_at_dragon.illusions.com>
Date: 1998/10/14
Message-ID: <36251984.DB3BC50D@dragon.illusions.com>#1/1

Essam Elsherif wrote:
>
> I'm running an ORACLE 8.04 database on NT Server n Archive Log mode. I
> frequenly get the message
>
> "Instance xxxx - Can not allocate log, archival required". It's a warning
> message, but I do not understand why ORACLE can not allocate the archive
> log? There is enough space in the archive log destination disk. How to get
> ride of this message?
>

When I first saw this message I too was a bit taken aback by it. However, if you add a redo log file you might clear up the problem. 8.0.4 on NT by default only creates 2 log files. You can get this message during a log switch while the database is loading on an import. Check to make sure you have more then 2 redo log files.

Hope this helps.

-- 
________________________________________________________________________

Karl E. Taylor                          CEO & UNIX Systems Analyst

Desert Dragon SOHO Solutions            ktaylor_at_dragon.illusions.com

                  http://www.illusions.com/ddsoho
________________________________________________________________________
Dr. Lao "You know what wisdom is?"
Little boy "No."
Dr. Lao "Wise answer."
Received on Wed Oct 14 1998 - 00:00:00 CDT

Original text of this message

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