This discussion is archived
7 Replies Latest reply: Dec 7, 2012 8:17 AM by Osama_Mustafa RSS

Thread 1 advanced to log sequence 3507

OraFighter Newbie
Currently Being Moderated
why my alert log file showing the following error message.
it is reapeting every 2 to 3 minutes.

Fri Dec 07 17:17:12 2012
Thread 1 advanced to log sequence 3507 (LGWR switch)
Current log# 3 seq# 3507 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\dbname1\REDO03.LOG

below is the V$LOG details

GROUP#,BYTES,MEMBERS,STATUS,FIRST_TIME,NEXT_TIME
1,52428800,5,CURRENT,12/7/2012 5:21:10 PM,
2,52428800,1,INACTIVE,12/7/2012 5:01:54 PM,12/7/2012 5:06:50 PM
3,52428800,1,ACTIVE,12/7/2012 5:17:12 PM,12/7/2012 5:21:10 PM
4,4194304,2,INACTIVE,12/7/2012 5:06:50 PM,12/7/2012 5:07:12 PM
5,104857600,1,INACTIVE,12/7/2012 5:07:12 PM,12/7/2012 5:17:12 PM

How can I fix this issue.. one batch is running on my DB.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points