Re: archive logs

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? Received on Fri Jan 12 2007 - 11:57:14 CST