| 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
I think you might possibly lose messages. but I also think that the risk is worth it if you don't want to do the delete.
>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 08:32:58 -0800
>
>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?
>
> >>> carmichr_at_hotmail.com 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" <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).
>
>_________________________________________________________________
>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 - 12:05:06 CDT
 |
 |