ITPub博客

11g RAC R2 日常巡检--Grid

[FAQ] 11G RAC巡检好帮手--AWR Global Report

Oracle 10g RAC TAF介绍

10g R2 RAC 归档模式开启1）srvctl stop database -d rac2）在一个node上执行startup mount;alter system set log_archive_dest_1='location=+FLASH';alter database archivelog;alter database open;3）srvctl stop database -d rac4）srvctl start database -d rac5）archive log li...

ASM动态性能视图

All installer requirements met.Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-06-11_09-27-20AM. Please wait ...[oracle@vmac1 clusterware]$ Oracle Universal Installer, Version 10.2.0.1.0 ProductionCopyright (C) 1999, 2005, Oracle. All rights reserved.Exception java.lang....

[oracle@vmac1 ~]$  /g01/app/grid/product/11.2.0/bin/srvctl  add database -d racdb -o /s01/app/oracle/product/11.2.0 -c RACPRCS-1007 : Server pool racdb already existsPRCR-1086 : server pool ora.racdb is already registered[root@vmac1 ~]# /g01/app/grid/product/11.2.0/bin/crsctl delete s...

查看当前表决磁盘文件列表[grid@vmac1 ~]$ crsctl query css votedisk##  STATE    File Universal Id                File Name Disk group--  -----    -----------------   &n...

SQL>  create diskgroup OCR_DG normal redundancy   2  failgroup OCR_DG_001 disk '/dev/asm-diskg'  3  failgroup OCR_DG_002  disk '/dev/asm-diskh'   4  REGULAR failgroup  OCR_DG_003 disk '/dev/asm-diski'; create diskgroup OCR_DG normal redundancy*...

之前记录了10g RAC的手工关闭和启动，现在经常接触的11g R2的RAC，因为版本差别很大，所以关闭的方式区别也大，具体是11g RAC更简单了。先转一段具体描述：在Oracle 11gR2 下的RAC，架构发生了变化。CRS的信息也是放在ASM 实例里的，所以要关asm必须关闭crs。如果还使用了acfs的话，一关crs那么acfs里的信息也...

参考:  http://www.itpub.net/thread-1761414-1-1.html   http://blog.itpub.net/7199859/viewspace-700920

[root@rac2 g01]# /g01/grid/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:    ORACLE_OWNER= grid    ORACLE_HOME=&...

在RAC中，我们可以通过设置跨节点并行，将并行操作分布到RAC中的不同节点同时进行，以便发挥整个RAC环境的最大运算能力。在RAC中设置跨节点并行主要是通过设置parallel_instance_group和instance_groups这两个参数进...

原汁原味的，官方的，对于ocr  voting disk 的管理方法OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE), including moving&n...

The Oracle Clusterware requires the following two critical files:Voting Disk—Manages cluster membership by way of a health check and arbitrates cluster ownership among the instances in case of net...

Cluster Synchronization Services (CSS)—Manages the cluster configuration by controlling which nodes are members of the cluster and by notifying members when a node joins or leaves the cluster. If yo...