1 Oracle RAC Copyright 2004 Oracle All rights

  • Slides: 25
Download presentation
1 Oracle RAC 原理浅谈 Copyright © 2004, Oracle. All rights reserved.

1 Oracle RAC 原理浅谈 Copyright © 2004, Oracle. All rights reserved.

纲要 Oracle RAC 原理简介 RAC部署技巧及维护注意事项 1 -2 Copyright © 2004, Oracle. All rights reserved.

纲要 Oracle RAC 原理简介 RAC部署技巧及维护注意事项 1 -2 Copyright © 2004, Oracle. All rights reserved.

纲要 Oracle RAC 原理简介 RAC部署技巧及维护注意事项 1 -3 Copyright © 2004, Oracle. All rights reserved.

纲要 Oracle RAC 原理简介 RAC部署技巧及维护注意事项 1 -3 Copyright © 2004, Oracle. All rights reserved.

Oracle基础架构 User process Shared Pool Library Cache Server process Data Dictionary Cache Instance SGA

Oracle基础架构 User process Shared Pool Library Cache Server process Data Dictionary Cache Instance SGA Database Buffer Cache Redo Log Buffer Java Pool Large Pool PGA PMON SMON DBWR LGWR Data files Parameter file Control files CKPT Redo Log files Password file Database 1 -4 Copyright © 2004, Oracle. All rights reserved. Others Archived Log files

双节点Oracle RAC架构 A LMS 1 -5 B LMD LMON LCK 0 Copyright © 2004,

双节点Oracle RAC架构 A LMS 1 -5 B LMD LMON LCK 0 Copyright © 2004, Oracle. All rights reserved.

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色：

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色： Local，Global 1 -7 Copyright © 2004, Oracle. All rights reserved.

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色：

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色： Local，Global 1 -8 Copyright © 2004, Oracle. All rights reserved.

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色：

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色： Local，Global 1 -9 Copyright © 2004, Oracle. All rights reserved.

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色：

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色： Local，Global 1 -10 Copyright © 2004, Oracle. All rights reserved.

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色：

Cache Fusion 示例 数据块属性 状态： PI, CR, SCUR, XCUR 访问模式： NULL, S, X 角色： Local，Global 1 -11 Copyright © 2004, Oracle. All rights reserved.

Oracle RAC 发展史 简称 简单描述 8 i OPS Oracle Parallel Server 9 i 10

Oracle RAC 发展史 简称 简单描述 8 i OPS Oracle Parallel Server 9 i 10 g 11 g R 2 1 -12 RAC Real Application Cluster 启动 共享 存储 IP 数据 同步 手动 Raw Public Private Rac Ping 手动 Raw Ocfs Public Private 自动 Raw Ocfs 2 Asm Public Private Host-vip 自动 记录状态 Raw Ocfs 2 Asm Public Private Host-vip Scan-vip Copyright © 2004, Oracle. All rights reserved. Cache Fusion 新特性 Service 冗余 Grid 用户 Server Pools

Oracle RAC 技术特性 1－高性能 负载均衡/并行处理 LAN High Speed Interconnect Fiber Channel or Shared SCSI

Oracle RAC 技术特性 1－高性能 负载均衡/并行处理 LAN High Speed Interconnect Fiber Channel or Shared SCSI Single Database l 大用户量的并发访问分担到多台节点机上并行处理 l 单个用户重负载的运算分担到多个节点机上做并行处理 1 -14 Copyright © 2004, Oracle. All rights reserved.

Oracle RAC 技术特性 3－易扩展 具有高度的可扩展性 Node A Node B Node C 节点 C &

Oracle RAC 技术特性 3－易扩展 具有高度的可扩展性 Node A Node B Node C 节点 C & D 加入OPS/RAC集群, 最大可扩展到个？节点 1 -16 Copyright © 2004, Oracle. All rights reserved. Node D

Oracle RAC 数据保护的延伸－DG Standby Server 上海 1 -18 Standby Database l l 物理备份 逻辑备份

Oracle RAC 数据保护的延伸－DG Standby Server 上海 1 -18 Standby Database l l 物理备份 逻辑备份 l l l 最大保护模式 最大可用模式 最大性能模式 Log Delayed Apply Files Primary Server Production Log write Database 北京 Copyright © 2004, Oracle. All rights reserved.

纲要 Oracle RAC 原理简介 RAC部署技巧及维护注意事项 1 -19 Copyright © 2004, Oracle. All rights reserved.

纲要 Oracle RAC 原理简介 RAC部署技巧及维护注意事项 1 -19 Copyright © 2004, Oracle. All rights reserved.

RAC部署技巧及维护注意事项 客户端连接配置后时断时通！！ RAC = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =

RAC部署技巧及维护注意事项 客户端连接配置后时断时通！！ RAC = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192. 168. 0. 1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192. 168. 0. 2)(PORT = 1521)) (LOAD_BALANCE = yes) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac) ) HOST=node 1 ) HOST=node 2 1 -21 /etc/hosts或DNS 192. 168. 0. 1 node 1 192. 168. 0. 2 node 2 Copyright © 2004, Oracle. All rights reserved.

RAC部署技巧及维护注意事项 RAC自身实现数据冗余！！ 1 -22 Copyright © 2004, Oracle. All rights reserved.

RAC部署技巧及维护注意事项 RAC自身实现数据冗余！！ 1 -22 Copyright © 2004, Oracle. All rights reserved.

RAC部署技巧及维护注意事项 11 g. R 2新特性－scan-vip ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST

RAC部署技巧及维护注意事项 11 g. R 2新特性－scan-vip ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =scan-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) DNS primary Scan-vip 192. 168. 0. 1 双DNS解析 client DNS 2 1 -23 Scan-vip standby 192. 168. 0. 2 Copyright © 2004, Oracle. All rights reserved.

纲要 Oracle RAC 原理简介 RAC部署技巧及维护注意事项 1 -24 Copyright © 2004, Oracle. All rights reserved.

纲要 Oracle RAC 原理简介 RAC部署技巧及维护注意事项 1 -24 Copyright © 2004, Oracle. All rights reserved.

Q& A Q U E S T I O N S A N S

Q& A Q U E S T I O N S A N S W E R S 1 -25 Copyright © 2004, Oracle. All rights reserved.

1 Oracle RAC Copyright 2004 Oracle All rights1 Oracle RAC Copyright 2004 Oracle All rights
RAC Backup u RAC u Oracle File uRAC Backup u RAC u Oracle File u
RAC Backup u RAC u Oracle File uRAC Backup u RAC u Oracle File u
RAC Deployment Workshop Copyright 2007 Oracle All rightsRAC Deployment Workshop Copyright 2007 Oracle All rights
RAC be Nimble RAC be Quick Bert ScalzoRAC be Nimble RAC be Quick Bert Scalzo
RAC Electric Highway The RAC are funding theRAC Electric Highway The RAC are funding the
RAC ortamnda yazlm gelitirme TROUG RAC SIG etkinliiRAC ortamnda yazlm gelitirme TROUG RAC SIG etkinlii
RAC be Nimble RAC be Quick Bert ScalzoRAC be Nimble RAC be Quick Bert Scalzo
RAC be Nimble RAC be Quick Bert ScalzoRAC be Nimble RAC be Quick Bert Scalzo
RAC Region IV Report RAC Region IV StateRAC Region IV Report RAC Region IV State
NW RAC 101 Dec 8 2016 BLM RACNW RAC 101 Dec 8 2016 BLM RAC
DAmo RAC DAmo DB RAC DAmo 1 DBDAmo RAC DAmo DB RAC DAmo 1 DB
Monitoring and Diagnosing Oracle RAC Performance with OracleMonitoring and Diagnosing Oracle RAC Performance with Oracle
NEW Oracle Real Application Clusters RAC and OracleNEW Oracle Real Application Clusters RAC and Oracle
Oracle 10 g on Solaris to Oracle RACOracle 10 g on Solaris to Oracle RAC
11 Oracle Database Security Copyright 2004 Oracle All11 Oracle Database Security Copyright 2004 Oracle All
12 Oracle Net Services Copyright 2004 Oracle All12 Oracle Net Services Copyright 2004 Oracle All
Factor Oracle Suffix Oracle Factor Oracle Suffix OracleFactor Oracle Suffix Oracle Factor Oracle Suffix Oracle
Oracle Oracle Oracle Oracle 1977Software Development LaboratoriesSDL 1979RelationalOracle Oracle Oracle Oracle 1977Software Development LaboratoriesSDL 1979Relational
14 Producing Triggers Copyright 2004 Oracle All rights14 Producing Triggers Copyright 2004 Oracle All rights
6 Diagnostic Sources Copyright 2004 Oracle All rights6 Diagnostic Sources Copyright 2004 Oracle All rights
8 Manipulating Data Copyright 2004 Oracle All rights8 Manipulating Data Copyright 2004 Oracle All rights
10 Creating Triggers Copyright 2004 Oracle All rights10 Creating Triggers Copyright 2004 Oracle All rights
1 Introduction Copyright 2004 Oracle All rights reserved1 Introduction Copyright 2004 Oracle All rights reserved