RE: CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED error

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 12 Jan 2001 09:24:05 -0800
Message-Id: <10739.126525@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07CBC.768E0A50
Content-Type: text/plain;

charset="iso-8859-1"

>-----Original Message-----
>From: Bunyamin K.Karadeniz [mailto:bunyamink_at_havelsan.com.tr]
>Sent: vendredi, 12. janvier 2001 06:56
>
>CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED 
>
>MESSAGE IS DISPLAYED WHEN I want to import a huge table;
>What must I do???            Thanks

Doesn't it mean that some of the logs need to be manually archived? Try typing in "archive log list" in svrmgr. Do you see the following? SVRMGR> archive log list
Database log mode Archive Mode
Automatic archival Disabled

If Automatic archival is disabled you may need to do an "alter system archive log" (read the documentation for the correct syntax. e.g.
SVRMGR> alter system archive log all ;

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

------_=_NextPart_001_01C07CBC.768E0A50
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED error</TITLE>
</HEAD>
<BODY>

>-----Original Message-----
 >From: Bunyamin K.Karadeniz [<A =
HREF=3D"mailto:bunyamink_at_havelsan.com.tr">mailto:bunyamink_at_havelsan.com.= tr</A>]
 >Sent: vendredi, 12. janvier 2001 06:56
 >
 >CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED 
 >
 >MESSAGE IS DISPLAYED WHEN I want to import a =
huge table;
 >What must I =

do???            = Thanks 


Doesn't it mean that some of the logs need to be =
manually archived? Try typing in "archive log list" in = svrmgr. Do you see the following?

SVRMGR> archive log list 
 Database log mode Archive Mode
 Automatic archival Disabled


If Automatic archival is disabled you may need to do =
an "alter system archive log" (read the documentation for the = correct syntax.

e.g.
 SVRMGR> alter system archive log all ;


------
 any ignorant comments made are the sole =
responsibility of J. R. Kilchoer and should not reflect adversely upon = my employer.

 
 Jacques R. Kilchoer
 (949) 754-8816
 Quest Software, Inc.
 8001 Irvine Center Drive
 Irvine, California 92618
 U.S.A.
 <A HREF=3D"http://www.quest.com" =
TARGET=3D"_blank">http://www.quest.com</A> Received on Fri Jan 12 2001 - 11:24:05 CST