Re: archive logs

From: shinobi <Shinobi59_at_gmail.com>
Date: 12 Jan 2007 09:50:19 -0800
Message-ID: <1168624218.081169.229760@q2g2000cwa.googlegroups.com>

gazzag wrote:
> 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

Here is what I see for the destination:

log_archive_dest                     string
log_archive_dest_1                   string      location="+DISK10G",

valid_for

=(ONLINE_LOGFILE,ALL_ROLES) location is not a UNIX path.

Can you translate? Received on Fri Jan 12 2007 - 11:50:19 CST