Re: Archiver error without archive log mode

Because as long as there's redo in an online log that's potentially still required for instance recovery after a crash, Oracle won't let it get overwritten.

Try decreasing that value, or increase the number ( and possibly size ) of your online redo logs.

Stefan

On Fri, Aug 22, 2008 at 11:12 AM, Martin Klier <usn_at_usn-it.de> wrote:

> Hi Stefan,
>
> it's set to 900.
>
> Why?
>
> Thanks
> Martin
>
> Stefan Knecht schrieb:
> > Hi Martin
> >
> > What's your fast_start_mttr_target set to ?
> >
> > Stefan
> >
> > On Fri, Aug 22, 2008 at 10:50 AM, Martin Klier <usn_at_usn-it.de
> > <mailto:usn_at_usn-it.de>> wrote:
> >
> > Thanks for the replies,
> >
> > but db_recovery_file_dest is empty ('') and
> db_recovery_file_dest_size
> > is zero. (0)
> >
> > Anyway, I still can't imagine how this should become important -
> there's
> > simply nothing the database should write into the FRA in
> > NOARCHIVELOG mode.
> >
> > Thanks
> > Martin
> >
> > Rajeev Prabhakar schrieb:
> > > Hi Martin,
> > >
> > > Did you check your FRA / db_recovery_file_dest_size ?
> > > May be, it is getting full ?
> > >
> > > -Rajeev
> > >
> > > On Thu, Aug 21, 2008 at 12:29 PM, Martin Klier <usn_at_usn-it.de
> > <mailto:usn_at_usn-it.de>> wrote:
> > >> Dear list,
> > >>
> > >> A question - maybe I am just silly, but I can't explain how that
> > comes:
> > >> One of my 10gR2 Databases is in NORACHIVELOG mode. (v$database
> > log_mode
> > >> is NOARCHIVELOG).
> > >>
> > >
> >
> > --
> > Usn's IT Blog for Linux, Oracle, Asterisk
> > http://www.usn-it.de
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> >
> >
> > --
> > =========================
> >
> > Stefan P Knecht
> > Senior Consultant
> > Infrastructure Managed Services
> >
> > Trivadis AG
> > Europa-Strasse 5
> > CH-8152 Glattbrugg
> >
> > Phone +41-44-808 70 20
> > Fax +41-808 70 12
> > Mobile +41-79-571 36 27
> > stefan.knecht_at_trivadis.com <mailto:stefan.knecht_at_trivadis.com>
> > http://www.trivadis.com
> >
> > OCP 9i/10g SCSA SCNA
> > =========================
>
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> http://www.usn-it.de
>
>

-- 
=========================

Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

--
http://www.freelists.org/webpage/oracle-l