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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Archiving of Redo Logs Growing Tremendously

Re: Archiving of Redo Logs Growing Tremendously

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 24 Oct 2002 11:18:39 +0100
Message-ID: <3db7c8ff$0$8512$ed9e5944@reading.news.pipex.net>


Has anything changed in the application in this period of time?

The other thing to check is if any of your tablespaces are stuck in backup mode following a failed backup.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Eileen Ong" <eileenong_at_msn.com> wrote in message
news:ap720n$ofk$1_at_reader01.singnet.com.sg...

> Hi,
>
> We have a production database, running 8.1.7.3. A few days ago, we noticed
> that the archiving of redo logs started growing at a rate of about 1 to 4
> per minute! This is happening even when the server load is very low.
> Normally, even on busy days, the server gets about 10 logs. Now, our
archive
> log directory keeps hitting 100% full.
>
> There has been no changes on the server parameters for almost 3 months,
> since our database migration. Everything has been running very smoothly
> until now.
>
> Has anyone encountered such a problem before?
>
> Thanks in advance!
>
> Cheers
> Eileen
>
>
Received on Thu Oct 24 2002 - 05:18:39 CDT

Original text of this message

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