Re: archive logs

From: gazzag <gareth_at_jamms.org>
Date: 12 Jan 2007 09:31:01 -0800
Message-ID: <1168623058.128189.155700@q2g2000cwa.googlegroups.com>

shinobi wrote:
> Ok. I'm not a dba but I am being asked to take care of this. How do I
> delete archive logs. Is there a file extension I can search for? This
> is on a Red Hat Enterprise Linux system. Would this be one of the
> files ending in .trc?
>
> Thanks
>
> -shinobi

Type the following command in a SQL*Plus session:

SQL> show parameter log_archive_dest

This will show you where your logs are being archived to. They will have a file extension of ".arc".

At the O/S level, find this directory and delete some of the older archives to create more space. If possible, especially as you're not the DBA, *move* (rather than delete) these files to a safe location so that you can recover them if required.

HTH -g Received on Fri Jan 12 2007 - 11:31:01 CST