所有进程空闲时，logical dataguard 竟然延时

所有进程空闲时，逻辑库竟然延时

select * from v$logstdby_process
 
           2  ;
 
       SID    SERIAL# LOGSTDBY_ID SPID         TYPE                           STATUS_CODE STATUS                                                                             HIGH_SCN
---------- ---------- ----------- ------------ ------------------------------ ----------- -------------------------------------------------------------------------------- ----------
       311      19461          -1 26262        COORDINATOR                          16116 ORA-16116: no work available                                                     2870648305
       332      38062           0 30445        READER                               16116 ORA-16116: no work available                                                     2870648305
       371       8621           1 30447        BUILDER                              16116 ORA-16116: no work available                                                     2870648305
       360      63186           2 30449        PREPARER                             16116 ORA-16116: no work available                                                     2870648305
       544      58447           3 30451        ANALYZER                             16116 ORA-16116: no work available                                                     2870648305
       364      35105           4 30453        APPLIER                              16116 ORA-16116: no work available                                                     2870648304
       484       4127           5 30455        APPLIER                              16116 ORA-16116: no work available                                                     2870648305
       425      27019           6 30457        APPLIER                              16116 ORA-16116: no work available                                                     2870648304
       434       8174           7 30459        APPLIER                              16116 ORA-16116: no work available                                                     2870648302
       511        132           8 30461        APPLIER                              16116 ORA-16116: no work available                                                     2870648304
 

 

逻辑库的时间

select * from v$Logstdby_progress

apply_time 总是延迟4分钟左右。

最后一查。原来是主库的时间有问题。没有和时间服务器同步，慢了4分钟。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8135069/viewspace-686958/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8135069/viewspace-686958/