| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rename alert log
My take on this is... if modifying the script won't hurt anything, do so. I'd rather do MORE than less when it comes to being proactive with Oracle.
>From: "Richard Ji" <rji_at_exenet.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Rename alert log
>Date: Wed, 11 Jul 2001 06:30:26 -0800
>
>I knew you weren't crazy, Rachel. :)
>
>So far this "feature" hasn't worked for me. I have been moving
>the alert.log and let Oracle create a new one since 8.0.5 and now
>on 8.1.7 when I was unware of this "feature". Now that I read about
>it I am troubled. Oh I am on Solaris 7 and 8 BTW.
>
>Hmmm... I am pondering whether I should modify my script or not.
>
> >>> carmichr_at_hotmail.com 07/11/01 09:05AM >>>
>Okay folks, I *knew* I wasn't crazy! thanks to Anita for finding the post
>that Bruce sent to the list, that had the metalink doc in it
>
>There was also a bug filed on it (which was closed as "not a bug") bug#
>1388186
>
>It was filed for Solaris so this might just mean that the "feature" is
>Solaris specific, since people here are saying that they haven't seen it on
>other platforms.
>
>We are on Solaris, but our scripts are written such that we don't rename
>the
>alert log so I haven't been able to prove it one way or another.
>
>Rachel
>
>Note:122401.1
>Type: BULLETIN
>Status: PUBLISHED
>Content Type: TEXT/PLAIN
>Creation Date: 18-OCT-2000
>Last Revision Date: 14-MAY-2001
>
>Problem Description
>-------------------
>
>The Oracle background processes has an open file descriptor on the
>alert.log.
>When the database is up and running it continually holds this file
>descriptor open. This was not the case in 7.3.4, but is true for 8.0.5 to
>8.1.7.
>
>This poses the question: What if the database is up and the alert.log
>gets too large. Do I have to shutdown the database to release the open file
>descriptor on the alert.log, then deal with the large alert.log?
>
>
>Solution Description
>--------------------
>
>You are able to copy the alert.log while the database is up and running.
>
>1) Create an empty file:
> (example: touch nullfile.log)
>
>2) Replace the old alert.log with the new empty file:
> (example: mv nullfile.log alert<sid>.log)
>
>The running database experiences no affects when doing this.
>
>
>Explanation
>-----------
>
>Having the continual open file descriptor on the alert.log is intended
>behaviour for the database.
>
>
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Richard Ji
> INET: rji_at_exenet.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jul 11 2001 - 09:37:46 CDT
 |
 |