Re: log file purge

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 10 Nov 2001 16:12:51 +0100
Message-ID: <tuqhjasom52762@corp.supernews.com>

select * from v$database
or
archive log list

The logfiles itself are in the directory pointed to by the log_archive_dest parameter.

This is _very_ basic knowledge, please read the Oracle Server Administrators manual, where it is discussed in detail.

Hth,

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

"ed zappulla" <zappullae_at_rcn.com> wrote in message
news:9sjdrc$a0f$1_at_bob.news.rcn.net...


> Thanks.  I don;t thing the archive log is set.  How do I tell?   Where are

> the log files?

>

>

> "Alex Ivascu" <alex_at_ivascu.com> wrote in message

> news:mA3H7.82973$xe.20794955_at_typhoon.we.rr.com...

> > If you've enabled Archivelog mode, then you definitely have to purge the

> > Redo Logs on a regular basis ---

> >

> > Alex

> >

> >

> > "ed zappulla" <zappullae_at_rcn.com> wrote in message

> > news:9sh1sb$kgs$1_at_bob.news.rcn.net...

> > > are there any log files that need to be periodicly purged from 8.1.6?

> > >

> > >

> > >

> >

> >

>

>

Received on Sat Nov 10 2001 - 09:12:51 CST