Message in Alert Log ((LGWR switch).>What's wrong?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Message in Alert Log ((LGWR switch).>What's wrong?

  1. #1
    Join Date
    Jan 2003
    Posts
    33

    Message in Alert Log ((LGWR switch).>What's wrong?

    I have Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production running on AIX Version 6. Every time a log switch occurs I get this message in Alert log...
    Thread 1 advanced to log sequence *** (LGWR switch)


    This is how my redo logs are:
    GROUP# BYTES MEMBERS STATUS
    ---------- ---------- ---------- ---------------
    1 1610612736 2 INACTIVE
    2 1610612736 2 INACTIVE
    3 1610612736 2 CURRENT

    I tried with diff. size (100M,500M,1024M etc). still I keep getting same message..Can someone suggest what's wrong?

    As I am in the process of setting of this database for future production needs, I need to correct this. At this time I am the only one connected to this database.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    nothing is wrong, thats a normal message - shows you had has a log switch

    that's what logging is for

  3. #3
    Join Date
    Jan 2003
    Posts
    33
    Quote Originally Posted by davey23uk View Post
    nothing is wrong, thats a normal message - shows you had has a log switch

    that's what logging is for
    Thanks for the reply. I have many other Oracle-10g instances, however I have never seen that message on other instances !

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    look harder

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width