Re: Question about log purging

Look in your init<SID>.ora parameter file for BACKGROUND_DUMP_DEST and USER_DUMP_DEST. These directories collect files that NEVER go away until you delete them. In particular, the alert.log will fill the file system and stop the database.

masint_at_istar.ca wrote:
>
> In article <3421662A.2AE6_at_netvigator.com>,
> Morris Wong <morriswg_at_netvigator.com> wrote:
> >
> > Hi all,
> >
> > I am using Oracle version 7.2.3 for Solaris. A plan of log
> > purging is needed. Where can i find a complete list of
> > log file/directory which need to be purged periodically?
> > Thank you!
> >
> > Morris
> > morriswg_at_netvigator.com
>
> First of all, it depends if you are running in ARCHIVELOG mode. If you
> are not, there is no log purging to be done. If you are, look at the
> value for LOG_ARCHIVE_DEST in your INIT.ORA and that is where Oracle
> writes archived redo logs.
>
> Michael
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
 

-- 
John P. Higgins      Voice:    (309)765-7868
Deere & Company      Fax:      (309)765-7800
John Deere Road      Internet: jh33378nospam_at_deere.com
Moline, IL 61265     Opinions: My Own