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 -> Re: ORACLE INSTANCE sys_id1 - Can not allocate log, archival required

Re: ORACLE INSTANCE sys_id1 - Can not allocate log, archival required

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Wed, 15 Sep 1999 09:12:16 -0600
Message-ID: <37dfb6e6@news.cadvision.com>


Your database is in archive log mode, but it is not set to autoarchive. To quickly get you going:
alter system switch logfile

You can also change settings with
alter system archive log .....

In your initxxx.ora set the parameter
log_archive_start = true # if you want automatic archiving

Take a look at some of the other parameters too, to make sure they are what you want:
log_archive_dest = c:\orant\RDBMS73\archiveGPRD log_archive_format = %s.arc # define directories to store trace and alert files

--
Terry Dykstra
Canadian Forest Oil Ltd.

Administrator wrote in message <37DFA2CE.AC4C74F8_at_Student.io.TUDelft.NL>...
>Hoi,
>
>after the 'ok' for building the repository, this error pop's up on my
>server.
>Can annybody tell me whats wrong and how to correct this ?
>
>Thanks ahead,
>Bart Zwaan.
>
>--
>
> o o c c p p p |Administrator
> o o c p p |Faculteit ontwerp, Constructie en Productie
>o o c p p p |Technische Universiteit Delft
> o o c p |Jaffalaan 9, 2628 BX Delft, Nederland
> o o c c p |Tel: (015)2787312, telefax: (015)2787316
Received on Wed Sep 15 1999 - 10:12:16 CDT

Original text of this message

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