| 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: Alert log
Use tail -(number of records)alert.log > somefile.oldalertmmddyyy.log.
This will copy all of the records you specify into your archive file. You
can also get the MKS Toolkit and use TAIL in Windows.
Hope this helps.
Frank Pettinato
Oracle DBA
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
achoto_at_american.edu
Sent: Wednesday, August 23, 2000 6:58 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Alert log
Thank you. I use tail -n alert<dbname>.log to look at the latest entries. But, I'd like to save our current log under a different name and start a new one.
I have one more question though: Is there a reason why errors related to rollback segments such as the 'snapshot too old' message don't get written to the alert log? I used to see this message when it happened, but about a month ago I don't see them anymore. And I know there were a few times in which a transaction aborted with this message, but it wasn't in the log.
Ana
"K
Gopalakrishna To: Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>
n" cc:
<kaygopal_at_yah Subject: Re: Alert log
oo.com>
Sent by:
root_at_fatcity.
com
08/23/00
05:01 AM
Please
respond to
ORACLE-L
Hi !
Oracle will simply create a new file
and start writing in to it. But this is not the
case with Trace files.
This can be done even when the DB is running. Alternatively you can use tail (-f) command to see the latest entries in the alert log if you are in Unix
Regards,
K Gopalakrishnan,
Bangalore, INDIA.
> If I rename the alert log, will Oracle create a new one if it doesn' find
> it? I think our alert log has grown too large.
>
> Thanks
>
> Ana E. Choto
> Systems Programmer
> American University
> Office of Information Technology
> Phone (202) 885-2275
> Fax (202) 885-2224
>
> --
> Author:
> INET: achoto_at_american.edu
>
> 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).
-- Author: K Gopalakrishnan INET: kaygopal_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). -- Author: INET: achoto_at_american.edu 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 mayReceived on Wed Aug 23 2000 - 08:36:53 CDT
 |
 |