RE: Redolog problem - Anyone?

Ronen,

Appears to be one of two problems - either you've cycled through your redo logs so quickly that they haven't had a chance to archive, or your archive log destination is full. Check the archive log destination, if it isn't full, increase the number of redo logs.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Ronen Levit [mailto:RonenL_at_talmai.com] Sent: Sunday, August 20, 2000 8:15 AM
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).