Re: Rename alert log
Sorry, I thought one thing and typed another. We do a mv in each of our 8.1.7.x databases on Sun/Sparc 7&8 and have been doing it for years from 8.0.5 on. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 11, 2001 8:05 AM > 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.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: 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).
Re: Rename alert log
I don't know if anyone mentioned Solaris. Running Sun/Sparc Solaris 6&7 and Oracle 8.1.7.1. A cron job filed shell script does a cp only, no touch, then mails the old log to the DBAs. It works the same way as it did a month or two ago when we went from 8.0.5 to 8.1.7: next time Oracle needs to write something, it creates a new file. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 11, 2001 8:05 AM > 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.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: 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).
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" <[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 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? > > >>> [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.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:/
Re: Rename alert log
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.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 Serv
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" <[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.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).
RE: Rename alert log
Rachel, Hmm, doesn't ring a bell with me, but I'd expect the Goddess to have a better memory than me ;) According to the note Bruce Reardon mentioned (note 122401.1) the file cannot be renamed, as you described. It might vary from platform to platform, however. NT/Win2K, for example, will always recreate the alert.log, and trace files for that matter, whenever they're moved, renamed, or deleted. Haven't had a chance to test it on other platforms besides Solaris and NT/Win2K and I'm sure if I wait long enough someone else will ;) HTH, -- Anita --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > Okay, okay I believe you all! But I DO remember > Anita posting that it had > changed... time to dig through MetaLink, and bug > Anita while I'm at it :) > > Rachel > > > >From: "Farnsworth, Dave" > <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > >Subject: RE: Rename alert log > >Date: Tue, 10 Jul 2001 11:05:39 -0800 > > > >I am running 8.1.7 and just last week renamed my > alert.log while the > >database was up and everything seemed to work fine. > It created a new alert > >log on the fly. > > > >Dave > > > >-Original Message- > >Sent: Tuesday, July 10, 2001 1:01 PM > >To: Multiple recipients of list ORACLE-L > > > > > >In 816 on NT, you can rename it any time you want. > > > >is this changing in 817 Rachel? > > > >Tom Mercadante > >Oracle Certified Professional > > > > > >-Original Message- > >Sent: Tuesday, July 10, 2001 1:27 PM > >To: Multiple recipients of list ORACLE-L > > > > > >depends on the version of the database you are > running.. it used to be that > >yes, you could just rename it and Oracle would open > a new one of the > >original name when it needed to write to it. > > > >In 8.? and above, you can no longer just rename it, > Oracle now maintains an > >open file pointer to it, similar to the way it > handles the listener log > >file. So you will need to do the same sort of > tricks to the alert log as > >you > > > >have to do to the listener log (make a copy then > copy /dev/null to the > >original) > > > > > > > > >From: "Smith, Ron L." <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > >Subject: Rename alert log > > >Date: Tue, 10 Jul 2001 06:56:31 -0800 > > > > > >Can the alert log be renamed while the database > is up and running? > > > > > >Ron __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
Re: Rename alert log
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.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).
Re: Rename alert log
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.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).
RE: Rename alert log
Okay, okay I believe you all! But I DO remember Anita posting that it had changed... time to dig through MetaLink, and bug Anita while I'm at it :) Rachel >From: "Farnsworth, Dave" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Rename alert log >Date: Tue, 10 Jul 2001 11:05:39 -0800 > >I am running 8.1.7 and just last week renamed my alert.log while the >database was up and everything seemed to work fine. It created a new alert >log on the fly. > >Dave > >-Original Message- >Sent: Tuesday, July 10, 2001 1:01 PM >To: Multiple recipients of list ORACLE-L > > >In 816 on NT, you can rename it any time you want. > >is this changing in 817 Rachel? > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Tuesday, July 10, 2001 1:27 PM >To: Multiple recipients of list ORACLE-L > > >depends on the version of the database you are running.. it used to be that >yes, you could just rename it and Oracle would open a new one of the >original name when it needed to write to it. > >In 8.? and above, you can no longer just rename it, Oracle now maintains an >open file pointer to it, similar to the way it handles the listener log >file. So you will need to do the same sort of tricks to the alert log as >you > >have to do to the listener log (make a copy then copy /dev/null to the >original) > > > > >From: "Smith, Ron L." <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Rename alert log > >Date: Tue, 10 Jul 2001 06:56:31 -0800 > > > >Can the alert log be renamed while the database is up and running? > > > >Ron > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Smith, Ron L. > > 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: Mercadante, Thomas F > 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: Farnsworth, Dave > 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
RE: Rename alert log
Hi, I have just found the email I posted earlier about this in the List archives. To find it search for "when it will need to delete the alert log file" I can't comment on the accuracy with respect to Unix as don't use it. Under NT as others have said you can just rename the alert logfile and a new one will be created. The note summary is: Deleting the alert.log when the database is up Type: Note Doc ID: 122401.1 Modified Date: 14-MAY-2001 Status: PUBLISHED Platform: Unix Generic issue Product: Oracle Server - Enterprise Edition V7 Regards, Bruce Reardon "On Sunday 27 May 2001 18:10, Reardon, Bruce (CALBBAY) wrote: > Hi, > > For information. > > At various times there has been a lot of discussion about deleting = the > alert.log. > > Looking through Metalink I found the following note which describes = the > behaviour change between 7.3.4 and 805 and above. > > Hope it is of help. > > Regards, > Bruce > > > Doc ID: 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.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. > > > References > -- > > [BUG:1388186] OPEN FILE DESCRIPTORS HELD BY ORACLE BACKGROUND = PROCESSES >ON ALERT.LOG FILE > > > Additional Search Words > --- > > delete alert" -Original Message- Sent: Wednesday, 11 July 2001 5:06 To: Multiple recipients of list ORACLE-L dunno about NT, I do know that it changed on Unix.. as per a thread here in the not too distant past. I believe Anita had posted something on it.. and that it WAS a change from prior versions. I am an Oracle on NT ignoramus :) >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >Date: Tue, 10 Jul 2001 10:00:34 -0800 > >In 816 on NT, you can rename it any time you want. > >is this changing in 817 Rachel? > >Tom Mercadante >Oracle Certified Professional > >-Original Message- >Sent: Tuesday, July 10, 2001 1:27 PM > >depends on the version of the database you are running.. it used to be that >yes, you could just rename it and Oracle would open a new one of the >original name when it needed to write to it. > >In 8.? and above, you can no longer just rename it, Oracle now maintains an >open file pointer to it, similar to the way it handles the listener log >file. So you will need to do the same sort of tricks to the alert log as >you > >have to do to the listener log (make a copy then copy /dev/null to the >original) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).
Re: Rename alert log
Does anyone know starting from which version you have to do the tricky thing to rename the alert.log? Or is this only apply to certain OS platforms? I am on 8.1.7 EE on Solaris8 and I can still just move the alert.log and Oracle will just recreate one when it needs to write the next message. I don't like this new rule that you have to copy it and then null the alert log since those are two separate operations. I can loss a message or two if there is a lag after the copying is done and before nulling the log file. >>> [EMAIL PROTECTED] 07/10/01 01:26PM >>> depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it. In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, similar to the way it handles the listener log file. So you will need to do the same sort of tricks to the alert log as you have to do to the listener log (make a copy then copy /dev/null to the original) >From: "Smith, Ron L." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Rename alert log >Date: Tue, 10 Jul 2001 06:56:31 -0800 > >Can the alert log be renamed while the database is up and running? > >Ron >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > 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).
Re: Rename alert log
For the listener I had do the following to get listener to archive its old logs lsnrctl set log_file $ORACLE_HOME/network/log/listener1.log mv $ORACLE_HOME/network/log/listener.log $ORACLE_HOME/network/log/listener.log.$QUALIFIER lsnrctl set log_file $ORACLE_HOME/network/log/listener.log But for alert.log it works fine with a simple mv mv $ORACLE_BASE/admin/$SID/bdump/alert_$SID.log \ $ORACLE_BASE/admin/$SID/bdump/alert_$SID.log.$QUALIFIER We are on 8.1.5. Satish>>> [EMAIL PROTECTED] 07/10/01 10:26AM >>>depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it.In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, similar to the way it handles the listener log file. So you will need to do the same sort of tricks to the alert log as you have to do to the listener log (make a copy then copy /dev/null to the original)>From: "Smith, Ron L." <[EMAIL PROTECTED]>>Reply-To: [EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>>Subject: Rename alert log>Date: Tue, 10 Jul 2001 06:56:31 -0800>>Can the alert log be renamed while the database is up and running?>>Ron>-->Please see the official ORACLE-L FAQ: http://www.orafaq.com>-->Author: Smith, Ron L.> 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Rename alert log
Yup -Original Message- L. Sent: Tuesday, July 10, 2001 03:57 To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Mark Leith 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).
RE: Rename alert log
Title: RE: Rename alert log same here. jon -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rename alert log I am running 8.1.7 and just last week renamed my alert.log while the database was up and everything seemed to work fine. It created a new alert log on the fly. Dave
RE: Rename alert log
Oh yea, I forgot to mention that I have Oracle running on NT. :( Dave -Original Message- Sent: Tuesday, July 10, 2001 2:06 PM To: Multiple recipients of list ORACLE-L I am running 8.1.7 and just last week renamed my alert.log while the database was up and everything seemed to work fine. It created a new alert log on the fly. Dave -Original Message- Sent: Tuesday, July 10, 2001 1:01 PM To: Multiple recipients of list ORACLE-L In 816 on NT, you can rename it any time you want. is this changing in 817 Rachel? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 10, 2001 1:27 PM To: Multiple recipients of list ORACLE-L depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it. In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, similar to the way it handles the listener log file. So you will need to do the same sort of tricks to the alert log as you have to do to the listener log (make a copy then copy /dev/null to the original) >From: "Smith, Ron L." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Rename alert log >Date: Tue, 10 Jul 2001 06:56:31 -0800 > >Can the alert log be renamed while the database is up and running? > >Ron >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > 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: Mercadante, Thomas F 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: Farnsworth, Dave 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: Farnsworth, Dave 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).
RE: Rename alert log
I am running 8.1.7 and just last week renamed my alert.log while the database was up and everything seemed to work fine. It created a new alert log on the fly. Dave -Original Message- Sent: Tuesday, July 10, 2001 1:01 PM To: Multiple recipients of list ORACLE-L In 816 on NT, you can rename it any time you want. is this changing in 817 Rachel? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 10, 2001 1:27 PM To: Multiple recipients of list ORACLE-L depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it. In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, similar to the way it handles the listener log file. So you will need to do the same sort of tricks to the alert log as you have to do to the listener log (make a copy then copy /dev/null to the original) >From: "Smith, Ron L." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Rename alert log >Date: Tue, 10 Jul 2001 06:56:31 -0800 > >Can the alert log be renamed while the database is up and running? > >Ron >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > 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: Mercadante, Thomas F 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: Farnsworth, Dave 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).
RE: Rename alert log
Hmmm...in Oracle 7.3.4,, 7.3.5, 8.0.5, 8.0.6, 8.1.6, and 8.1.7 on HP/UX 10.20/11.0, a rename of the alert log causes a new one to be created with the next message. My "AlertLogChecker" renames the alert log if it finds an error in there. As I'm attempting to size partitions for a non-partitioned table, I can tell you the rename of the alert log works very well (I've got 20+ renamed logs in my test DB's bdump dir)! :) OTOH, most, if not all versions of Oracle on OpenVMS *will* keep open the alert log (and the udump trace/log files) like you describe. Just the nature of I/O on OpenVMS, probably due to it's superior file handling and lack of OpenVMS experience on Oracle's OpenVMS porting (look at the DCL they've created). :D Rich Jesse System/Database Administrator, OpenVMS bigot [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, July 10, 2001 12:27 To: Multiple recipients of list ORACLE-L depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it. In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, similar to the way it handles the listener log file. So you will need to do the same sort of tricks to the alert log as you have to do to the listener log (make a copy then copy /dev/null to the original) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
RE: Rename alert log
dunno about NT, I do know that it changed on Unix.. as per a thread here in the not too distant past. I believe Anita had posted something on it.. and that it WAS a change from prior versions. I am an Oracle on NT ignoramus :) >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Rename alert log >Date: Tue, 10 Jul 2001 10:00:34 -0800 > >In 816 on NT, you can rename it any time you want. > >is this changing in 817 Rachel? > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Tuesday, July 10, 2001 1:27 PM >To: Multiple recipients of list ORACLE-L > > >depends on the version of the database you are running.. it used to be that >yes, you could just rename it and Oracle would open a new one of the >original name when it needed to write to it. > >In 8.? and above, you can no longer just rename it, Oracle now maintains an >open file pointer to it, similar to the way it handles the listener log >file. So you will need to do the same sort of tricks to the alert log as >you > >have to do to the listener log (make a copy then copy /dev/null to the >original) > > > > >From: "Smith, Ron L." <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Rename alert log > >Date: Tue, 10 Jul 2001 06:56:31 -0800 > > > >Can the alert log be renamed while the database is up and running? > > > >Ron > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Smith, Ron L. > > 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: Mercadante, Thomas F > 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).
RE: Rename alert log
In 816 on NT, you can rename it any time you want. is this changing in 817 Rachel? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 10, 2001 1:27 PM To: Multiple recipients of list ORACLE-L depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it. In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, similar to the way it handles the listener log file. So you will need to do the same sort of tricks to the alert log as you have to do to the listener log (make a copy then copy /dev/null to the original) >From: "Smith, Ron L." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Rename alert log >Date: Tue, 10 Jul 2001 06:56:31 -0800 > >Can the alert log be renamed while the database is up and running? > >Ron >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > 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: Mercadante, Thomas F 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).
RE: Rename alert log
Ron: If you mean, "Can the alert log be renamed for archiving purposes while the db is up?" the answer is yes. Oracle will just recreate the alert log the next time it needs to write an entry to it. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: "Smith, Ron L." <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/10/01 10:56:31 AM > >Can the alert log be renamed while the database is up and running? > >Ron >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > 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: Jon Walthour 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).
RE: Rename alert log
Yes. Rename delete trimmedetc. -Original Message- Sent: Tuesday, July 10, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Kevin Lange 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).
RE: Rename alert log
Yes, it can. Just rename it and there will be new one created with an old name at some point. -Original Message- Sent: Tuesday, July 10, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: 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).
RE: Rename alert log
Yes -Original Message- Sent: Tuesday, July 10, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Farnsworth, Dave 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).
Re: Rename alert log
depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it. In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, similar to the way it handles the listener log file. So you will need to do the same sort of tricks to the alert log as you have to do to the listener log (make a copy then copy /dev/null to the original) >From: "Smith, Ron L." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Rename alert log >Date: Tue, 10 Jul 2001 06:56:31 -0800 > >Can the alert log be renamed while the database is up and running? > >Ron >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > 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).
RE: Rename alert log
Ron: Yep. Do it every night at midnight. But...you can't just rename it! If you do a command like... mv alert_SID.log alert_SID_010710.log touch alert_SID.log ...Oracle will still append new entries to the old file, and your new alert_SID.log file will continue to have 0 bytes. What you need to do is... cp -p alert_SID.log alert_SID_010710.log > alert_SID.log ...This copies the file while maintaining the timestamp, and then nulls out the existing file. This should work on most flavors of UNIX. HTH, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -Original Message- Sent: Tuesday, July 10, 2001 7:57 AM To: Multiple recipients of list ORACLE-L Can the alert log be renamed while the database is up and running? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).
