RE: archive log prob.

Ajay,
Did you enable automatic archiving ? (log_archive_start=true in Init***.ora)
To solve your problem (right now) without bouncing the instance, do one of the following:
a). Alter system archive log all;
or
b). Alter system archive log start; (If you prefer not to start automatic archiving).
HTH,
Sah Kohsuwan

-----Original Message-----
From: Ajay Khandelwal [mailto:ajay_at_tems.com] Sent: Wednesday, January 03, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Subject: archive log prob.

Hi All,
I have this problem ,
while trying to insert a record using sqlplus it just gets hanged .When i tried to look into trace it says

"

Thread 1 cannot allocate new log, sequence 5 All online logs needed archiving
  Current log# 3 seq# 4 mem# 0: C:\ORACLE\ORADATA\AJAY\REDO01.LOG
"

I got a message in between saying oracle is not able to archive log file. I have checked the disk space , looks okay .

Can anyone help me why is this happening .

-Ajay

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ajay Khandelwal
  INET: ajay_at_tems.com

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
also send the HELP command for other information (like subscribing).




"WorldSecure Server <baking.bestfoods.com>" made the following

 annotations on 01/03/01 15:53:58
----------------------------------------------------------------------------
-
The origin of this electronic mail message was the Internet.
Bestfoods Baking cannot validate the authenticity
of the sender and therefore cannot be held accountable
for any content within.
=======================================================





"WorldSecure Server <baking.bestfoods.com>" made the following

 annotations on 01/03/01 16:12:06
-----------------------------------------------------------------------------
This message may contain confidential and trade secret information of Bestfoods Baking, and be subject to the Economic Espionage Act of 1996. For recipient's use only. If you have received this message in error, please delete immediately, and alert the sender.