环境:主库RAC,备库:单节点
版本:11.2.0.3
问题:备库有延迟。
SQL> select * from v$dataguard_stats;
NAME VALUE UNIT TIME_COMPUTED DATUM_TIME
-------------------------------- ---------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------
transport lag +00 04:15:06 day(2) to second(0) interval 10/21/2013 23:05:09 10/21/2013 23:03:46
apply lag +00 04:15:06 day(2) to second(0) interval 10/21/2013 23:05:09 10/21/2013 23:03:46
apply finish time +00 00:01:17