Home » RDBMS Server » Server Administration » Alert log file (Oracle 10.2.0.3; AIX)
Alert log file [message #377218] Sun, 21 December 2008 21:57 Go to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
Could anyone please tell me why I get the following message in alert log file:

"Thread 1 advanced to log sequence 75716"

My database is working nice at present.
Re: Alert log file [message #377231 is a reply to message #377218] Mon, 22 December 2008 00:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It just say that the instance has switched log and now is starting a log with number is 75716.

Regards
Michel
Re: Alert log file [message #377235 is a reply to message #377218] Mon, 22 December 2008 01:06 Go to previous messageGo to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
Thx.

But usually I dont get this alert in other databases except
my one production database that is running on AIX os.

Why do I get this alert?

Re: Alert log file [message #377236 is a reply to message #377235] Mon, 22 December 2008 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is just an information.
And you have it in all alert.log files.

Regards
Michel
Re: Alert log file [message #377237 is a reply to message #377235] Mon, 22 December 2008 01:30 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Possibly because they do about nothing and don't need to switch logs.

Do the following and let us know if you see this message on your non-AIX databases:

SQL> alter system switch logfile;

System altered.


Previous Topic: Applying patchset 9.2.0.4
Next Topic: ORA-00379
Goto Forum:
  


Current Time: Fri Jul 05 03:16:07 CDT 2024