7 Replies Latest reply: Dec 7, 2012 10:17 AM by Osama_Mustafa RSS

    Thread 1 advanced to log sequence 3507

    OraFighter
      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.