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

今天在为一个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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/758322/viewspace-693727/