RE: Redolog problem - Anyone?

CAUSE - Redo Log switching happening so FAST that the Redo RE-Cycled Back to the Initial online Redo logfile whose respective Data had NOT yet Completely Checkpointed (written to Datafile)

Related parameter log_checkpoint_interval (Unit being O.S. Blocks)

List please Correct

> -----Original Message-----
> From: Ronen Levit [SMTP:RonenL_at_talmai.com]
> Sent: Sunday, August 20, 2000 6:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Redolog problem - Anyone?
>
> Hi all,
>
> While running in multi-thread processes that performs loading and
> inserting
> using SQL*Loader and some PL/SQL (in all 4 threads), I got the following
> error, and the Oracle got stuck. It is on a development database, and
> occured during the night of the weekend.
> When we first noticed that, after couple of hours, we tried to login the
> system but the logins hanged on and were stuck too.
>
> Looking for some help on that. Why it happened and how can we prevent such
> errors in the future?
>
> I've read in some earlier threads in the news that its an unexpected error
> that sometimes might happen ... sounds awful.
>
> Fri Aug 18 02:52:08 2000
> Thread 1 advanced to log sequence 88813
> Current log# 1 seq# 88813 mem# 0: S:\ORACLE\ORADATA\CLEODB\REDO01.LOG
> Current log# 1 seq# 88813 mem# 1: S:\ORACLE\ORADATA\CLEODB\REDO02.LOG
> Fri Aug 18 02:52:26 2000
> Thread 1 advanced to log sequence 88814
> Current log# 3 seq# 88814 mem# 0: S:\ORACLE\ORADATA\CLEODB\REDO05.LOG
> Current log# 3 seq# 88814 mem# 1: S:\ORACLE\ORADATA\CLEODB\REDO06.LOG
> Fri Aug 18 02:52:43 2000
> Thread 1 cannot allocate new log, sequence 88815 <-----
> Checkpoint not complete
> Current log# 3 seq# 88814 mem# 0: S:\ORACLE\ORADATA\CLEODB\REDO05.LOG
> Current log# 3 seq# 88814 mem# 1: S:\ORACLE\ORADATA\CLEODB\REDO06.LOG
> Dump file D:\Oracle\admin\Cleodb\bdump\cleodbALRT.LOG
>
> Ronen Levit
> Database group manager
> Talmai
> Tel: +972 8 9460606 #212
> Fax: +972 8 9460705
> Cell: +972 52 448699
>
>
> --
> Author: Ronen Levit
> INET: RonenL_at_talmai.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).
Received on Sun Aug 20 2000 - 09:58:23 CDT