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/，如需轉載，請註明出處，否則將追究法律責任。