ࡱ> `!3Ѳxͪn @_(>xcdd`` "@ X>(b09M~3uİ,XAB312urBTAEH!68DΡ M-VK-WM̃a0t_ZZ2, (`!z6w͝D 8^HxXOG~`džІ` QZ~DIVU lҕNK$F+CoUʥ^z Rɍ}of3+ϻf}fV$ah宋0Ǹ|n¢Vkջ'OteǩKxa-6_:+ᩉAc~~sFg]*7טNدϲ( t1 yqjiT+_-xF6nƺq_3fS;]#p= \Ҽh!Ad}~d!Epu )=_O?l)g=K bHU,6Qw!t{.g=Kw'b&Q>߾G}|-Ou9Iܙ™,>Bz pjuY_7s9A52q+\Cr(S Z]έ.86 #0U/ Sr>s-B:[ S !h솒cW*+Gk'3Y?֝?" dU@$`b|?" xd @  dd`8 n?" dZ(@   @@``PR    @ ` ` p>> (     ` bgֳgֳ ?``  X*   `cgֳgֳ ?`   <    `@igֳgֳ ?`   Z*pB  Hp?x   Zkgֳgֳ ?HH|  ? Slide Title  #  Togֳgֳ ?  ;Body Text Second Level Third Level Fourth Level Fifth Level     <  Ttsgֳgֳ?Q Z*H  0޽h? ? ( PowerPointu 0 5-P( (   TjJjJ ?G    R*    T jJjJ ?    T*    Z jJjJ ?`G   R*    ZXjJjJ ?`   T*    TUU?oyW  ~ Page *Z  ###55FFp  01 ?  #  TPgֳgֳ ? 6  ;Body Text Second Level Third Level Fourth Level Fifth Level     <H  0sTh? ? a( ` Z(     TjJjJ ?G    \*   TpjJjJ ?    ^*   ZtjJjJ ?`G   \*   ZjJjJ ?`   ^*   TxUU?oyW   Page *Z ###55FFH  0sTh? ? a( % IA0(     fgֳgֳ ? 0    ZLgֳgֳ ?@  YHigh-Availability and Scalability Options for Oracle Paper #112 A Discussion of Architectural Options for the Database Server Tier Tim Gorman Principal, Evergreen Database Technologies, Inc.|5( (B((t&  1  s lgֳgֳ ?l@  " d`8H  0޽h ? (.   % pZ( x   # lgֳgֳ ? HH|     THgֳgֳ ?` 0 JOverview of the major architectural options: buy a bigger box! distributed databases replication standby database OS failover storage-array/OS failover Oracle Parallel Server Transaction-processing monitors (TPM)&--,u  =  Tgֳgֳ ?`@  Requirements and goals: higher availability scalable performance minimize cost and complexity minimize mean-time-to-repair (MTTR) enable disaster-recovery enable rolling upgrades and patches&H  0޽h ? (  6( x l  C L HH|   l  C |     Tgֳgֳ ?  4HA = 1 Scale = 1 MTTR = 1 COST = 1 D/R = 0 R/Upg = 0 54-H  0޽h ? (  U( x l  C  HH|   l  C     5  Tgֳgֳ ?  5HA = 1 Scale = 2 MTTR = 1 COST = 2 D/R = 0 R/Upg = 0 >6 #-H  0޽h ? (5  u( @ r  S  HH|   r  S @0D   I  Ttgֳgֳ ?  7HA = 0 Scale = 1.5 MTTR = 1 COST = 2 D/R = 0 R/Upg = 0 P8 /H  0޽h ? (  <4(  l  C p HH|     Z=?p >Server 1    T=? @  :DB 1  Z\=?p P >Server 2    T@=? @@  :DB 22   N@?`@ p <Client2   N@?` p <ClientB  @ ZD)?p B   ZD)?P `P B  @ ZD)?p0 B  ZD)?p  B @  `D)?@00 ` B @  `tD)?@` B   `D)?P 0   Z@=?K GRead/Write activity  Z@=?L $ GRead/Write activity  Z@=? D  l8Synchronous data propagation using triggers and db links99v2  N=? P v2  N=?  v2  N=?`  v2  N=?0  v2  N=? P v2  N=?  v2  N=?`  v2  N=?0  H  0޽h ? (L  ( zdT r  S @ HH|  @    `@gֳgֳ ?D @   T@gֳgֳ ?  4HA = 2 Scale = 2 MTTR = 2 COST = 3 D/R = 1 R/Upg = 1(54-H  0޽h ? (  $(   r  S %@ HH|  @ r  S T&@`P  @ H  0޽h ? (  3(  l  C *@ HH|  @   Z.@=?p >Server 1    T4@=? @  :DB 1  Z7@=?p P >Server 2    Tt;@=? @@  :DB 22  N @?`@ p <Client2   NB@?` p <ClientB    `D)? ` B   ZD)?p  B @  `D)? `   ZE@=?,  m  W#Asynchronous propagation of changes$$  ZJ@=?$K GRead/Write activity  ZXN@=?,pP GRead/Write activityB @ ZD)?p B @  `D)?@ ` B   `7ND)?P 0 v2  N=? P v2  N=?  v2  N=?`  v2  N=?0  v2  N=? P v2  N=?  v2  N=?`  v2  N=?0  H  0޽h ? (2  r( l` r  S \V@ HH|  @ r  S W@0 0 @ F  TLX@gֳgֳ ?   4HA = 2 Scale = 1 MTTR = 1 Cost = 1 D/R = 1 R/Upg = 0P5 -H  0޽h ? (  7(  l  C a@ HH|  @   Zb@=?p >Server 1    Ti@=? @  =Primary  Zl@=?p`  >Server 2    Tdd@=? @@  =Standby2  Ns@?` p <Client2   Nv@?` p <ClientB  @ ZD)?p@@ B    `D)?  B    fbLD)?p 0 B @  `D)?@pp`   Zz@=?&jK GRead/Write activity  ZI@=?0l QOccasional Read-Only activity  Z@=?, t  k7Archived redo log file shipping - automated in Oracle8i88  Z0@=?@ <. b.redo log file recovery - automated in Oracle8i//v2  N=? `0P v2  N=? `0 v2  N=?` `0 v2  N=?0 `0 v2  N=? P v2  N=?  v2  N=?`  v2  N=?0  H  0޽h ? (  NF ( 4ѹ x r  S H@ HH|  @    `@gֳgֳ ?0@P @ p  T@gֳgֳ ?   4HA = 2 Scale = 1 MTTR = 1 Cost = 2 D/R = 0 R/Upg = 0z5  -H  0޽h ? (   w o 0 (  l  C @ HH|  @   ZX@=?p  >Server 1    T@=?  @  =Primary  ZԦ@=?p @ >Server 2    # lt@=o? 0@  =Standby2  N(@?` p <ClientB  @ ZD)?p@@ B  @  `D)?@pp ` B   `D)?p0 @ v2  N=?P v2  N=? v2  N=? v2  N=? P   Z,@=?` K GRead/Write activity  Z,@=? `d JFail-over connectivityH  0޽h ? (|  ,$@(  r  S м@ HH|  @    `@gֳgֳ ?0@ @ N  T@gֳgֳ ?   4HA = 2 Scale = 1 MTTR = 1 Cost = 4 D/R = 1 R/Upg = 1X5-H  0޽h ? (U     P (  r  S @ HH|  @   Z@=?p  >Server 1    T@=? p@  =Primary  Z@=?p P >Server 2    # lh@=o? @@  =Standby2   N@?` p <ClientB  @ ZD)?p @ 0 B  @  `D)?@Pp B    `D)?p0 0 v2  N=?Pv2  N=? v2  N=?`v2  N=?0v2  N=?Pv2  N=? v2  N=?`v2  N=?0B   `D)?  Zx@=?` K GRead/Write activity  Zx@=? @d JFail-over connectivityH  0޽h ? (  `H( x l  C @ HH|  @ l  C @  @ (  T @gֳgֳ ?   4HA = 2 Scale = 2 MTTR = 2 COST = 4 D/R = 0 R/Upg = 025#-H  0޽h ? (0     pp (  l  C @ HH|  @   Z@=?p  >Server 1    T@=?  @  :DB 1  Z$B=?p @ >Server 2  2  NB?` p <ClientB  @ ZD)?p@@ B  @  `D)?@pp ` v2   N=?P v2  N=? v2  N=? v2  N=? P   TB=? `@  :DB 2B  ZD)?p  B   `D)? 0   ZB=?\K GRead/Write activity  ZB=?< d GRead/Write activityH  0޽h ? (:  z(  r  S B Hp|  B `  c $A ??pp  `  c $A ??S/ H  0޽h ? (   $(  r  S  HH|   r  S L0   H  0޽h ? (  ( $@ l  C \B HH|  B l  C B B H  0޽h ? (  $(  r  S "B HH|  B r  S D#B B H  0޽h ? (D 0 @(     H1 ?      f4-gֳgֳ ? 6    H  0sTh ? a( 0 (  X  C      S p 6    H  0sTh ? a((Px\mlSU~Jʄ鸌$ea(\ٜ1 ?Ԑnٮ #?4A4>"jbb%~`Ԙ8Cb`}9m@<|{>z{s;r|`D 0&ID24 wnx3ځB܅F)C̐iCfT܇2ez|( Q/Itt/AAYR eLp1$@0:{KceS"՜{?)fCf)!lۓoR7B7:*Hk )_O|? =_"O5,<Ӥzej.޻`b/ G#ƾu) v$v=|Oٴ0OrkںwMoܳqM~AG[pY Qd<K+rgT_:GɿZluс+Q v]X]nr;d2(3J+F&k:~{a/ad35/LUQwj;4ep8$u7B0@u_t5XӘ˩9\2T}m9[D?˹NFi;;,] ~0uoW;٫"DgcFP9ON |_:=oA%#Gm=#TAAAAAAAAAAគ`CЋNG _QNtRϖ} m$ۉ:$7OWIQY{aճ1[@ _N_=Yrvd/#Xe)b+dد2'I!Zyp44D^@-(}yD=+D].3o 8Of4S <˿JA;6CxVj#| OQ_b Hҟ&/ 7B]H:F/d˧~:\fk_6M,XFz+Bz>]}/~1^w)foAKv.3K]xzsBoLP(.@{?RYa x[(OaWƽ/-Sa6RNBZ6ioFIG'0zi1=S)*4l,ţVc,ujP8EY6ZZ*((YL$qdʄ2ҡ7>| u|3r&R'ܷA=h N ^~Ww /WH/'L~&NO& r&o@`\KppTo9i0A"͕l>"=rmm=vԗ=1S!wW}y6iʬZAAAAAAAAAAAAAvq(k4\.U(l?C!οS[n[y9,aL7}7"n6$n4 ."h Dٗ 롿߸;@0 Po@, zay+8>tTˆuPFeCwmllk{=jY3Zqn`ލ( }M?XGu(F& kESP 9  ?* lx\ l371N`uX4a;?%v$NJ#q6Ɇ׬7Bզ *UJ Wi-DEjT`TҔPfvow8޽ͻ}챗.8ofZC}KڒONɝv.4מWV[Wyc5!Z7Po#G(R7s FzvXflLy-beŖPc-}Z!9h/Ѷ&asmfMKS2UdN2\sT٫h >ַKSm9N@@HGfZ2_+sΖ +>)1M!$'%{(7.M%DZ]Oifr$Υ)SY1Teݶs-uz[|BsL$ر}X4 XCsn3|9gP"=4k:ض/gtS)?d\g샳uSS>Xe,՜>4C$'%mypErz0MAEjdߙ|wu#~͢gBZsNx]x+)c%-S2v"؍8{UVh^g~Ŝg~Ŝg{挕ʽ)u:ؿP_rR[ҤbU>Cxk߮ꯒ EaW]sD,.?9^>]Ii>Ȝ4.|pxB|pP67 9ŭ/Ӽfx|ãJ|q8cg̑3ܕSG=p#Ϙ#40g]x( G=8$BE*9ˈG/#uOƜٓxy9[#_SYb {TII-d'6lU}@8 {c/:szqe|9$SIZn(Z7⸻;HJ0KyH~%ȧe'=$&-XMLnF|cXg(RsHͧIdC+Eu^hzh!ފBx=Ѝ|J%eKjz:e}R rX$0;jgՇjB^m?Ooek!ͧپŔ_m&fwS&Qdci[kvL1`08#-2$o gQ~3M+OD KC莟c -TEN?oXcVҮaS0LIfeYUu;%r%2`9:p (:0 X'z`% ^x7+o+/ꩲuNM$knI1 !uKY9y3y۔`0 .6a#,[ `e7:4''3cNd`Ц4{Q2;E/=^CfT>_{s)ػTɵȘhxC~~Oƕ/:ƘycoMs;rkY 42EI:wO]i^="Uib_bhr>64zWyQtN?㩉$g_ɳ5g+y,|8]ayr֓ iiVrkNVrg񿪖f9e)5: 9Mvǣ3< ?ؼwy{ˏj7! dԘ #ϐ|/OT?H?BwX?_2M>߬Е^M'*}vX6~|(7v:x1׳E?[Yֹd~MpRQ!a#jK.K.K.KE޴7{ |߿ʝ?Y֟-r ッ^*.Mo8nñ$c5+:L2Sq# '[y)pИc)+d9t7il#zݍx8<|x=vEC7-䌳id'SZWJ묆FpRt2䷘+]umlnÖmɖ F Պe&o6Zh]#,o=ҕgy\r%\r%\r%HrPF7N;9T24 TPY:aWd(x|{c:|<^gh}BhH@ZOh+'0H  ,8D Xd    )Oracle High-Availability and ScalabilityMi8Discussion of Architectural Options for the Server-Tier Tim Gormanoim im im  Tim Gormano58 Microsoft PowerPoint 4.0al @8%]RH@Fg/s@R@;,Gx g  O& &&#TNPPl2OMi & TNPP &&TNPP    - "-- !-- "-&G& - &Gy& &{-(- $||--&-- -- @"Arial- . 2  1.--u -- @Times New Roman- . 2 RIOUG2.2. . 2 Rp-. . 2 RA ..@Times New RomanJ- .2 RLive ' .@Times New RomanJ- . 2 R2001 .--$ -- @Times New Roman- . 2 mHigh). . 2 -. .12 Availability and Scalability& . ."2 Options for Oracle)  ).@Times New Roman- .2 gk Paper #112 .@Times New Roman- .?2 %A Discussion of Architectural Options           . .12 for the Database Server Tier         .@Times New Roman- .2 D Tim Gorman  . .O2 e0Principal, Evergreen Database Technologies, Inc.           .--y`-- @BComic Sans MS- . 2 www. . .2 EvDBT . . 2 .Com  .--"System-&TNPP &Z՜.+,D՜.+,   $,4 < RLetter Paper (8.5x11 in)e&Evergreen Database Technologies, Inc.t Times New RomanArialComic Sans MS Courier New PowerPointMicrosoft Word DocumentIOUG-A Live 2001AgendaAgendaBuy a bigger box!Distributed databasesDistributed databases Replication Replication ReplicationOracle Standby databaseOracle Standby database OS Failover OS FailoverStorage-array/OS FailoverStorage-array/OS FailoverOracle Parallel ServerOracle Parallel ServerMatrixSummarySummary Questions?  Fonts UsedDesign TemplateEmbedded OLE Servers Slide Titles( 8@ _PID_HLINKSA http://www.evdbt.com/#http://www.evergreen-database.com/"_ Tim GormanTim Gorman  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root EntrydO)PicturesCurrent UserSummaryInformation(PowerPoint Document(DocumentSummaryInformation8