-
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.
-
nothing is wrong, thats a normal message - shows you had has a log switch
that's what logging is for
-
Originally Posted by davey23uk
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 !
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|