RE: Need script to copy and then truncate/tail alert log

From: Veronica Levin <vlevin_at_victoria.com.ni>
Date: Thu, 27 Jul 2000 08:49:20 -0600
Message-Id: <10571.113126@fatcity.com>

Hi Ruth,

Can I do this while database is up and running???

Is this valid for the tcp_listener.log?

Both are huge already and I have been trying to reduce it size with no success.

Thanks in advance!

Saludos,

Ver=F3nica Levin Enr=EDquez
Administrador AIX
Compa=F1=EDa Cervecera de Nicaragua
Tel=E9fono: 505-2493779
Fax: 505-2443979
Email: vlevin_at_victoria.com.ni=20
http://www.victoria.com.ni

-----Mensaje original-----
De: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Enviado el: Mi=E9rcoles 26 de Julio de 2000 10:36 AM Para: Multiple recipients of list ORACLE-L Asunto: Re: Need script to copy and then truncate/tail alert log

You can use the OS cp and rm commands if it's UNIX. cp the alert log = to a
new place or name and the rm it. You can use the copy, and rename functions on NT too. Tail simply gives you the last rows of the table. =  You
don't need to truncate it because it will recreate itself as necessary.

HTH,
Ruth
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 26, 2000 11:40 AM

> Does anyone have a script that will copy over and then truncate or =
tail (I
can't
> remember if it's tail)
> the alert log? Or something appropriate to keep our alert log to a =
day's
worth
> of log information while
> keeping the file in the same directory (hopefully with a datestamp in =
the
old
> log file name). Then we
> want to clean out the old log files on a weekly or daily basis.
>
> Thanks in advance for any help.
>
> Cherie
>
>
> --
> Author:
> INET: Cherie_Machler_at_gelco.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).
>

--=20
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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 Received on Thu Jul 27 2000 - 09:49:20 CDT