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 In
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
OTECTED]
>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
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
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 off
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
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 --
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 P
CTED]>
>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?
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
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]>
>Subjec
)
>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
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
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 PROTECTE
ltiple 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>--&g
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.co
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 logfil
ist 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.
>
&g
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
Solari
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...
MAIL 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
>
-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
ultiple 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
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]>
>S
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
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 fo
26 matches
Mail list logo