Lag Limti parameter purpose for FSFO in a Data Guard environment
edited Feb 15, 2013 10:29AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
I have a Data Guard environment with FSFO configured and an Observer running like below. 11.2.0.3..0
I am trying to confirm if the lag limit would prevent my Primary database from failing over if there was nothing wrong with it under a heavy load and then got behind more than 30 seconds and then the primary really did crash.
If more than 30 seconds, it appears it would not Failover to my Physical Standby.
The parameter seems to say it would prevent a failover if more than 30 seconds of data would be lost.
The
I am trying to confirm if the lag limit would prevent my Primary database from failing over if there was nothing wrong with it under a heavy load and then got behind more than 30 seconds and then the primary really did crash.
If more than 30 seconds, it appears it would not Failover to my Physical Standby.
The parameter seems to say it would prevent a failover if more than 30 seconds of data would be lost.
The
FastStartFailoverLagLimit configuration property establishes
an acceptable limit, in seconds, that the standby is allowed to fall behind the
primary in terms of redo applied, beyond which a fast-start failover will not be
allowed. The lowest possible value is 10 seconds. 0