>
> Ari,
>
> Just visited your site and I think it's awesome!
>
> I have an Oracle server (Solaris 2.5.1, Oracle Enterprise 7.3.3) and noticed
> that something is continuously writing the following
> line$ORACLE_HOME/rdbms/log/alert_SID.log ;
>
> Thu May 7 06:13:43 1998
> Thread 1 advanced to log sequence 3038
> Current log# 2 seq# 3038 mem# 0: /oracle/oracle7/dbs/log2LA98.dbf
>
> What does this mean? Is this the sign of a problem? Any hints will be
> appreciated. Thanks...
>
> Andy Martinez
Thanks for the compliments, Andy. I do the web site for free and appreciate
comments.
As for your alert messages, they are normal notifications of redo log changes.
"log2LA98.dbf" is one of your redo logs. Oracle uses redo logs to keep track
of all changes in the database (in the event of a failure). Oracle will keep
writing changes to the online redo log; once it fills, Oracle does a switch
and puts the message you see in the alert_SID.log file. Then Oracle will
write to the next redo log, and so on.
This is a normal database occurrence.
Best of luck,
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page