No, but this is close...
"ARCHIVE_LAG_TARGET
ARCHIVE_LAG_TARGET limits the amount of data that can
be lost and effectively increases the availability of
the standby database by forcing a log switch after a
user-specified time period elapses.
A 0 value disables the time-based thread advance
feature; otherwise, the value represents the number of
seconds. Values larger than 7200 seconds are not of
much use in maintaining a reasonable lag in the
standby database. The typical, or recommended value is
1800 (30 minutes). Extremely low values can result in
frequent log switches, which could degrade
performance; such values can also make the archiver
process too busy to archive the continuously generated
logs."
- Tim Gorman <Tim_at_SageLogix.com> wrote: > Oracle9i
hasn't introduced such a parameter; the
> best way to achieve what
> you want below 9i is to resize redo logs to be
> smaller (which several
> replies have already mentioned)...
>
> With 9i Data Guard, you have options where you can
> set LGWR to ship redo log
> files to the standby, and there is even a mode where
> redo records
> (especially COMMIT markers) must be shipped and
> applied to the standby
> before LGWR considers a COMMIT on the primary to be
> complete. In all, there
> are four basic options with 9i Data Guard:
>
> * LGWR synchronously ships redo records to
> standby and standby applies
> redo before transaction considered complete
> * LGWR ships redo records to standby before
> transaction considered
> complete (standby can apply records at a later time)
> * ARCH ships redo log files to standby and
> standby applies redo
> immediately
> * ARCH ships redo log files to standby and
> standby applies redo at a
> later time
>
> The first two options come only with 9i Data Guard
> in 9i EE; the third
> option came available with 8i EE (i.e. automated
> standby management), and
> the fourth option has been around (unofficially)
> since Oracle v6 and
> officially as a supported product since v7.3 (i.e.
> original standby database
> option) and is still the only option for 8i/9i SE...
>
> As you can imagine, there are obvious advantages and
> disadvantages in cost,
> performance, availability, and complexity to each
> mode. But one cool thing
> about the first option is that 9i Data Guard can
> "switch identities" of the
> primary and standby (i.e. swap standby into primary
> role and primary into
> standby role) almost instantaneously using the ALTER
> DATABASE SWITCH
> IDENTITY commands. It's another way of achieving
> the same high-availability
> goals as RAC/OPS in an "active/passive" arrangement.
>
> In this sense, the 9i Data Guard product is very
> much in competition with
> the 9iRAC product. It will be interesting to see
> how this competition plays
> out, both within Oracle as well as amongst
> customers...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Sunday, August 18, 2002 9:43 AM
>
>
> >
> > I am not sure if 9i has introduced any such
> parameter.
> > Other than sizing smaller redo log files [but that
> still doesn't guarantee
> > that you get a log-switch every X minutes], you'd
> have to write
> > a DBMS_JOB or a CRON job to do an ALTER SYSTEM
> SWITCH LOGFILE.
> >
> > Hemant
> > At 06:08 AM 18-08-02 -0800, you wrote:
> > >Dear gurus !
> > >It's either a Sunday's dead brain or ......
> > >Is there an init.ora parameter to force redo logs
> switch every 3 minutes
> or
> > >so ?
> > >( the reason is that I need frequent log switches
> in order for the
> standby
> > >database to pickup changes frequently , i.e. to
> be "almost" in sync with
> the
> > >primary DB. And, off course, issuing "alter
> system switch logfile" in the
> > >application is not feasible )
> > >Now, i only found parameters related to the
> frequency of the CHECKPOINTs
> and
> > >not log switches.
> > >Any help , please ...
> > >
> > >
> > >DBAndrey
> > >
> > >* 03-9254520
> > >* 058-548133
> > >* mailto:andreyb_at_elrontelesoft.com
> > >
> > >
> > >
> > >
> > >--
> > >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > >--
> > >Author: Andrey Bronfin
> > > INET: andreyb_at_elrontelesoft.com
> > >
> > >Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > >San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
>--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send
> an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > >the message BODY, include a line containing:
> UNSUB ORACLE-L
> > >(or the name of mailing list you want to be
> removed from). You may
> > >also send the HELP command for other information
> (like subscribing).
> >
> > Hemant K Chitale
> > Now using Eudora Email. Try it !
> >
> > My home page is : http://hkchital.tripod.com
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Hemant K Chitale
> > INET: hkchital_at_singnet.com.sg
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tim Gorman
> INET: Tim_at_SageLogix.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Aug 19 2002 - 05:23:26 CDT