Oracle alert_<sid>.log

[umeman]

DBA's

Our database has been running for about 4 months and
the alert_<sid>.ora file has now grown to 40 MB.

Is it advisable to truncate this file.

If yes, what is the best way to do this without bringing
down the database.

Any help appreciated.

Thanks
Umesh

 

[jee]

You can delete this file without bringing down the database - at least you can under Windows.

 

[umeman]

Sorry, I forgot to mention that the Oracle instance
is running on a Sun Sparc platform

Thanks
-u-

 

[alexhu]

edit it using vi (although you might be lucky to do this with that size of file)

zero it out '>alert_SID.log'

Alex

 

[ngibbs]

But before you clear it out, check for any errors. Ideally you should be parsing this file regurlaly to check for errors and then clearing it out.