Re: Archive Log

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: 1998/10/14
Message-ID: <Pine.OSF.3.95.981014130058.12686I-100000@gonzo.wolfenet.com>#1/1

On Wed, 14 Oct 1998, 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?

You are making changes in the database, and generating redo, faster than the ARCH process can archive the redologs. If you look at v$log, you will see how many of your online logs need archiving at any given time. When you see the message that is bothering you, they all need archiving.

I think it is possible to have multiple parallel archivers in 8.0.4, but I'm not sure how to start them.

--
Jeremiah Wilton      http://www.wolfenet.com/~jeremiah

Received on Wed Oct 14 1998 - 00:00:00 CDT