oracle RAC環境如何調整系統時間

對於RAC環境而言，調整系統時間不是一件小事情，Oracle為了保證節點之間的一致性，很可能會重啟其中一個節點。

測試發現，如果將系統時間向前調整，那麼無論調整多長的時間都不會造成系統的重啟。但是如果將系統時間向後調整，就會造成整個節點的重啟。

即使是關閉資料庫，調整時間仍然會重啟節點。

正確的方法是首先關閉資料庫和CLUSTER環境，然後修改系統時間，為了避免資料庫中的時間出現衝突，最好等待目前時間超過修改前的系統時間後，再啟動CLUSTER環境和RAC資料庫：

# date

Tue Aug  4 17:51:44 CST 2009

# su - oracle

Sun Microsystems Inc.   SunOS 5.10      Generic January 2005

You have mail.

$ bash

bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on星期二8月4 17:51:59 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

串連到:

Oracle Database10gEnterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> shutdown immediate

資料庫已經關閉。

已經卸載資料庫。

ORACLE常式已經關閉。

SQL> exit

從Oracle Database10gEnterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options斷開

bash-3.00$ lsnrctl stop

LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 04-8月-2009 17:54:41

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

正在串連到(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

命令執行成功

bash-3.00$ exit

exit

$ exit

# date

Tue Aug  4 17:54:51 CST 2009

# /etc/init.d/init.crs stop

Shutting down Oracle Cluster Ready Services (CRS):

Aug  4 17:54:57.422 | INF | daemon shutting down

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

Shutdown has begun. The daemons should exit soon.

# date

Tue Aug  4 17:55:02 CST 2009

# date 080417472009.20

Tue Aug  4 17:47:20 CST 2009

# date

Tue Aug  4 17:59:18 CST 2009

# /etc/init.d/init.crs start

Startup will be queued to init within 30 seconds.

# ps -ef|grep ora

 oracle 18590     1   0 17:55:01 ?           0:00 sh -c sh -c 'ulimit -c unlimited; cd /opt/oracle/product/10.2/crs/log/ahrac1/ev

 oracle 24249     1   0 18:01:03 ?           0:00 oracletradedb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

root 18636     1   0 17:55:01 ?           0:01 /opt/oracle/product/10.2/crs/bin/crsd.bin reboot

 oracle 24454     1   0 18:01:09 ?           0:00 ora_q001_tradedb1

 oracle 23386     1   0 18:00:34 ?           0:00 ora_pmon_tradedb1

 oracle 22101 21913   0 17:59:52 ?           0:00 sh -c /bin/sh -c 'ulimit -c unlimited; cd /opt/oracle/product/10.2/crs/log/ahra

 oracle 23445     1   0 18:00:35 ?           0:00 ora_reco_tradedb1

 oracle 24450     1   0 18:01:09 ?           0:00 oracletradedb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

本文URL地址：http://www.bianceng.cn/database/Oracle/201410/45384.htm