ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rac的系统时间与物理备库lag

rac的系统时间与物理备库lag

原创 Linux操作系统 作者:aaqwsh 时间:2011-04-26 12:16:32 0 删除 编辑

今天在为一个rac建一个物理备库的时候,发现日志都应用了,但就是有lag:

[oracle@testdb2 ~]$

NAME                           VALUE                UNIT                           TIME_COMPUTED
------------------------------ -------------------- ------------------------------ ------------------------------
apply finish time              +00 00:00:00.9       day(2) to second(1) interval   26-APR-2011 10:34:10
apply lag                      +00 11:58:29         day(2) to second(0) interval   26-APR-2011 10:34:10
estimated startup time         15                   second                         26-APR-2011 10:34:10
standby has been open          N                                                   26-APR-2011 10:34:10
transport lag                  +00 11:58:17         day(2) to second(0) interval   26-APR-2011 10:34:10

[oracle@testdb2 ~]$

NAME                           VALUE                UNIT                           TIME_COMPUTED
------------------------------ -------------------- ------------------------------ ------------------------------
apply finish time              +00 00:00:01.0       day(2) to second(1) interval   26-APR-2011 10:34:44
apply lag                      +00 11:58:53         day(2) to second(0) interval   26-APR-2011 10:34:44
estimated startup time         15                   second                         26-APR-2011 10:34:44
standby has been open          N                                                   26-APR-2011 10:34:44
transport lag                  +00 11:58:41         day(2) to second(0) interval   26-APR-2011 10:34:44

[oracle@testdb2 ~]$

NAME                           VALUE                UNIT                           TIME_COMPUTED
------------------------------ -------------------- ------------------------------ ------------------------------
apply finish time              +00 00:00:00.9       day(2) to second(1) interval   26-APR-2011 10:35:10
apply lag                      +00 11:58:29         day(2) to second(0) interval   26-APR-2011 10:35:10
estimated startup time         15                   second                         26-APR-2011 10:35:10
standby has been open          N                                                   26-APR-2011 10:35:10
transport lag                  +00 11:58:17         day(2) to second(0) interval   26-APR-2011 10:35:10

百思不得其解,折腾了好一阵子,发现两个节点的时间竟然不一样,差了差不多12个小时:
oracle@rac1 dbs]$ date
Tue Apr 26 10:24:24 CST 2011
[oracle@rac1 dbs]$ date
Tue Apr 26 10:27:45 CST 2011
[oracle@rac1 dbs]$ date
Tue Apr 26 10:28:18 CST 2011

[root@rac2 ~]# date
Mon Apr 25 22:25:48 CST 2011

在节点2停掉数据库,然后修改系统时间,物理备库应用正常:

[root@rac2 ~]# date -s 04/26/2011
Tue Apr 26 00:00:00 CST 2011
[root@rac2 ~]# date -s 10:28:10
Tue Apr 26 10:28:10 CST 2011
[root@rac2 ~]# clock -w

 


NAME                           VALUE                UNIT                           TIME_COMPUTED
------------------------------ -------------------- ------------------------------ ------------------------------
apply finish time              +00 00:00:00.3       day(2) to second(1) interval   26-APR-2011 10:40:47
apply lag                      +00 00:00:13         day(2) to second(0) interval   26-APR-2011 10:40:47
estimated startup time         15                   second                         26-APR-2011 10:40:47
standby has been open          N                                                   26-APR-2011 10:40:47
transport lag                  +00 00:00:00         day(2) to second(0) interval   26-APR-2011 10:40:47

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

上一篇: 事物的基本流程
请登录后发表评论 登录
全部评论

注册时间:2010-11-24

  • 博文量
    132
  • 访问量
    262257