• 测试RAC的功能


    1、查看RAC服务状态

    node1-> crs_stat -t

    Name           Type           Target    State     Host

    ------------------------------------------------------------

    ora.DATA.dg    ora....up.type ONLINE    ONLINE    node1

    ora.FLASH.dg   ora....up.type ONLINE    ONLINE    node1

    ora.GRIDDG.dg  ora....up.type ONLINE    ONLINE    node1

    ora....ER.lsnr ora....er.type ONLINE    ONLINE    node1

    ora....N1.lsnr ora....er.type ONLINE    ONLINE    node1

    ora.asm        ora.asm.type   ONLINE    ONLINE    node1

    ora.cvu        ora.cvu.type   ONLINE    ONLINE    node1

    ora.devdb.db   ora....se.type ONLINE    OFFLINE

    ora.gsd        ora.gsd.type   OFFLINE   OFFLINE

    ora....network ora....rk.type ONLINE    ONLINE    node1

    ora....SM1.asm application    ONLINE    ONLINE    node1

    ora....E1.lsnr application    ONLINE    ONLINE    node1

    ora.node1.gsd  application    OFFLINE   OFFLINE

    ora.node1.ons  application    ONLINE    ONLINE    node1

    ora.node1.vip  ora....t1.type ONLINE    ONLINE    node1

    ora....SM2.asm application    ONLINE    ONLINE    node2

    ora....E2.lsnr application    ONLINE    ONLINE    node2

    ora.node2.gsd  application    OFFLINE   OFFLINE

    ora.node2.ons  application    ONLINE    ONLINE    node2

    ora.node2.vip  ora....t1.type ONLINE    ONLINE    node2

    ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    node1

    ora.ons        ora.ons.type   ONLINE    ONLINE    node1

    ora....ry.acfs ora....fs.type ONLINE    ONLINE    node1

    ora.scan1.vip  ora....ip.type ONLINE    ONLINE    node1

    2、检查CRS的状态

    1)查看本地节点CRS状态

    node1-> crsctl check crs

    CRS-4638: Oracle High Availability Services is online

    CRS-4537: Cluster Ready Services is online

    CRS-4529: Cluster Synchronization Services is online

    CRS-4533: Event Manager is online

    node2-> crsctl check crs

    CRS-4638: Oracle High Availability Services is online

    CRS-4537: Cluster Ready Services is online

    CRS-4529: Cluster Synchronization Services is online

    CRS-4533: Event Manager is online

    2)查看集群CRS状态

    node1-> crsctl check cluster

    CRS-4537: Cluster Ready Services is online

    CRS-4529: Cluster Synchronization Services is online

    CRS-4533: Event Manager is online

    3)查看evm事件管理器状态

    node1-> crsctl check evm

    CRS-4533: Event Manager is online

    3、查看RAC集群里节点的配置信息

    node1-> olsnodes

    node1

    node2

    node1-> olsnodes -n -i -s           ---  -n列出节点编号 -i列出虚拟ip -s列出状态

    node1   1       node1-vip       Active

    node2   2       node2-vip       Active

    4、查看RAC集群中软件版本信息

    1)查看集群软件使用版本信息

    node1-> crsctl query crs activeversion

    Oracle Clusterware active version on the cluster is [11.2.0.4.0]

    2)查看集群软件发行版本信息

    node1-> crsctl query crs releaseversion

    Oracle High Availability Services release version on the local node is [11.2.0.4.0]

    3)查看集群软件安装版本信息

    node1-> crsctl query crs softwareversion

    Oracle Clusterware version on node [node1] is [11.2.0.4.0]

    5、查看集群软件表决磁盘信息

    node1-> crsctl query css votedisk

    ##  STATE    File Universal Id                File Name Disk group

    --  -----    -----------------                --------- ---------

     1. ONLINE   2a0486c2db354fbfbf5d5d3b6b2af4fd (ORCL:VOL1) [GRIDDG]

    Located 1 voting disk(s).

    6、查看系统DNS相关配置信息

    node1-> crsctl query dns -servers

    CRS-10018: the following configuration was found on the system:

    CRS-10019: There are 1 domains in search order. They are:

    localdomain

    CRS-10022: There are 1 name servers. They are:

    172.16.0.191

    CRS-10020: number of retry attempts for name lookup is: 4

    CRS-10021: timeout for each name lookup is: 5

    以上信息来源于:

    node1-> cat /etc/resolv.conf

    search localdomain

    nameserver 172.16.0.191

    7、查看集群SCAN VIP信息

    node1-> srvctl config scan

    SCAN name: scan-cluster.localdomain, Network: 1/172.16.0.0/255.255.240.0/eth0

    SCAN VIP name: scan1, IP: /scan-cluster.localdomain/172.16.0.203

    node1-> srvctl config scan_listener

    SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

    8、查看OCR信息

    [root@node1 bin]# ./ocrcheck -local

    Status of Oracle Local Registry is as follows :

             Version                  :          3

             Total space (kbytes)     :     262120

             Used space (kbytes)      :       2676

             Available space (kbytes) :     259444

             ID                       : 1155296004

             Device/File Name         : /u01/app/11.2.0/grid/cdata/node1.olr

                                        Device/File integrity check succeeded

             Local registry integrity check succeeded

             Logical corruption check succeeded

    9、查看OCR集群软件备份信息

    node1-> ocrconfig -showbackup

    node1     2015/04/20 15:58:34     /u01/app/11.2.0/grid/cdata/scan-cluster/backup00.ocr

    node1     2015/04/20 15:58:34     /u01/app/11.2.0/grid/cdata/scan-cluster/day.ocr

    node1     2015/04/20 15:58:34     /u01/app/11.2.0/grid/cdata/scan-cluster/week.ocr

    PROT-25: Manual backups for the Oracle Cluster Registry are not available

    10、启、停集群数据库

    1)停止RAC数据库

    node1-> srvctl stop database -d devdb

    2)停止集群服务

    [root@node1 ~]# cd /u01/app/11.2.0/grid/bin

    [root@node1 bin]# ./crsctl stop cluster -all

    3)启动集群服务

    [root@node1 bin]# pwd

    /u01/app/11.2.0/grid/bin

    [root@node1 bin]# ./crsctl start cluster -all

    4)启动RAC数据库

    node1-> srvctl start database -d devdb

  • 相关阅读:
    C#解析PDF
    Ora-03113Ora-03114与Oracle In 拼接字符串的问题
    [Linux] nohup/setsid/& 让进程在后台可靠运行
    [Python] json 报错'xxx is not JSON serializable'的处理方法
    [Linux] 虚拟环境的配置和使用 virtualenv
    [Python] 跳过前几行快速读取文件内容:islice
    对pandas的dataframe绘图并保存
    matplotlib 数据可视化
    awk结合正则匹配
    Pandas库常用函数和操作
  • 原文地址:https://www.cnblogs.com/wcwen1990/p/4546493.html
Copyright © 2020-2023  润新知