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 Database 10g Enterprise 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 Database 10g Enterprise 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)))
oracle 23429 1 1 18:00:34 ? 0:07 ora_lms1_tradedb1
oracle 22104 22101 0 17:59:52 ? 0:00 /bin/sh -c ulimit -c unlimited; cd /opt/oracle/product/10.2/crs/log/ahrac1/cssd
oracle 23435 1 0 18:00:34 ? 0:00 ora_dbw0_tradedb1
oracle 22106 22104 0 17:59:52 ? 0:01 /opt/oracle/product/10.2/crs/bin/ocssd.bin
oracle 22139 18590 0 17:59:53 ? 0:00 /opt/oracle/product/10.2/crs/bin/evmd.bin
oracle 23390 1 0 18:00:34 ? 0:00 ora_psp0_tradedb1
oracle 4764 4762 0 May 27 ? 3:09 /opt/oracle/product/10.2/crs/opmn/bin/ons -d
oracle 4762 1 0 May 27 ? 0:00 /opt/oracle/product/10.2/crs/opmn/bin/ons -d
oracle 22667 1 0 18:00:08 ? 0:00 /opt/oracle/product/10.2/database/bin/tnslsnr LISTENER_AHRAC1 -inherit
oracle 22713 1 0 18:00:10 ? 0:00 /opt/oracle/product/10.2/database/bin/racgimon startd tradedb
oracle 23388 1 0 18:00:34 ? 0:00 ora_diag_tradedb1
oracle 23425 1 1 18:00:34 ? 0:07 ora_lms0_tradedb1
oracle 24446 1 0 18:01:09 ? 0:00 oracletradedb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 23437 1 0 18:00:34 ? 0:00 ora_dbw1_tradedb1
oracle 24183 1 0 18:01:00 ? 0:00 ora_pz99_tradedb1
oracle 23433 1 2 18:00:34 ? 0:07 ora_mman_tradedb1
oracle 23423 1 0 18:00:34 ? 0:01 ora_lmd0_tradedb1
oracle 23443 1 0 18:00:35 ? 0:01 ora_smon_tradedb1
oracle 23439 1 1 18:00:35 ? 0:01 ora_lgwr_tradedb1
oracle 24448 1 0 18:01:09 ? 0:00 oracletradedb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 23451 1 0 18:00:35 ? 0:00 ora_mmnl_tradedb1
oracle 23945 1 0 18:00:52 ? 0:00 ora_arc1_tradedb1
oracle 22391 22139 0 18:00:01 ? 0:00 /opt/oracle/product/10.2/crs/bin/evmlogger.bin -o /opt/oracle/product/10.2/crs/
oracle 23447 1 0 18:00:35 ? 0:00 ora_cjq0_tradedb1
oracle 23453 1 0 18:00:35 ? 0:00 ora_d000_tradedb1
oracle 23914 1 0 18:00:51 ? 0:00 ora_arc0_tradedb1
oracle 24094 1 0 18:00:58 ? 0:00 ora_qmnc_tradedb1
oracle 23414 1 1 18:00:34 ? 0:02 ora_lmon_tradedb1
oracle 23441 1 0 18:00:35 ? 0:00 ora_ckpt_tradedb1
oracle 23455 1 0 18:00:35 ? 0:00 ora_s000_tradedb1
root 24513 577 0 18:01:11 pts/1 0:00 grep ora
oracle 23765 1 0 18:00:45 ? 0:01 ora_lck0_tradedb1
root 21963 21912 0 17:59:50 ? 0:00 /opt/oracle/product/10.2/crs/bin/oprocd run -t 1000 -m 500 -f
oracle 24452 1 0 18:01:09 ? 0:00 ora_q000_tradedb1
oracle 23449 1 4 18:00:35 ? 0:08 ora_mmon_tradedb1
檢查節點1上alert檔案中的資訊：
Tue Aug 4 17:52:03 2009
Starting background process EMN0
EMN0 started with pid=72, OS id=13528
Tue Aug 4 17:52:03 2009
Shutting down instance: further logons disabled
Tue Aug 4 17:52:04 2009
Stopping background process QMNC
Tue Aug 4 17:52:04 2009
Stopping background process CJQ0
Tue Aug 4 17:52:06 2009
Stopping background process MMNL
Tue Aug 4 17:52:07 2009
Stopping background process MMON
Tue Aug 4 17:52:08 2009
Shutting down instance (immediate)
License high water mark = 82
Tue Aug 4 17:52:08 2009
Stopping Job queue slave processes
Tue Aug 4 17:52:08 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue Aug 4 17:52:18 2009
ALTER DATABASE CLOSE NORMAL
Tue Aug 4 17:52:18 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Aug 4 17:52:19 2009
Shutting down archive processes
Archiving is disabled
Tue Aug 4 17:52:24 2009
ARCH shutting down
ARC1: Archival stopped
Tue Aug 4 17:52:29 2009
ARCH shutting down
ARC0: Archival stopped
Tue Aug 4 17:52:30 2009
Thread 1 closed at log sequence 3316
Successful close of redo thread 1
Tue Aug 4 17:52:41 2009
Completed: ALTER DATABASE CLOSE NORMAL
Tue Aug 4 17:52:41 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Aug 4 17:52:46 2009
freeing rdom 0
Tue Aug 4 18:00:12 2009
Starting ORACLE instance (normal)
Tue Aug 4 18:00:32 2009
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 ce1 10.0.0.0 configured from OCR for use as a cluster interconnect
Interface type 1 ce0 172.0.2.0 configured from OCR for use as a public interface
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
processes = 300
sessions = 335
__shared_pool_size = 7532969984
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 50331648
streams_pool_size = 50331648
spfile = /dev/vx/rdsk/datadg/tradedb_spfile
nls_language = AMERICAN
nls_territory = AMERICA
sga_target = 21474836480
control_files = /dev/vx/rdsk/datadg/tradedb_control1, /dev/vx/rdsk/datadg/tradedb_control2, /dev/vx/rdsk/datadg/tradedb_control3
db_block_size = 16384
__db_cache_size = 13841203200
compatible = 10.2.0.1.0
log_archive_dest_1 = LOCATION=/data/oradata/tradedb/archivelog1
standby_archive_dest = /data/oradata/tradedb/archivelog1
log_archive_local_first = FALSE
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 16
cluster_database = TRUE
cluster_database_instances= 2
thread = 1
instance_number = 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain = us.oracle.com
global_names = TRUE
dispatchers = (PROTOCOL=TCP) (SERVICE=tradedbXDB)
local_listener = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.0.2.13)(PORT = 1521))
remote_listener = LISTENERS_TRADEDB
job_queue_processes = 50
background_dump_dest = /opt/oracle/admin/tradedb/bdump
user_dump_dest = /opt/oracle/admin/tradedb/udump
core_dump_dest = /opt/oracle/admin/tradedb/cdump
audit_file_dest = /opt/oracle/admin/tradedb/adump
session_max_open_files = 20
db_name = tradedb
open_cursors = 5000
pga_aggregate_target = 4395630592
Cluster communication is configured to use the following interface(s) for this instance
10.0.0.1
Tue Aug 4 18:00:33 2009
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
PMON started with pid=2, OS id=23386
DIAG started with pid=4, OS id=23388
PSP0 started with pid=6, OS id=23390
LMON started with pid=8, OS id=23414
LMD0 started with pid=10, OS id=23423
LMS0 started with pid=12, OS id=23425
LMS1 started with pid=3, OS id=23429
MMAN started with pid=14, OS id=23433
DBW0 started with pid=16, OS id=23435
DBW1 started with pid=5, OS id=23437
LGWR started with pid=7, OS id=23439
CKPT started with pid=18, OS id=23441
SMON started with pid=20, OS id=23443
RECO started with pid=22, OS id=23445
CJQ0 started with pid=24, OS id=23447
MMON started with pid=26, OS id=23449
Tue Aug 4 18:00:34 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=28, OS id=23451
Tue Aug 4 18:00:34 2009
starting up 1 shared server(s) ...
Tue Aug 4 18:00:35 2009
lmon registered with NM - instance id 1 (internal mem no 0)
Tue Aug 4 18:00:39 2009
Reconfiguration started (old inc 0, new inc 8)
List of nodes:
0 1
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
* domain 0 valid according to instance 1
* domain 0 valid = 1 according to instance 1
Tue Aug 4 18:00:39 2009
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Tue Aug 4 18:00:39 2009
LMS 0: 0 GCS shadows cancelled, 0 closed
Tue Aug 4 18:00:39 2009
LMS 1: 0 GCS shadows cancelled, 0 closed
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Tue Aug 4 18:00:40 2009
LMS 0: 0 GCS shadows traversed, 0 replayed
Tue Aug 4 18:00:40 2009
LMS 1: 0 GCS shadows traversed, 0 replayed
Tue Aug 4 18:00:40 2009
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
LCK0 started with pid=34, OS id=23765
Tue Aug 4 18:00:46 2009
ALTER DATABASE MOUNT
Tue Aug 4 18:00:50 2009
Setting recovery target incarnation to 1
Tue Aug 4 18:00:50 2009
Successful mount of redo thread 1, with mount id 4249192057
Tue Aug 4 18:00:50 2009
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Completed: ALTER DATABASE MOUNT
Tue Aug 4 18:00:50 2009
ALTER DATABASE OPEN
Tue Aug 4 18:00:50 2009
Picked broadcast on commit scheme to generate SCNs
Tue Aug 4 18:00:51 2009
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=38, OS id=23914
Tue Aug 4 18:00:51 2009
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=9, OS id=23945
Tue Aug 4 18:00:52 2009
Thread 1 opened at log sequence 3316
Current log# 4 seq# 3316 mem# 0: /dev/vx/rdsk/datadg/tradedb_redo1_4_1_1g
Current log# 4 seq# 3316 mem# 1: /dev/vx/rdsk/datadg/tradedb_redo1_4_2_1g
Successful open of redo thread 1
Tue Aug 4 18:00:52 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Aug 4 18:00:52 2009
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Tue Aug 4 18:00:52 2009
ARC0: Becoming the heartbeat ARCH
Tue Aug 4 18:00:52 2009
SMON: enabling cache recovery
Tue Aug 4 18:00:56 2009
Successfully onlined Undo Tablespace 1.
Tue Aug 4 18:00:56 2009
SMON: enabling tx recovery
Tue Aug 4 18:00:56 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=40, OS id=24094
Tue Aug 4 18:01:00 2009
Completed: ALTER DATABASE OPEN
採用這種方式系統不會重啟：
SQL> select sysdate from dual;
SYSDATE
-------------------
2009-08-04 17:43:16
SQL> select instance_name, startup_time from gv$instance;
INSTANCE_NAME STARTUP_TIME
---------------- -------------------
testrac2 2009-05-22 18:04:16
testrac3 2009-08-04 17:28:55
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/4227/viewspace-616274/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 系統時間的調整
- linux調整系統時間Linux
- 調整linux系統時間和時區Linux
- RAC環境中修改系統時間可能導致SRVCTL命令失敗
- Linux調整系統時間和時區的方法Linux
- 修改系統時間導致RAC環境的一個例項重啟
- 【實驗】Linux調整系統時間和時區的方法Linux
- linux時間調整Linux
- （轉）windows環境下rac節點時間同步方法Windows
- 調整WebLogic的時間Web
- 如何修改rac的系統時間
- win10 如何校準系統時間_win10時間不準怎麼調整Win10
- linux系統檢視調整swap空間Linux
- 第48問：為什麼 MySQL 執行時, 不鼓勵調整系統時間MySql
- 定位rac環境中某條sql執行時間過長SQL
- 11gR2 RAC環境下私網網路卡更名後如何調整GI配置
- [Linux] ntpdate slew模式調整時間Linux模式
- Activity Monitor log儲存時間調整
- AIX6調整系統時間，引發asm報錯例項當機AIASM
- RAC中修改系統時間的問題
- 搭建RAC時配置scanip的DNS環境DNS
- Oracle資料庫 檔案系統與裸裝置之間的轉換（RAC環境）Oracle資料庫
- 【Linux-時間設定】-設定時區並調整時間Linux
- oracle&linux環境vm相關的調整OracleLinux
- rac的系統時間與物理備庫lag
- 調整Kali Linux的鎖屏時間Linux
- AIX檔案系統調整AI
- Linux環境安裝Oracle11g(二)——作業系統引數及服務調整LinuxOracle作業系統
- linux系統lvm中lv使用空間的調整LinuxLVM
- VirtualBox虛擬機器內的系統時間無法調整的解決方法虛擬機
- RAC環境ASM磁碟組間修改spfile的位置ASM
- ORACLE RAC SGA引數調整Oracle
- （轉）用NSDateFormatter調整時間格式的程式碼ORM
- Linux系統調整swap大小Linux
- SAP系統中成本中心調整
- 【效能調整】系統檢視（二）
- 【效能調整】系統檢視（一）
- 【新炬網路名師大講堂】RAC環境下SYSDATE返回錯誤時間