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

Home -> Community -> Usenet -> c.d.o.server -> Archive Log

Archive Log

From: Brad Orahood <BEO_at_coppery.copper-mt.com>
Date: Wed, 21 Oct 1998 08:10:42 -0700
Message-ID: <2117C8F5EDB5D11185D100805FD668D304E77B@EXCHANGE>


Rather than parallel archivers, it may be an easier solution to use larger
log files, so that the new one has more time to be built while the old one
is shuffled off. If I recall right, this can be set in the init.ora to take effect
on the next database restart.

> -----Original Message-----
> From: Jeremiah Wilton [SMTP:jeremiah_at_wolfenet.com]
> Posted At: Wednesday, October 14, 1998 1:23 PM
> Posted To: server
> Conversation: Archive Log
> Subject: Re: Archive Log
>
> 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 21 1998 - 10:10:42 CDT

Original text of this message

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