RE: Renaming / deleting listener.log and alert log

Jerome.

What? I disagree. We do this *all* the time with no problems at all. I'm not sure what you are looking at. We mv the alert log every night on all of our databases - both on NT and on both Sun unix and IBM aix. Never had a problem.

Tom
=20
-----Original Message-----
From: Vitalis Jerome [mailto:vitalisman_at_gmail.com]=20 Sent: Friday, June 10, 2005 8:35 AM
To: Mercadante, Thomas F (LABOR)
Cc: Paul.Vincent_at_uce.ac.uk; oracle-l_at_freelists.org Subject: Re: Renaming / deleting listener.log and alert log

On 6/10/05, Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us> wrote:
> Paul,

>=20
> It is absolutely ok to rename the alert.log while the database is up
and
> running. I do it all the time. =20
> This file is not open all the time - Oracle opens and closes it as it
needs to write to it.

On Unix, the second statement is not true (checked on Aix and Linux). And the first one is not completely wrong but it is not clean to "mv" a file which is still open by a process.

Cheers
Jerome

--
http://www.freelists.org/webpage/oracle-l