RE: archive log prob.

From: Ajay Khandelwal <ajay_at_tems.com>
Date: Wed, 3 Jan 2001 14:20:59 -0600
Message-Id: <10730.125643@fatcity.com>

Thanks Sah and others ,
It worked !!!

-Ajay

-----Original Message-----

From: Kohsuwan, Sah [mailto:SKohsuwan_at_baking.bestfoods.com] Sent: Wednesday, January 03, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Subject: 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-----

Sent: Wednesday, January 03, 2001 3:26 PM To: Multiple recipients of list ORACLE-L

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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kohsuwan, Sah
INET: SKohsuwan_at_baking.bestfoods.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