RAC环境调整系统时间

对于RAC环境而言，调整系统时间不是一件小事情，Oracle为了保证节点之间的一致性，很可能会重启其中一个节点。

 

 

测试发现，如果将系统时间向前调整，那么无论调整多长的时间都不会造成系统的重启。但是如果将系统时间向后调整，就会造成整个节点的重启。

即使是关闭数据库，调整时间仍然会重启节点。

正确的方法是首先关闭数据库和CLUSTER环境，然后修改系统时间，为了避免数据库中的时间出现冲突，最好等待当前时间超过修改前的系统时间后，再启动CLUSTER环境和RAC数据库：

# dateITPUB个人空间WX3M[f(R VfK+wJ
Tue Aug  4 17:51:44 CST 2009ITPUB个人空间 MU t ^:I#Dd
# su - oracle
2?l#A$~3K235507Sun Microsystems Inc.   SunOS 5.10      Generic January 2005ITPUB个人空间2^$uk!W"L {n S[+Dw
You have mail.
(ld^ m.h;~S8_,Q235507$ bash
)L| GbL8Y&t235507bash-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.

ITPUB个人空间-]+hZq|ei}
连接到:ITPUB个人空间 me-KTPr n
Oracle Database10gEnterprise Edition Release 10.2.0.3.0 - 64bit ProductionITPUB个人空间3Zl0{4OtcO
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> shutdown immediateITPUB个人空间\4u k%BH sfY F
数据库已经关闭。
a1J B#oh235507已经卸载数据库。ITPUB个人空间~;G&_]a8P:ew)t
ORACLE例程已经关闭。
/j0O|1O"u cj [235507SQL> exit
*`(YQ4{Te,{/v9M]-x235507从Oracle Database10gEnterprise Edition Release 10.2.0.3.0 - 64bit ProductionITPUB个人空间y)\&koS
With the Partitioning, Real Application Clusters, OLAP and Data Mining options断开
"v%nQ,u7N{;A8B,L235507bash-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))ITPUB个人空间2L5d*m.^3N1K?2B
命令执行成功
\'iC!G+DYIz ro:F235507bash-3.00$ exit
!~,bb0X3~k5ZQ235507exitITPUB个人空间'E@f r\w k/F.f
$ exitITPUB个人空间zcOb6t5sU{U
# date
2PA#l WH{)f235507Tue Aug  4 17:54:51 CST 2009ITPUB个人空间 a-Z7\O]{&N4s$E
# /etc/init.d/init.crs stop
"y `7c+u5w235507Shutting down Oracle Cluster Ready Services (CRS):
k jE#Y_2t3r w"{$h235507Aug  4 17:54:57.422 | INF | daemon shutting downITPUB个人空间e H6o8V8xy5Ip2i0V
Stopping resources.
)r b,r{A%N235507Successfully stopped CRS resources
!tke&P@P;wn235507Stopping CSSD.
@Y*yKS(ne235507Shutting down CSS daemon.
Xr2fQC{wh235507Shutdown request successfully issued.
Vvg-Ky)pE235507Shutdown has begun. The daemons should exit soon.ITPUB个人空间;L!X{;q `A,[i6p'g3R
# dateITPUB个人空间BBv|F{"X
Tue Aug  4 17:55:02 CST 2009
`jF4~~!@K235507# date 080417472009.20
M7P#{ I3E:S!IX235507Tue Aug  4 17:47:20 CST 2009
-c'bt!ZX}3bfa@235507# date
m/I%FrB4K235507Tue Aug  4 17:59:18 CST 2009ITPUB个人空间_(F+W5r Y7x X W4xL
# /etc/init.d/init.crs start
H5zXm"j b1H |235507Startup will be queued to init within 30 seconds.
^$]1| Z1q1_'K#a235507# ps -ef|grep ora
a$PF9H(lc$@J235507  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
!XC bKB H[4Ik%h235507  oracle 24249     1   0 18:01:03 ?           0:00 oracletradedb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
#d7Y'fg9STL235507    root 18636     1   0 17:55:01 ?           0:01 /opt/oracle/product/10.2/crs/bin/crsd.bin reboot
Y_'`3i,f/i235507  oracle 24454     1   0 18:01:09 ?           0:00 ora_q001_tradedb1ITPUB个人空间;iaj$N ?9T,T;F4F
  oracle 23386     1   0 18:00:34 ?           0:00 ora_pmon_tradedb1ITPUB个人空间$x Y{9w]k
  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/ahraITPUB个人空间#dUM*_sJ8^
  oracle 23445     1   0 18:00:35 ?           0:00 ora_reco_tradedb1ITPUB个人空间M0XF-Q_F+}
  oracle 24450     1   0 18:01:09 ?           0:00 oracletradedb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
*B6z)PnI"} |.Q235507  oracle 23429     1   1 18:00:34 ?           0:07 ora_lms1_tradedb1ITPUB个人空间f'J] F0rM;k{
  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
,U,j3x%\B7p.D?.qS235507  oracle 23435     1   0 18:00:34 ?           0:00 ora_dbw0_tradedb1
uq m'tSy7u235507  oracle 22106 22104   0 17:59:52 ?           0:01 /opt/oracle/product/10.2/crs/bin/ocssd.binITPUB个人空间1Q?&va$U%J'f
  oracle 22139 18590   0 17:59:53 ?           0:00 /opt/oracle/product/10.2/crs/bin/evmd.bin
oVZ0S[235507  oracle 23390     1   0 18:00:34 ?           0:00 ora_psp0_tradedb1
gskRJ4Fr-u/M235507  oracle  4764  4762   0   May 27 ?           3:09 /opt/oracle/product/10.2/crs/opmn/bin/ons -dITPUB个人空间1Q-ktT r.i&_6pG5x
  oracle  4762     1   0   May 27 ?           0:00 /opt/oracle/product/10.2/crs/opmn/bin/ons -d
.l aZ!h)g235507  oracle 22667     1   0 18:00:08 ?           0:00 /opt/oracle/product/10.2/database/bin/tnslsnr LISTENER_AHRAC1 -inheritITPUB个人空间 u'A/[6?y*On
  oracle 22713     1   0 18:00:10 ?           0:00 /opt/oracle/product/10.2/database/bin/racgimon startd tradedbITPUB个人空间Lv Fr5U!kr#TX$v b
  oracle 23388     1   0 18:00:34 ?           0:00 ora_diag_tradedb1ITPUB个人空间6ADy_2cg,f6L
  oracle 23425     1   1 18:00:34 ?           0:07 ora_lms0_tradedb1
.y9~3T0b2oA/sl}235507  oracle 24446     1   0 18:01:09 ?           0:00 oracletradedb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))ITPUB个人空间&Lv y}7v%ST`b+V
  oracle 23437     1   0 18:00:34 ?           0:00 ora_dbw1_tradedb1
8Tv'G K!Z(e235507  oracle 24183     1   0 18:01:00 ?           0:00 ora_pz99_tradedb1ITPUB个人空间 TLa1|*Z%dY1zB
  oracle 23433     1   2 18:00:34 ?           0:07 ora_mman_tradedb1ITPUB个人空间]xH s5bC#I6m T
  oracle 23423     1   0 18:00:34 ?           0:01 ora_lmd0_tradedb1ITPUB个人空间W8UfO6oU
  oracle 23443     1   0 18:00:35 ?           0:01 ora_smon_tradedb1ITPUB个人空间DlU7hM
  oracle 23439     1   1 18:00:35 ?           0:01 ora_lgwr_tradedb1ITPUB个人空间5x5u(w3L3k@a U
  oracle 24448     1   0 18:01:09 ?           0:00 oracletradedb1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))ITPUB个人空间+x9F*Ya Z1T
  oracle 23451     1   0 18:00:35 ?           0:00 ora_mmnl_tradedb1
${ T R_*Z"xT8Q&k+E.V235507  oracle 23945     1   0 18:00:52 ?           0:00 ora_arc1_tradedb1
J }"FjR235507  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/
l Kwr H/t6^&Wm vm235507  oracle 23447     1   0 18:00:35 ?           0:00 ora_cjq0_tradedb1ITPUB个人空间8X|0fVQ+o X pG
  oracle 23453     1   0 18:00:35 ?           0:00 ora_d000_tradedb1
-m_2m W&}kh235507  oracle 23914     1   0 18:00:51 ?           0:00 ora_arc0_tradedb1
_%f^I:JT235507  oracle 24094     1   0 18:00:58 ?           0:00 ora_qmnc_tradedb1
#b[$@o ?"X"jb235507  oracle 23414     1   1 18:00:34 ?           0:02 ora_lmon_tradedb1
"Y0U!y,B'Q235507  oracle 23441     1   0 18:00:35 ?           0:00 ora_ckpt_tradedb1
t.R4MKg235507  oracle 23455     1   0 18:00:35 ?           0:00 ora_s000_tradedb1ITPUB个人空间 Q/_+iFise.^2g2E
    root 24513   577   0 18:01:11 pts/1       0:00 grep oraITPUB个人空间.e iv7rB!w~:w}
  oracle 23765     1   0 18:00:45 ?           0:01 ora_lck0_tradedb1ITPUB个人空间"e#\2Nu9u
    root 21963 21912   0 17:59:50 ?           0:00 /opt/oracle/product/10.2/crs/bin/oprocd run -t 1000 -m 500 -fITPUB个人空间g g}:`"^
  oracle 24452     1   0 18:01:09 ?           0:00 ora_q000_tradedb1
0Ha9A&y De1X235507  oracle 23449     1   4 18:00:35 ?           0:08 ora_mmon_tradedb1

检查节点1上alert文件中的信息：

Tue Aug  4 17:52:03 2009ITPUB个人空间W4U O%f`3t-fs;] C
Starting background process EMN0
gC#j,r5yQ`7X235507EMN0 started with pid=72, OS id=13528
$x Kp3uF|Q_r235507Tue Aug  4 17:52:03 2009ITPUB个人空间;m4u&YL!WQ
Shutting down instance: further logons disabled
$bb%DS H9g"\235507Tue Aug  4 17:52:04 2009
s-~d1omq,d-xN235507Stopping background process QMNC
}C bMf Jc235507Tue Aug  4 17:52:04 2009ITPUB个人空间+C6j!Z/t4K'a X h
Stopping background process CJQ0ITPUB个人空间5Y:P*B;_d/I1x
Tue Aug  4 17:52:06 2009
v'u%X:`x)^5`235507Stopping background process MMNLITPUB个人空间Y Fm#}4P2F"xM0D
Tue Aug  4 17:52:07 2009ITPUB个人空间 ` l/xH#MH"SM
Stopping background process MMON
2a7B A__[3Tb235507Tue Aug  4 17:52:08 2009
'zR4q_z5z5a235507Shutting down instance (immediate)
&} H9]3r.K"xlm-vj/L235507License high water mark = 82ITPUB个人空间yZ&\$u+ou5[;}Z3i!J`
Tue Aug  4 17:52:08 2009
hM8c4K:O%DT{8g7g235507Stopping Job queue slave processes
B:I#T6@D9v!\AkY235507Tue Aug  4 17:52:08 2009ITPUB个人空间w+da}9b:o\
Job queue slave processes stoppedITPUB个人空间u*\1QnA{;U
All dispatchers and shared servers shutdown
&I9gU&nf:u Az235507Tue Aug  4 17:52:18 2009
P_u pQL235507ALTER DATABASE CLOSE NORMALITPUB个人空间E"~4pb ?*]5QX
Tue Aug  4 17:52:18 2009ITPUB个人空间_K5t;SD
SMON: disabling tx recoveryITPUB个人空间1E(T5[J \P
SMON: disabling cache recoveryITPUB个人空间v [IXO L
Tue Aug  4 17:52:19 2009
OR)fH7}(V8GcAc6l235507Shutting down archive processes
2w7E%JE ['}.K(A235507Archiving is disabled
E'GfX!wQ(D235507Tue Aug  4 17:52:24 2009ITPUB个人空间3EbN bhJL;e|6W
ARCH shutting downITPUB个人空间s)PS2bt^u Z k1[r5_
ARC1: Archival stopped
v(zP*cuVu$e,Z235507Tue Aug  4 17:52:29 2009ITPUB个人空间!~j(tga"N
ARCH shutting downITPUB个人空间8~4`yk/k kp
ARC0: Archival stoppedITPUB个人空间 n:i9E|nCj k
Tue Aug  4 17:52:30 2009ITPUB个人空间 oV*fe2Qh!z
Thread 1 closed at log sequence 3316
H C r8}L3R}2c235507Successful close of redo thread 1ITPUB个人空间 I ncTP~%^
Tue Aug  4 17:52:41 2009ITPUB个人空间SZ6l2r l EK
Completed: ALTER DATABASE CLOSE NORMALITPUB个人空间2Fm%d8Y`&I
Tue Aug  4 17:52:41 2009
g+tr:k?5HSp235507ALTER DATABASE DISMOUNTITPUB个人空间,i@3q B-r]/H6L%U!\
Completed: ALTER DATABASE DISMOUNTITPUB个人空间$q0@"D&?!aA6xX7x
ARCH: Archival disabled due to shutdown: 1089ITPUB个人空间U5x@+kkDH w
Shutting down archive processes
.i'sx%uj;k2|235507Archiving is disabled
C;Cy i#oa|/AhJ-h235507Archive process shutdown avoided: 0 active
%ad9_Hb]'b235507ARCH: Archival disabled due to shutdown: 1089
oQ^%y^.u235507Shutting down archive processesITPUB个人空间+h1\]\2E5_
Archiving is disabledITPUB个人空间 uv*Nq6b
Archive process shutdown avoided: 0 active
;cZ3kOe2W8|+c?0c235507Tue Aug  4 17:52:46 2009
LM f-sMES235507freeing rdom 0ITPUB个人空间L)b1qFPE
Tue Aug  4 18:00:12 2009
[!m)v Q,qEvt235507Starting ORACLE instance (normal)
.S4b7R4|:H4Ey s8}235507Tue Aug  4 18:00:32 2009
Qx-P?#@Ub"l3}235507LICENSE_MAX_SESSION = 0ITPUB个人空间M g!q2K;g"d-M O
LICENSE_SESSIONS_WARNING = 0
d$u T H5`e235507Interface type 1 ce1 10.0.0.0 configured from OCR for use as a cluster interconnect
2p:{Z+L!q,U235507Interface type 1 ce0 172.0.2.0 configured from OCR for use as  a public interface
%sf+eqhjc8kA235507Picked latch-free SCN scheme 3ITPUB个人空间 Fw7s;i z'y?9I(\dr
Autotune of undo retention is turned on.ITPUB个人空间R'c8s^rI{
LICENSE_MAX_USERS = 0ITPUB个人空间JEJy,DG+d
SYS auditing is disabled
M$u)f5vl#FB235507ksdpec: called for event 13740 prior to event group initializationITPUB个人空间 L's}m$z1g
Starting up ORACLE RDBMS Version: 10.2.0.3.0.ITPUB个人空间(]r{:A/xD%U c
System parameters with non-default values:ITPUB个人空间Gd5Ri;nA
  processes                = 300ITPUB个人空间 a3@6GWyj(GCH5X7O
  sessions                 = 335ITPUB个人空间"b!Tp0X!Z}]R
  __shared_pool_size       = 7532969984ITPUB个人空间?c_i!aX
  __large_pool_size        = 16777216
M^[9R `;vo235507  __java_pool_size         = 16777216
Q?Y0J)L235507  __streams_pool_size      = 50331648ITPUB个人空间.M5S qf j&ZNY
  streams_pool_size        = 50331648ITPUB个人空间@'NE? `2dz
  spfile                   = /dev/vx/rdsk/datadg/tradedb_spfileITPUB个人空间 JRtWo4r9a
  nls_language             = AMERICAN
g&z H5oXm8Z235507  nls_territory            = AMERICA
v4\D#V |V.q235507  sga_target               = 21474836480ITPUB个人空间]+c(v LNB.GF]
  control_files            = /dev/vx/rdsk/datadg/tradedb_control1, /dev/vx/rdsk/datadg/tradedb_control2, /dev/vx/rdsk/datadg/tradedb_control3ITPUB个人空间s'b!Mh^!ORB-R%l_
  db_block_size            = 16384ITPUB个人空间;N8L:JH3ZY#@
  __db_cache_size          = 13841203200
'R7y,i2Pii.]235507  compatible               = 10.2.0.1.0ITPUB个人空间?*e$F{o1c\%N&o!n N p
  log_archive_dest_1       = LOCATION=/data/oradata/tradedb/archivelog1
)Rj zp ZmWP235507  standby_archive_dest     = /data/oradata/tradedb/archivelog1ITPUB个人空间%j-^"E W&@Z*K
  log_archive_local_first  = FALSE
&U#fZY{)`235507  log_archive_format       = %t_%s_%r.dbfITPUB个人空间5tc9w%jsK
  db_file_multiblock_read_count= 16ITPUB个人空间 C"s F(N3KMd0v
  cluster_database         = TRUEITPUB个人空间u'Y-D)Jg WX^
  cluster_database_instances= 2ITPUB个人空间y;` v `"l
  thread                   = 1
7{ KjH*DCeXAZ,T235507  instance_number          = 1ITPUB个人空间v6r emN*H XK
  undo_management          = AUTOITPUB个人空间g/D G.O#XP#a^
  undo_tablespace          = UNDOTBS1ITPUB个人空间!R-v:S~i9g
  undo_retention           = 10800ITPUB个人空间h5W]k1X
  remote_login_passwordfile= EXCLUSIVEITPUB个人空间(jzg e4SPT
  db_domain                = us.oracle.comITPUB个人空间{-`&~"c|6?$N
  global_names             = TRUEITPUB个人空间c|{sY
  dispatchers              = (PROTOCOL=TCP) (SERVICE=tradedbXDB)
&S2uBb'Q&cZ235507  local_listener           = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.0.2.13)(PORT = 1521))
z+^e\ v}y^235507  remote_listener          = LISTENERS_TRADEDBITPUB个人空间A5s?.U@
  job_queue_processes      = 50ITPUB个人空间JTvl4I ~"kl
  background_dump_dest     = /opt/oracle/admin/tradedb/bdumpITPUB个人空间;k#s+~ z~1qQ"K
  user_dump_dest           = /opt/oracle/admin/tradedb/udump
/|&a_/y{-ZlVVM235507  core_dump_dest           = /opt/oracle/admin/tradedb/cdump
x:q.PP[i235507  audit_file_dest          = /opt/oracle/admin/tradedb/adumpITPUB个人空间I5m2D@R_
  session_max_open_files   = 20
] @,[+I0l;T8ED#D!^235507  db_name                  = tradedb
/a@c [;K!u2U;e?*s235507  open_cursors             = 5000
je!}1~$I`x235507  pga_aggregate_target     = 4395630592ITPUB个人空间*T}[6h/A
Cluster communication is configured to use the following interface(s) for this instance
9F b X{-P VwO ]235507  10.0.0.1
+Xb!g,uTGc235507Tue Aug  4 18:00:33 2009
4{wD N8sK4S235507cluster interconnect IPC version:Oracle UDP/IP (generic)
)E wv nkn5QD235507IPC Vendor 1 proto 2
;o XU^f a235507PMON started with pid=2, OS id=23386
`4m }!i:hV?~235507DIAG started with pid=4, OS id=23388
#]y#wr0H,I235507PSP0 started with pid=6, OS id=23390ITPUB个人空间2i9q5rYX8cQ7]
LMON started with pid=8, OS id=23414ITPUB个人空间7S-e[GH!F
LMD0 started with pid=10, OS id=23423ITPUB个人空间+t{/YXh _5k
LMS0 started with pid=12, OS id=23425ITPUB个人空间y*[#R]W;\ N
LMS1 started with pid=3, OS id=23429
%t0XFK!xl235507MMAN started with pid=14, OS id=23433ITPUB个人空间w _|5aCZ}-K R
DBW0 started with pid=16, OS id=23435
1U+?O3wqb"HHkW^E235507DBW1 started with pid=5, OS id=23437ITPUB个人空间9i V:~6DF
LGWR started with pid=7, OS id=23439ITPUB个人空间#F/Cnj n
CKPT started with pid=18, OS id=23441
3a{Wi4@/k:[2^235507SMON started with pid=20, OS id=23443
q2ab DdwR iA4c235507RECO started with pid=22, OS id=23445ITPUB个人空间4OE*O3@F:b(_ k5l
CJQ0 started with pid=24, OS id=23447
Sb8N[| S"|235507MMON started with pid=26, OS id=23449ITPUB个人空间nA6fZ)M1H8x
Tue Aug  4 18:00:34 2009
)G.yY g G235507starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...ITPUB个人空间d p3dJ.?7{
MMNL started with pid=28, OS id=23451ITPUB个人空间A#_*t2^;R9Q6~.V
Tue Aug  4 18:00:34 2009ITPUB个人空间`G4e.H2zw
starting up 1 shared server(s) ...
$g"t7^l.D WIv,@235507Tue Aug  4 18:00:35 2009ITPUB个人空间F9{8m+s/D7OX
lmon registered with NM - instance id 1 (internal mem no 0)ITPUB个人空间}Gcp1p]W
Tue Aug  4 18:00:39 2009ITPUB个人空间(H)T/f~H8s K
Reconfiguration started (old inc 0, new inc 8)
+EsA De0i9C0f$u0A235507List of nodes:ITPUB个人空间1[#L?Kz
 0 1
LH!BRD+S\3p'Pz_ C235507 Global Resource Directory frozen
3GU7fdc.|%P235507* allocate domain 0, invalid = TRUEITPUB个人空间*ho`Ege*v
 Communication channels reestablished
y$Zd(\["oS(a C u235507 * domain 0 valid according to instance 1
|z^4d7U6NNb5h;A;cb235507 * domain 0 valid = 1 according to instance 1
M\(IAt j'x'X}235507Tue Aug  4 18:00:39 2009ITPUB个人空间 T;E9e$LY$Z#@
 Master broadcasted resource hash value bitmapsITPUB个人空间 E V:CJiO
 Non-local Process blocks cleaned out
Ap(w(W%Gqb235507Tue Aug  4 18:00:39 2009
4d9nj:D#b{235507 LMS 0: 0 GCS shadows cancelled, 0 closedITPUB个人空间7U"e.M5j ~
Tue Aug  4 18:00:39 2009
0[|zP5E U#Ze235507 LMS 1: 0 GCS shadows cancelled, 0 closed
v$R4{n.K&N0_235507 Set master node infoITPUB个人空间&qgi&{h]5D9x.D
 Submitted all remote-enqueue requests
f.z_JVvZ#`}235507 Dwn-cvts replayed, VALBLKs dubiousITPUB个人空间+c-i6ww ^
 All grantable enqueues grantedITPUB个人空间 y!Ke @ @-FF
Tue Aug  4 18:00:40 2009
Zhz D2H!` ?235507 LMS 0: 0 GCS shadows traversed, 0 replayed
6T:VJ i1_"}e235507Tue Aug  4 18:00:40 2009ITPUB个人空间&UT)v"s:_CL M!\L
 LMS 1: 0 GCS shadows traversed, 0 replayedITPUB个人空间5k8\?m1E_ OXz.^
Tue Aug  4 18:00:40 2009
d!{ s;} x_[u235507 Submitted all GCS remote-cache requestsITPUB个人空间m5B+i5l"])j Ki
 Post SMON to start 1st pass IRITPUB个人空间'e-B3Fj$j6xH$b$F'u
 Fix write in gcs resources
F}\rK tZ)Y:m235507Reconfiguration completeITPUB个人空间m/k.[f \N2W
LCK0 started with pid=34, OS id=23765ITPUB个人空间#]rY^c8R/t zSJ
Tue Aug  4 18:00:46 2009ITPUB个人空间y1P'xW9S'GH2b {L
ALTER DATABASE   MOUNTITPUB个人空间c"vmk5Ru o
Tue Aug  4 18:00:50 2009
,w?]W*\5X235507Setting recovery target incarnation to 1
%R%q8R*?LC235507Tue Aug  4 18:00:50 2009
rV&Y+W$Q"oa7NC|_'v235507Successful mount of redo thread 1, with mount id 4249192057
i[.k%T&K7w9mM3g235507Tue Aug  4 18:00:50 2009
$y'yh {xo:b235507Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)ITPUB个人空间 DG7g lI7Y~
Completed: ALTER DATABASE   MOUNT
h4g v6@`.}'y:_235507Tue Aug  4 18:00:50 2009
s TiyYq235507ALTER DATABASE OPEN
j:Z ~d ey235507Tue Aug  4 18:00:50 2009
8D_&wUAV9Q { U/D235507Picked broadcast on commit scheme to generate SCNs
z_5n CB u235507Tue Aug  4 18:00:51 2009
m4F @(F s235507LGWR: STARTING ARCH PROCESSESITPUB个人空间k(zg9kG\!T
ARC0 started with pid=38, OS id=23914ITPUB个人空间(C7`^ Q||
Tue Aug  4 18:00:51 2009ITPUB个人空间SYj#O wV{-s.C7_
ARC0: Archival startedITPUB个人空间p-wkE.CH W u O
ARC1: Archival started
,Q \]g~[P3hs235507LGWR: STARTING ARCH PROCESSES COMPLETEITPUB个人空间RF7\\Z/m2}8I]
ARC1 started with pid=9, OS id=23945ITPUB个人空间w%^SY+kgYk"j
Tue Aug  4 18:00:52 2009
gw]K;Y3t235507Thread 1 opened at log sequence 3316ITPUB个人空间'y|!D`S$ox }-R
  Current log# 4 seq# 3316 mem# 0: /dev/vx/rdsk/datadg/tradedb_redo1_4_1_1g
8\i3EZ?A2jqK{235507  Current log# 4 seq# 3316 mem# 1: /dev/vx/rdsk/datadg/tradedb_redo1_4_2_1gITPUB个人空间 _Rb#@'Oa(ut
Successful open of redo thread 1ITPUB个人空间#\g g!Zi4N[2e
Tue Aug  4 18:00:52 2009
wApc+ta235507MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setITPUB个人空间,r |jj#G'q"e
Tue Aug  4 18:00:52 2009
B-bD9@i Y$V-U.W C235507ARC1: Becoming the 'no FAL' ARCH
u;oD V?R235507ARC1: Becoming the 'no SRL' ARCH
~ e4ux4c j_U235507Tue Aug  4 18:00:52 2009
A*k2AS h`1bq%Y235507ARC0: Becoming the heartbeat ARCHITPUB个人空间Ts yZH@
Tue Aug  4 18:00:52 2009ITPUB个人空间YfF QQ
SMON: enabling cache recoveryITPUB个人空间;Nd4p)P"a,F+TQ J\
Tue Aug  4 18:00:56 2009
4XvQU5a;~?$Pm235507Successfully onlined Undo Tablespace 1.
/{j]nHIS#M235507Tue Aug  4 18:00:56 2009
&R0{_D8WI235507SMON: enabling tx recoveryITPUB个人空间H1X zk n?t(i
Tue Aug  4 18:00:56 2009ITPUB个人空间}Wr@*Y _
Database Characterset is ZHS16GBK
&CR(F kZS9rr,}235507replication_dependency_tracking turned off (no async multimaster replication found)ITPUB个人空间d o3O3s$W7]0P$J
Starting background process QMNCITPUB个人空间z!J Ey#{
QMNC started with pid=40, OS id=24094ITPUB个人空间Z_(zdH} b
Tue Aug  4 18:01:00 2009ITPUB个人空间f0m}z)GS.Y x(l
Completed: ALTER DATABASE OPEN

采用这种方式系统不会重启：

SQL> select sysdate from dual;

SYSDATE
qH$OEF#C,je&a&U235507-------------------
0I0Xc%R b/`2u(O0h2355072009-08-04 17:43:16

SQL> select instance_name, startup_time from gv$instance;

INSTANCE_NAME    STARTUP_TIME
1?_K W#jl d!f235507---------------- -------------------ITPUB个人空间 c:F8Pds v8pxRY
testrac2         2009-05-22 18:04:16
sh!j8z ~4Q}8K235507testrac3         2009-08-04 17:28:55

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/235507/viewspace-616706/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/235507/viewspace-616706/