Re: archive logs

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, but check out Oracle By Example and Dizwell --> Basics (see http://www.dbaoracle.net/readme-cdos.htm#subj10 )

I agree with the other posters, you need a real DBA in there to get you going, unless you have completely worthless data.

jg

--
@home.com is bogus.
Those darn whitehats!  http://www.phenoelit.net/lablog/Irresponsible.sl