ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 所有进程空闲时,logical dataguard 竟然延时

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

原创 Linux操作系统 作者:lijiebin 时间:2011-02-10 14:11:01 0 删除 编辑

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

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-10

  • 博文量
    145
  • 访问量
    150241