RE: CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED error

From: David Barbour <dbarbour_at_connectsouth.com>
Date: Mon, 15 Jan 2001 15:44:17 -0600
Message-Id: <10742.126719@fatcity.com>

Even if automatic archiving is enabled - it may not be STARTED!

You'll have to shutdown, connect internal, startup mount, alter system archive log start

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Trivedi, Hitarth [mailto:HTrivedi_at_telergy.net] Sent: Monday, January 15, 2001 10:10 AM
To: Multiple recipients of list ORACLE-L Subject: RE: CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED error

If I understand the problem correctly, the message just means that archive process is falling behind the rate at which redo log records are generated. If this is the case then you must be getting this message in separate window (again I am assuming that you have oracle on NT) just as warning and not error stalling import operation. The easiest way is to increase no. of redo log groups.

-----Original Message-----
Sent: Monday, January 15, 2001 2:15 AM
To: Multiple recipients of list ORACLE-L

Thanks For your help BUT aS YOU SEE Automatic archival IS Enabled

SQL> archive log list

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            C:\dbmirror\DATABASE\TEST\ARCHIVE
Oldest online log sequence     496
Next log sequence to archive   498
Current log sequence           498

Original Message ----- To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> Sent: Friday, January 12, 2001 8:26 PM

>-----Original Message-----
>From: Bunyamin K.Karadeniz [ mailto:bunyamink_at_havelsan.com.tr
<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 <http://www.quest.com>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trivedi, Hitarth
  INET: HTrivedi_at_telergy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Mon Jan 15 2001 - 15:44:17 CST