Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Tom Kyte

Thanks for the question.

Asked: July 22, 2007 - 4:59 pm UTC

Last updated: July 23, 2007 - 1:12 pm UTC

Version: 9.2.0.7

Viewed 1000+ times

You Asked

Hi Tom
My alert log file shows following information all the time....can you please explain me whats going on??
Sun Jul 22 07:43:40 2007
Thread 1 advanced to log sequence 146380
Current log# 2 seq# 146380 mem# 0: /u18/oradata/isle/isle_redolog_02a.dbf
Current log# 2 seq# 146380 mem# 1: /u19/oradata/isle/isle_redolog_02b.dbf
Sun Jul 22 07:44:25 2007
Thread 1 advanced to log sequence 146381
Current log# 3 seq# 146381 mem# 0: /u18/oradata/isle/isle_redolog_03a.dbf
Current log# 3 seq# 146381 mem# 1: /u19/oradata/isle/isle_redolog_03b.dbf
Sun Jul 22 07:45:10 2007
Thread 1 advanced to log sequence 146382
Current log# 1 seq# 146382 mem# 0: /u18/oradata/isle/isle_redolog_01a.dbf
Current log# 1 seq# 146382 mem# 1: /u19/oradata/isle/isle_redolog_01b.dbf
Sun Jul 22 07:45:58 2007
Thread 1 advanced to log sequence 146383
Current log# 2 seq# 146383 mem# 0: /u18/oradata/isle/isle_redolog_02a.dbf
Current log# 2 seq# 146383 mem# 1: /u19/oradata/isle/isle_redolog_02b.dbf
Sun Jul 22 07:46:44 2007
Thread 1 advanced to log sequence 146384
Current log# 3 seq# 146384 mem# 0: /u18/oradata/isle/isle_redolog_03a.dbf
Current log# 3 seq# 146384 mem# 1: /u19/oradata/isle/isle_redolog_03b.dbf
Sun Jul 22 07:47:29 2007
Thread 1 advanced to log sequence 146385
Current log# 1 seq# 146385 mem# 0: /u18/oradata/isle/isle_redolog_01a.dbf
Current log# 1 seq# 146385 mem# 1: /u19/oradata/isle/isle_redolog_01b.dbf
Sun Jul 22 07:48:14 2007
Thread 1 advanced to log sequence 146386
Current log# 2 seq# 146386 mem# 0: /u18/oradata/isle/isle_redolog_02a.dbf
Current log# 2 seq# 146386 mem# 1: /u19/oradata/isle/isle_redolog_02b.dbf
Sun Jul 22 07:48:59 2007
Thread 1 advanced to log sequence 146387
Current log# 3 seq# 146387 mem# 0: /u18/oradata/isle/isle_redolog_03a.dbf
Current log# 3 seq# 146387 mem# 1: /u19/oradata/isle/isle_redolog_03b.dbf
Sun Jul 22 07:49:48 2007
Thread 1 advanced to log sequence 146388
Current log# 1 seq# 146388 mem# 0: /u18/oradata/isle/isle_redolog_01a.dbf
Current log# 1 seq# 146388 mem# 1: /u19/oradata/isle/isle_redolog_01b.dbf
Sun Jul 22 07:51:25 2007
Thread 1 advanced to log sequence 146389
Current log# 2 seq# 146389 mem# 0: /u18/oradata/isle/isle_redolog_02a.dbf
Current log# 2 seq# 146389 mem# 1: /u19/oradata/isle/isle_redolog_02b.dbf

and Tom said...

it shows that you fill a log file about every minute.

when you fill one, we advance to the next. eventually we come back around and reuse the first one. I don't see any archiving messages, and only three logs and a wraparound did happen - so you must not be in archivelog mode (so you don't care about losing all changes since your last cold backup - ALL changes - it'll happen, it is just a matter of time).

I don't see any checkpoint not complete messages either, so you are checkpointing well and fast enough.


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks for explanation

A reader, July 23, 2007 - 1:20 pm UTC

This is an alert log of 3T production database....I've informed senior dba well before, after getting a chance to ask you about archiving, that we ought to run archive mode.
It was ignored by saying that it takes way too long to load the data since it creates too many logs and its difficult to move them off the system.
Hopefully this kind of response will trigger something.
I appreciate your response.