How can one fix the lag between primary and standby growing ?
Hello community,
May I please ask how I can reduce the lag between my primary and standby ,or at least stop it growing?
QL> SELECT * FROM v$dataguard_stats;
NAME VALUE UNIT TIME_COMPUTED
---------------------------------------------------------------- ---------------------------------------------------------------- ------------------------------ ------------------------------
apply finish time day(2) to second(3) interval 18-JUN-2015 22:16:59
apply lag +14 02:41:56 day(2) to second(0) interval 18-JUN-2015 22:16:59
estimated startup time 112 second 18-JUN-2015 22:16:59
standby has been open Y 18-JUN-2015 22:16:59
transport lag +14 01:45:45 day(2) to second(0) interval 18-JUN-2015 22:16:59
two days later:
ON dg:
SQL> SELECT * FROM v$dataguard_stats;
NAME--------------------------------------------------------------VALUE----------------------------------------------------------------UNIT TIME_COMPUTED
------------------------------ ------------------------------
apply finish time day(2) to second(3) interval 18-JUN-2015 22:16:59
apply lag +14 03:58:06 day(2) to second(0) interval 18-JUN-2015 22:16:59