|
Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Mailing Lists ->
Oracle-L ->
RE: Redolog problem - Anyone?
RE: Redolog problem - Anyone?
I've run into this before. My problem was the first one David listed. By
adding additional redo logs the problem was solved.
HTH,
- David Barbour <DBarbour_at_connectsouth.com> wrote:
> 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-----
> Sent: Sunday, August 20, 2000 8:15 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> --
> Author: David Barbour
> INET: DBarbour_at_connectsouth.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).
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Received on Mon Aug 21 2000 - 15:57:19 CDT
Original text of this message
