• rac操作


    rac操作:

    怎样获得集群的名字
    [grid@lxtrac05 ~]$ cemutlo -n
    tstrac2
    [grid@lxtrac05 ~]$

    [grid@lxtrac03 ~]$ crsctl get cluster name <<<获取集群的名字 12.2之后才有的
    CRS-6724: Current cluster name is 'ora12c-cluster'
    [grid@lxtrac03 ~]$

    查看是否运行了flex asm。flex的asm默认会建立3个ASM实例,而不管集群中节点的数量
    [grid@lxtrac03 ~]$ crsctl get cluster mode status
    Cluster is running in "flex" mode
    [grid@lxtrac03 ~]$
    一个ASM实例可以为本地和远端数据库提供服务。如果一个ASM实例crash,数据库实例会fail over到另一个ASM实例,而不会crash。

    验证两个节点间的时间是否等效:
    [grid ]$ cluvfy comp clocksync -n all -verbose

    停止某个资源:
    [grid@lxtrac05 ~]$ crsctl stop res ora.cvu
    CRS-2673: Attempting to stop 'ora.cvu' on 'lxtrac06'
    CRS-2677: Stop of 'ora.cvu' on 'lxtrac06' succeeded
    [grid@lxtrac05 ~]$

    停止init显示的某个资源:
    [grid@lxtrac05 ~]$ crsctl stop res ora.crf -init
    CRS-2673: Attempting to stop 'ora.crf' on 'lxtrac05'
    CRS-2677: Stop of 'ora.crf' on 'lxtrac05' succeeded
    [grid@lxtrac05 ~]$

    查看某个资源的依赖性。例如crsd强依赖的资源ora.asm,ora.cssd,ora.ctssd,ora.gipcd
    [grid@lxtrac05 ~]$ crsctl stat res ora.crsd -init -p|grep START_DEPENDENCIES
    START_DEPENDENCIES=hard(ora.asm,ora.cssd,ora.ctssd,ora.gipcd)pullup(ora.asm,ora.cssd,ora.ctssd,ora.gipcd)
    [grid@lxtrac05 ~]$

    修改某个资源的属性

    [root@lxtrac05 bin]# ./crsctl modify res ora.crf -attr ENABLED=0 -init   
    [root@lxtrac05 bin]# ./crsctl modify res ora.lxtrac06.vip -attr USR_ORA_VIP=lxtrac16-vip   修改vip属性

    [oracle@lxtrac04 ~]$ srvctl config database -db orcl
    Database unique name: orcl
    Database name: orcl
    Oracle home: /u01/app/oracle/product/12.2.0.1/dbhome_1
    Oracle user: oracle
    Spfile: /u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/spfileorcl.ora   <<<<<<<<<
    Password file: /u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/orapworcl  <<<<<<<<<
    Domain:
    Start options: open
    Stop options: immediate
    Database role: PRIMARY
    Management policy: AUTOMATIC
    Server pools:
    Disk Groups:
    Mount point paths:
    Services:
    Type: RAC
    Start concurrency:
    Stop concurrency:
    OSDBA group: dba
    OSOPER group: oper
    Database instances: orcl1
    Configured nodes: lxtrac04
    CSS critical: no
    CPU count: 0
    Memory target: 0
    Maximum memory: 0
    Default network number for database services:
    Database is administrator managed
    [oracle@lxtrac04 ~]$

    [oracle@lxtrac04 ~]$ srvctl config asm
    ASM home: <CRS home>
    Password file: +OCR/orapwASM
    Backup of Password file:
    ASM listener: LISTENER
    ASM instance count: 3
    Cluster ASM listener: ASMNET1LSNR_ASM
    [oracle@lxtrac04 ~]$

  • 相关阅读:
    eclipse CreateProcess error=87
    排序与查找
    利用Excel导出sql语句
    Java 反射机制总结
    MySQL问题
    异常解决
    MySQL连接不上
    工作时总结
    笔记
    注意
  • 原文地址:https://www.cnblogs.com/erwadba/p/8058442.html
Copyright © 2020-2023  润新知