ITPub博客

9.Oracle Clusterware AdministrationOracle Clusterware: Overview• Portable cluster infrastructure that provides HA to RAC databases and/or other applications:– Monitors applications’ health - 监控应用运行情况– Restarts applications on failure - 重启失败的应用– Can fail over applications on node failure - 将应用failover到其他节点Oracle Clusterware Run-Time View在Unix平台上，clusterware stack的启动是根据/etc/inittab文件中定义的respawn条目A basic description of each process:• Cluster

首先检查一下ocr.loc文件中的配置[root@redhat1 clusterware]#cat /etc/oracle/ocr.lococrconfig_loc=/ocfs/clusterware/ocrlocal_only=false按照文档中所说的命令添加ocrmirror却报PROT-21错[root@redhat1 clusterware]# ocrconfig -replace ocrmirror /ocfs/clusterware/ocrmirrorPROT-21: Invalid parameter上网查了一下其他人的实验，发现首先需要创建文件[root@redhat1 clusterware]# touch /ocfs/clusterware/ocrmirror[root@redhat1 clusterware]# ls -ltotal 46239-rw-r----- 1 root oinstall 5963776 Feb 9 16:27 ocr-rw-r--r--

7. ServicesTraditional Workload Dispatching传统模式下，每个应用被永久性地分配到一部分相对独立的资源，这些分配到的资源必须分别满足每个应用的峰值需求。由于应用的峰值时段一般只持续几小时，因此在绝大多数时间中，大量资源处于浪费状态。 Grid Workload Dispatching在网格计算环境下，由一个全局的资源池同时对多个应用提供使用，在不同的应用间计算单元可被动态地分配和调整。 What Is a Service?• Is a means of grouping sessions that are doing the same kind of work可将完成同一种工作的会话分组• Provides

6. RAC Performance Tuning CPU and Wait Time Tuning Dimensions一般情况下，等待事件显著的话，比较可能需要instance/RAC tuning。这时增加CPU或节点很难改善问题。CPU使用率较高的话，有可能需要进行SQL tuning。这种情况下增加CPU或节点数一般可以得到较好的效果。（注意scale-up和speed-up的区别）RAC-Specific Tuning• Tune for a single instance first.• Tune for RAC:– Instance recovery– Interconnect traffic– Point of serialization can be exacerbated• RAC-reactive tuning tools:– Specific wait

4. RAC Database AdministrationUse Enterprise Manager cluster database pagesRedo Log Files and RAC每个实例必须拥有至少两组redo。使用alter database add logfile thread…命令来指定为哪个实例增加redo fileAutomatic Undo Management and RAC为每个实例指定一个专用的undo tablespaceRAC01.UNDO_TABLESPACE=undotbs3RAC02.UNDO_TABLESPACE=undotbs2Starting and Stopping RAC Instances• RAC instances can be started and stopped by using:– Enterprise Manager– Server Control (SRVCTL) utility– SQL*PlusStarting a

0. IntroductionWhat Is a Cluster?Interconnected nodes act as a single serverCluster software hides the structureDisks are available for read and write by all nodes.Operating system is the same on each machineWhat Is Oracle Real Application Clusters?Multiple instances accessing the same databaseOne Instance per nodePhysical or logical access to each database fileSoftware-controlled data accessWhy Use RACHigh availabilityScalabilityPay as you growKey grid computing featuresLevels of ScalabilityHar