RE: archive log prob.

--openmail-part-187115c6-00000001
Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline

        ;Creation-Date="Wed, 3 Jan 2001 15:04:07 -0600" Content-Transfer-Encoding: 7bit

Does the init.ora contain the entry "log_archive_start = true"? If not, logs won't be offloaded automatically. If that's the case, you can clear the immediate problem with "alter system archive log all". Afterward, issue "alter system archive log start" to enable automatic archiving (and add the init.ora entry!).

-----Original Message-----
From: ajay [mailto:ajay_at_tems.com]
Sent: Wednesday, January 03, 2001 2:26 PM To: ORACLE-L
Cc: ajay
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).