Re: fast_start_mttr_target value is ignored

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 19 Jun 2004 13:24:48 +1000
Message-ID: <40d3b1e6$0$18195$afc38c87@news.optusnet.com.au>

"Jack" <admin_at_stirlingonline.com> wrote in message news:7a80a637.0406181832.70a8fb99_at_posting.google.com...
> > OK. Now: do you have FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL set
in
> > your init.ora?
> >
> > Get rid of them if so, bounce your instance, and then report back.
>
>
> They are not set. See below.
>
> SQL> show parameter log_checkpoint
>
> NAME TYPE VALUE
> ------------------------------------ ----------- -------------------------

---

> log_checkpoint_interval integer 0
> log_checkpoint_timeout integer 1800
> log_checkpoints_to_alert boolean FALSE
> SQL> show parameter fast_start
>
> NAME TYPE VALUE
> ------------------------------------ ----------- -------------------------

---

> fast_start_io_target integer 0
> fast_start_mttr_target integer 0
> fast_start_parallel_rollback string LOW

OK... we can but eliminate things one step at a time!

Are you certain you are starting up with the correct init.ora? The one that you know for certain has a fast_start_mttr_target set? I have edited the wrong init.ora many times in the past :-(

Force the issue with startup pfile=/path and/name of/init.ora

Regards
HJR Received on Fri Jun 18 2004 - 22:24:48 CDT