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 <carmichr_at_hotmail.com> 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"
> <DFarnsworth_at_Ashleyfurniture.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: 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." <rlsmith_at_kmg.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> > >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: abardeen1_at_yahoo.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 - 08:46:45 CDT