奇怪的日志应用推迟问题(2010-09-27)

因为百度收录的问题,需要推迟一个逻辑从库的日志应用,我在主库端设置的是推迟4天:
SQL> show parameter log_archive_dest_3

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_3                   string      SERVICE=mspdb_logic_standby lg
                                                 wr async VALID_FOR=(ONLINE_LOG
                                                 FILES,PRIMARY_ROLE) delay=5760

SQL> select dest_name,delay_mins from v$archive_dest where dest_id=3;

DEST_NAME             DELAY_MINS
-------------------------------------------------
LOG_ARCHIVE_DEST_3     5760

确实是推迟了4天呀!

可逻辑从库端:

SQL> select realtime_apply,state from v$logstdby_state;

REALTIME_APPLY                STATE
----------------------------------------------------------------
N                             APPLYING

没有开启实时应用

SQL> select applied_time,latest_time from v$logstdby_progress;

APPLIED_TIME        LATEST_TIME
------------------- -------------------
2010-09-24 03:50:18 2010-09-27 11:54:02

SQL> select applied_time,latest_time from v$logstdby_progress;

APPLIED_TIME        LATEST_TIME
------------------- -------------------
2010-09-24 03:50:43 2010-09-27 11:54:19

SQL> select applied_time,latest_time from v$logstdby_progress;

APPLIED_TIME        LATEST_TIME
------------------- -------------------
2010-09-24 03:50:57 2010-09-27 11:54:38

确实是在不断的应用日志,查询v$logstdby_process也可以看到的,可推迟时间只有3天8个小时,而不是我设置的4天呀?

有一定的时间差是可以理解的,之前设置推迟2天的时候,基本上就是2天稍微多一些,但现在差别也太大了吧!

其实后来我设置应用推迟7天的时候,发现有时候只推迟了1天多点儿.