Dec 9, 2002 #1 umeman Technical User Joined Oct 2, 2001 Messages 59 Location US 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
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
Dec 9, 2002 #2 jee Programmer Joined Sep 20, 2001 Messages 358 Location US You can delete this file without bringing down the database - at least you can under Windows. Upvote 0 Downvote
Dec 9, 2002 Thread starter #3 umeman Technical User Joined Oct 2, 2001 Messages 59 Location US Sorry, I forgot to mention that the Oracle instance is running on a Sun Sparc platform Thanks -u- Upvote 0 Downvote
Dec 10, 2002 #4 alexhu MIS Joined Sep 25, 2001 Messages 1,288 Location GB edit it using vi (although you might be lucky to do this with that size of file) zero it out '>alert_SID.log' Alex Upvote 0 Downvote
edit it using vi (although you might be lucky to do this with that size of file) zero it out '>alert_SID.log' Alex
Dec 10, 2002 #5 ngibbs MIS Joined Oct 2, 2002 Messages 11 Location CA 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. Upvote 0 Downvote
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.