对于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