Re: How force a log switch in 8i

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Fri, 14 Aug 2009 00:57:59 -0700 (PDT)
Message-ID: <58598135-ac62-4700-b6bd-4ced959b99ab_at_w6g2000yqw.googlegroups.com>



On Aug 14, 11:38 am, "Fabrice" <emouc..._at_spaminfonietest.fr> wrote:
> Hello,
>
> I have an Oracle Database under 8i (8.1.7) and also a standby in the same
> version.
> I would like to minimize the difference beetwen the two.
>
> My question is about archived log. The activity of my base is very
> fluctuating. Sometimes as now I don't have enough activities to trigger the
> arch process regularly and this for many hours.
> And in anothers days the activity is "normal" and I get the arch process
> regularly.
>
> I would like a better control of this process. For example to generate an
> archived log every 15 minutes  by forcing a log switch .
>
> >> To limit the amount of data that can be lost and increases the
> >> availability of the standby database.
>
> But I don't how to do that with Oracle 8i. Does it exist a parameter like
> "ARCHIVE_LAG_TARGET" in the 9i.
> Do I have to create a system job which is going to force the swith.
> But in this case what happen  if my job force a switch when oracle trigger
> in the same moment an arch process ?
>
> Thanks for your help.
> Fabrice

ARCHIVE_LAG_TARGET was introduced in 9i, so your only option is to schedule a job with ALTER SYSTEM SWITCH LOGFILE. Situation when your job runs at the very same moment automatic log file switch occurs is almost impossible. Log file switch is serialized, so even if this happens, you will end up with two switches and very small archived log from the second switch.

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Fri Aug 14 2009 - 02:57:59 CDT

Original text of this message