Thanks Rachel. I agree. But I am still troubled by one thing. If I do adopt this
method. What if after I copy the alert.log and before null it, Oracle writes
something (a line or two) to the alert.log? It seems that I will lose those
messages.
What do you think?
>>> [EMAIL PROTECTED] 07/11/01 11:47AM >>>
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" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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.
>
> >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).
_________________________________________________________________
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
