Don't "rm" it! If Oracle is writing to the file, it may complain since =
the
i-node changes when a new file is created. The better alternative is =
to do
cp alert_instance.log alert_instance.log.save
cat /dev/null > alert_instance.log
This will empty the file, but not change it's i-node number. This =
command
will also work if oracle is writing to the file. The only caveat here =
is
that you will miss any messages that occur between the two commands.
> -----Original Message-----
> From: Veronica Levin [SMTP:vlevin_at_victoria.com.ni]
> Sent: Thursday, July 27, 2000 10:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Need script to copy and then truncate/tail alert log
>=20
> Hi Ruth,
>=20
> Can I do this while database is up and running???
>=20
> Is this valid for the tcp_listener.log?
>=20
> Both are huge already and I have been trying to reduce it size with =
no
> success.
>=20
> Thanks in advance!
>=20
> Saludos,
>=20
> 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
>=20
>=20
>=20
>=20
>=20
> -----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
>=20
>=20
> 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.
>=20
> HTH,
> Ruth
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, July 26, 2000 11:40 AM
>=20
>=20
> > 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
> --=20
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>=20
> 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: Veronica Levin
> INET: vlevin_at_victoria.com.ni
>=20
> 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 - 15:39:10 CDT
