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