Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: archive logs

Re: archive logs

From: shinobi <Shinobi59_at_gmail.com>
Date: 12 Jan 2007 10:09:38 -0800
Message-ID: <1168625378.720339.310060@51g2000cwl.googlegroups.com>

shinobi wrote:
> shinobi wrote:
> > 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?

>

> No dba avail. Small shop / job. I am trying to get to some 10G
> training. Anyone have a suggestion as to the best single course that
> will cover a lot of oracle ground?

I have also used find and locate to try to find files ending in .arc and not finding a match. Received on Fri Jan 12 2007 - 12:09:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US