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
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