Re:RE: archive log prob.

Not necessary. In case of heavy inserts/delete/update started on database by users and log files are filled very fast this message starts and you have to locate for such processes or users who started jobs involving lot of DML's. It happened to me yesterday as after year closing, users started new GL's entry 5 to 6 processed at one time with diffrent parameters along with other concurrent jobs (Oracle Financials) and I was getting same messages for a while say half an hour or until completion of those jobs. We are using ARCHIVE MODE have not seen such messages normally. Regards
Rafiq

From: dgoulet_at_vicr.com
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Re:RE: archive log prob.
Date: Wed, 03 Jan 2001 13:55:44 -0800

Yes, just keep log_archive_start set to FALSE.

WARNING: when the online redo logs fill up the DB will stop with the ORA-00257
error.

Dick Goulet

____________________Reply Separator____________________
Author: "Armstead; Michael A" <maa25681_at_GlaxoWellcome.com>
Date:       1/3/2001 1:20 PM

Is it possible that you have your database set to manual archiving?

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo SmithKline

> -----Original Message-----
> From: Ajay Khandelwal [SMTP: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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Armstead, Michael A
   INET: maa25681_at_GlaxoWellcome.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
   INET: dgoulet_at_vicr.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).

_________________________________________________________________