登录
首页 » Others » ORACLE高可用性(RAC)技术应用解决方案基于成熟的生产环境

ORACLE高可用性(RAC)技术应用解决方案基于成熟的生产环境

于 2020-12-03 发布
0 392
下载积分: 1 下载次数: 1

代码说明:

ORACLE高可用性(RAC)技术是如何应用于基于成熟的生产环境的一个解决方案美河学习在线基础知识介绍1.RAC是什么,全称,译为“实时应用集群”,是新版数据库中采用的一项新技术,是高可用性的一种,也是数据库支持网格计算环境的核心技术。2.RAC的优缺点优点:主要支持版本,可以支持有效的数据库应用系统,在低成木服务器上构建高可用性数据库系统,并且自由部署应用,无需修改代码。在环境下,集成提供了集群软件和存储管理软件,为用户降低了应用成本。当应用规模需要扩允时,用户可以按需扩展系统,以保证系统的性能。多节点负载均衡提供高可用:故障容错和无缝切换功能,将硬件和软件错误造成的影响最小化通过并行执行技术提高事务响应时间通常用于数据分析系统通过橫冋扩展提髙每秒交易数和连接数通常对于联机事务系统节约硬件成本,可以用多个廉价服务器代替昂贵的小型机或大型机,同时节约相应维护成本可扩展性好,可以方便添加删除节点,扩展硬件资源。缺点相对单机,管理更复杂,要求更高可能会增加软件成本如果使用高配置的服务器,般按照个数收费美河学习在线3. Oracle rac原理在一个应用环境当中,所有的服务器使用和管理同一个数据库,目的是为了分散每一台服务器的工作量,硬件上至少需要两台以上的服务器,而且还需要个共享存储设备。同时所有服务器上的都应该是同一类根据负载均衡的配置策略,当一个客户端发送请求到某一台服务的后,这台服务器根据我们的负载均衡策略,公把请求发送给本机的组件处理也可能公发送给另外一台服务器的组件处理,处理完请求后,会通过集群软件来访问共享存储设备逻辑结构上看:每一个参加集群的节点有一个独立的访问同一个数据库。每一个节点的都有自己的每一个节点的都有自己的每个节点的都有自己的每一个节点的都有白己的表空间。所有节点都共享一份和三类虚拟地址集群注册文件记录每个节点的相关信息仲裁机制用于仲裁多个节点向共享节点同时写的行为,这样做是为了避免发生冲突。美河学习在线存储技术介绍独立冗余磁盘阵列(是一种把多块独立的硬盘(物理硬盘)按不同的方式组合起来形成一个硬盘组(逻辑硬盘),从而提供比单个硬盘更高的存储性能与数据备份能力的技术。特色是玦硬盘冋时读取速度加快及提供容错性可以将分为不同级別,级別并不代表技术高低,选择哪一种产品纯视用户的操作环境及应用而定,与级别高低没有必然关系。:无差错控制的带区组RAID OBDFGHMNO etc要实现必须要有两个以上硬盘驱动器,数据并不是保存在一个硬盘上,而是分成数据块保存在不同驱动器上。因为将数据分布在不冋驱动器上,所以数据吞吐率大大提高,驱动器的负载也比较平衡。它的缺点是它没有数据差错控制,如果一个驱动器中的数据发生错误,即使其它盘上的数据正确也无济于事了。不应该将它用于对数据稳定性要求高的场合。在所有的级别中,的速度是最快的。但是没冇冗余功能的,如果…个磁盘(物理)损坏,则所有的数据都无法使用美河学习在线:镜象结构RAID 1B-BGG0DDHH对于使用这种结构的设备来说控制器必须能够同时对两个盘进行读操作和对两个镜象盘进行写操作。镜象结构是在一组盘岀现问题时,可以使用镜象磁盘,提高系统的容错能力。每读一次盘只能读岀一块数据,也就是说数据块传送速率与单独的盘的读取速率相同。当您的系统需要极高的可靠性时,如进行数据统计,那么使用比较合适。而且技术支持“热替换”,即不断电的情况下对故障磁盘进行更换,更换完毕只要从镜像盘上恢复数据即可。当主硬盘损坏时,镜像硬盘就可以代替主硬盘工作。镜像硬盘相当于一个备份盘,这种硬盘模式的安全性是非常高的,的数据安全性在所有的级别上来说是最好的。但是其磁盐的利用率却只有是所有级别中最低的。:分布式奇偶校验的独立磁盘结构RAID 5A Blocks B Blocks C Blocks D Blocks E BlocksA0 Co D0 parityParitGenerationA1B1(A2 B2arity D2 E2A3 3 parity C3 E34p(B4(40(E4将数据分散存放于多个硬盘上面,同时使用一定的编码技术产生奇偶校验码来提供错误检査及恢复能力,数据段的校验位交互存放于各个硬盘上。因为奇偶校验码在不同的磁盘上,所以提高∫可靠性,允许单个磁盘出错。任何一个硬盘损坏,都可以根据其它硬盘上的校验美河学习在线位来重建损坏的数据。硬盘的利用率为。优点是提供了冗余性(支持一块盘掉线后仍然正常运行),磁盘空间利用率较高(),读写速度较快(倍)。是级别中最常见的一个类型:高可靠性与高效磁盘结构RAID 10BBBDFHmIrroringstriping这种结构是一个带区结构加一个镜象结构,因为两种结构各有优缺点,因此可以相互补允,达到既高效又高速还可以互为镜像的目的。大家可以结合两种结构的优点和缺点来理解这种新结构。这种新结构的价格高,可扩充性不好。主要用于容量不大,但要求速度和差错控制的数据库中。RAID10是先镜射再分区数据。是将所有硬盘分为两组,然后将这两组各自视为RAID1运作。RAID10有着不错的读取速度,而且拥有比RAID0更高的数据保护性。美河学习在线系统结构设计1.RAC系统拓扑结构基本如下图所示:核心交换机SUNT44数据库raNT4/4数据库rac2面出HSUNSANRAC心跳RAC心跳EMC VNX 5300美河学习在线2.主机操作系统系统数据库服务器系统规划用户组规划说明0 racle清单和软件所有者Oracle自动存储管理组ASM数据库管理员组ASM操作员组数据库管理员用户规划说明默认口令用户数据管理员主机文件系统规划物理硬盘数文件系统AD方式「挂载点文件系统大小/homeufs70GB8水300GB(文件系统用300Gswapswap30GBuf200GB美河学习在线3.存储规划存储一般采用存储方式。硬盘总物理大RAID方逻辑大小(可用 Hotspare数式空间大小)15TB存储组件/BokASMIib NameSizeComments系统路径Device/dev/sda OCR VOL1100G OCR and Voting /dev/oraclOCR/dev/sdb OCR VOL2100GDiskseasm/ORCdev oracl数据文件|/dev/ sdb DATA VOLL3T ASM Data Diskgroup easm/DATAVOIASM/dev/orac l文件备份/dev/ sdaBACK VOL11.8T RecoveryBackup easm/BACKDiskgrou备注存储暂用4.数据库RAC环境数据库规划环境信息节点名称实例名称处理器内存操作系统数据库版本软件组件软件组件名称用户主组辅组用户目录基目录

下载说明:请别用迅雷下载,失败请重下,重下不扣分!

发表评论

0 个回复

  • 基于QT的图书管理系统
    基于QT的图书管理系统:QT界面设计,有嵌入式数据库的后台支持
    2020-12-05下载
    积分:1
  • QT TCP文件传输
    我做的一个TCP文件传输的工具,可以在网络上传输任意大小的文件,最近在学习QT,希望有兴趣的朋友一起交流一下。如果对这个工具的代码有什么建设的发个邮件给我heqiangpc@sohu.com谢谢了。
    2020-12-02下载
    积分:1
  • 不平衡数据集的几种处理序SMOTE等
    关于在不平衡数据集中需要用到的一些欠采样过采样的方法,SMOTE等算法的实现及其示例。
    2020-12-11下载
    积分:1
  • RTCM3.3协议全
    全新RTCM3.3协议完整版RTCM STANDARD 10403.3DIFFERENTIAL GNSS(GLOBAL NAVIGATION SATELLITE SYSTEMS)SERVICES – VERSION 3DEVELOPED BYRTCM SPECIAL COMMITTEE NO. 104OCTOBER 7, 2016COPYRIGHT©2016 RTCMRadio Technical Commission for Maritime Services1611 N. Kent St., Suite 605Arlington, Virginia 22209-214RTCM Paper 141-2016-SC104-STD000ocRTCMco00c30RTCM 10403. 3, Differential GNSS Global Navigation Satellite Systems)Services- Version 3, October 7, 2016This standard (referred to as version 3 has been developed by rtCm special Committee 104 as a moreefficient alternative to the standards entitled rtcm recommended standards for diffe rentialRecommended Standards for Differential gNss Global Navigation Satellite Systems Service, Version 2.x(Current version is 2. 3, now designated as RTCM 10402. 3. Service providers and vendors represented onthe SC104 Committee wanted a new standard that would be more efficient, easy to use, and more easilyadaptable to new situations. The main complaint was that the version 2. x parity scheme, which useswords with 24 bits of data followed by 6 bits of parity, was wasteful of bandwidth. Another complaint wasthat the parity was not independent from word to word. Still another was that even with so many bitsdevoted to parity the actual integrity of the message was not as high as it should be. Plus, 30-bit wordsare awkward to handle. the new standard version 3 is intended to correct these weaknessesUnlike Version 2. x, this standard does not include tentative messages The messages in Version 3 haveundergone testing for validity and interoperability and are considered to be permanent. amendments tothe standard may change the meaning of reserved bits or provide additional clarifying text, but no changeswill be made in the data fields. Changes will require new messages to be developed. In addition to themessages described in the current standard the committee continues to develop new messages whichare described in separately published amendments and periodically gathered into a new edition of thestandard. RTCM 10403x for dgNSS services is proving useful in supporting highly accurate differentialand kinematic positioning as well as a wide range of navigation applications worldwideNote that Version 3 messages are not compatible with Version 2. x. Since many receivers have beendesigned and programmed for use with Version 2. x messages, rtCm is maintaining both standards0402 3 and 10403, 3 as" standardsVersion 3.0The initial edition consisted primarily of messages designed to support real-time kinematic (RTK)operations. The reason for this emphasis is that rtk operation involves broadcasting a lot of informationand thus benefits the most from an efficient data format. Version 3.0 provided messages that supportGPS and gloNaSs rTK operations including code and carrier phase observables antenna parametersand ancillary system parametersVersion 3. 1(RTCM Standard 10403.1:The next edition, Version 3. 1 (RTCM Standard 10403. 1), incorporated GPS Network Corrections, whichenable a mobile receiver to obtain accurate rtk information valid over a large area. In addition, new GPSand GLoNaSS messages provide orbital parameters to assist in rapid acquisition a Unicode text messageis also provided for the transmission of textual data. Finally a set of messages are reserved for vendorswho want to encapsulate proprietary data in their broadcasts the gps Network Corrections enable amobile receiver to obtain accurate rtk information valid over a large area. the network rtk correctioninformation provided to a rover can be considered as interpolated corrections between the referencestations in the rtk network this interpolation is not perfect and varies with the actual conditions of theatmosphere. A residual interpolation error has to be expected. With sufficient redundancy in the RtKnetwork, the network server process can provide an estimate for residual interpolation errors. Suchquality estimates may be used by the rover to optimize the performance of rtk solutions The values maybe considered by the rover as a priori estimates only with sufficient tracking data available the rovermight be able to judge residual geometric and ionospheric errors itselfVersion 3. 1. Amendment 1:Amendments 1 was an extensive addition that adds rtcm messages containing transformation data andinformation about Coordinate reference Systems. For rtCm data supporting a rtk service, coordinatesare measured within the itrf or a regional realization surve yors and other users of rtk services mustnormally present their results in the coordinates of local datums. Therefore, coordinate transformationsare necessary. by having RTCM messages that contain transformation data and information about theCoordinate reference systems the users of the rtk service can obtain their results in the desired datumwithout any manual operations. the rtk service providers can then ensure that current information forthe computation of the transformations is always used. the convenience of this method will promote theacceptance of rtK servicesVersion 3. 1. amendment 2:Amendment 2 added residual error messages to support the use of Non-Physical or Computed referenceStations in a network rtk environmentVersion 3. 1. amendment 3:Amendment 3 addressed differences in the way gnss receiver manufacturers have implemented carrierphase encoding of some Version 3 messages so that carrier phase observations are in phase for all carrierphases of a specific frequency i e. they correct for quarter cycle phase shifts. others retain the quartercycle offset between the carrier phase observations in the data. this amendment documents the waydifferent manufacturers have handled the phase shift issue and prescribes a uniform approach for futureproducts.∨ersiⅰon3.1, Amendment4:Amendment 4 added sections 3.5.13 on glONASS Network rtK Correction Messages and 3.5. 14 on FKPNetwork Rtk Correction Messages Related revisions were also made elsewhere in the document.Version 3. 1. amendment 5Amendment 5 added section 3. 5. 12 on State Space Representation related revisions are also madeelsewhere in the document, along with some editorial correctionsVersion 3. 2(RTCM Standard 10403.2)Version 3.2 consolidates Version 3. 1 and all five amendments into a new edition, and it adds MultipleSignal Messages (MSM)as well. the Multiple Signal Message (MSm)format generates receiverobservables in the same way for all included satellite systems. the messages include compact and fullmessages for Pseudorange, PhaseRange, Carrier to Noise Ratio (standard and high resolution), andPhaseRangeratea table near the beginning of the standard lists which messages were included in each separate editionand amendment, so it should not be necessary for users to refer to older versions. Multiple signalMessages are a generic format that will be followed for all GNSs systems. version 3 originally consisted ofmessages for GPS and GLONASS, each in their own format Now with the imminent addition of signals forBeiDou, Galileo, and QZSS, as well as new signals provided by modernized GPS and GloNASS satellitesthe need for a consistent generic format became evident. service providers and users are urged to migrateto the MsM messages to make it easier to accommodate new gNss services(See The RTCM Multiple Signal Messages: A New Step in GNSS Data Standardization")Another newmessage is the gloNaSS Bias Information message. This message provides information which is intendedto compensate for the first-order inter-frequency phase range biases introduced by the reference receivercode- phase biasVersion 3.2, Amendment 1:Added Galileo F/NAv Satellite Ephemeris Data(msg. 1045 )and Bds MSM(msgs. 1121-1127)Version 3.2 amendment 2Added qzss ephemeris(msg. 1044 )and QZss MSm (msgs. 1111-1117Version 3. 3(RTCM Standard 10403.3)This new edition adds Satellite-Based Augmentation System Multiple Signal Messages to previouslydopted messages for GPS, GLONASS, Galileo, and QzssA new ephemeris message has been added for BeiDou(BDS)and a new I/NAV ephemeris message hasbeen added for Galileo. The new edition also reserves 100 messages be used exclusively by sc104 fornew message developmentFinally, the new edition makes consolidates previous amendments and makes numerous editorialImprovementsNavstar GPS Service, Version 2. x. Service providers and vendors represented on the scco000c30z1O2co00c30Contentsco00c30
    2020-06-27下载
    积分:1
  • 爬虫爬取高德地图POI数据
    python代码,爬虫爬取高德地图POI数据,先注册高德个人账户,获取所需要的key,替代代码中的key,然后更改省市,更改想要的数据类型,python运行即可得到xlse数据
    2020-11-30下载
    积分:1
  • python+OpenCV实现全景图像拼接和图像黑边处理
    使用python+OpenCV实现多张图像拼接,完成拼接后进行图像黑边去除。里面代码每一行都有中文注释和附带的实验图像。
    2020-12-12下载
    积分:1
  • 知识图谱前沿技术课PPT
    知识图谱前沿技术课程PPT知识图谱综述知识图谱的众包构建知识图谱构建的质量控制智能客服的时代已经到来大规模百科知识图谱构建大规模分类体系构建基于知识图谱的搜索与推荐基于知识图谱的语言认知面向知识图谱的问答系统知识图谱的挑战与机遇
    2021-05-07下载
    积分:1
  • 2014年最新提出的仿生群智能优化算法 Chicken swarm Optimization Algorithm
    Chicken Swarm Optimization(CSO)鸡群算法,于2014年10月刚在ICSI 2014上见刊!这是一个全新的群智能优化算法,具有简单,良好扩展性的特点,是一种天然的多种群,自适应算法!作为刚提出的新算法,很适合进行各种改进研究,发表论文。http://www.mathworks.cn/matlabcentral/fileexchange/48204-chicken-swarm-optimization-algorithm--demo-关于算法源代码及介绍,可在上述网站下载!希望对大家有用!
    2020-06-18下载
    积分:1
  • stm32 spi双机通信
    spi 32 通信 双机 目前可实现双机 理论可以实现 1主机 和 n多从机
    2021-05-07下载
    积分:1
  • 吴恩达 Deeplearning深度学习笔记v5.41.pdf
    黄海广博士 整理的最新 吴恩达 Deeplearning深度学习笔记v5.41
    2020-12-07下载
    积分:1
  • 696516资源总数
  • 106914会员总数
  • 0今日下载