Are you working with archive log? I saw this behavior when there was a problem in writing to an archive log and the arch process stopped.
I think that instead of renaming you should copy the file and then deleting all lines from it. Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 3:59 PM > > Hi, > > > On one of our customers site (WINDOWS) we have databases that have alertlogs > with the name <sid>ALRT.LOG<sid>ALRT.LOG (double the normal name) and oracle > keeps on writing to it. > I thought if a file is renamed oracle will create a new alertlog when > needed. I have a php script that reads the alrtlogs and reports the errors > in web browser and than renames the current alertlog to > <sid>ALRT.LOG.yyyymmdd > Can it be that when there is writing action in the file oracle will get > confused and screw up the renaming bit? (I thought windows did not allow > changing filenames of open files) > > One of the databases on this customers site every now and than hangs with no > messages in the alert logs and does not allow any connections anymore(No > errors reported back to client). This database needs to be up and running > asap so when it happens we don't get much time to investigate and restart > the service. We can still connect with svrmgrl and internal (wasn't this > supposed to go in 8.1.7). What would be the best course of action to quickly > gather the releavnt data next time this happens. > Has anybody seen this before and knows the solution? > > W2K > Oracle 8.1.7.0.0 EE > > Jacob A. van Zanen > Oracle DBA > Quant Systems Europe b.v. > Tel : +31 (0) 251 - 268 268 > Mobile: +31 (0) 6 51308813 > Fax: +31 (0) 251 - 268 269 > E-mail: mailto:[EMAIL PROTECTED] > Visit our web site at http://www.quantsystems.nl/ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jack van Zanen > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
