• 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 ~]$

  • 相关阅读:
    简述location规则优先级-实现域名跳转-不同语言-终端跳转-错误页面返回首页-腾讯公益首页
    配置nginx访问控制-设置防盗链
    nginx虚拟机及热部署(在线升级)
    阿里云 OSS 网页端直传
    阿里云OSS Java 生成STS
    阿里ECS访问七牛及阿里OSS速度测试
    Maven学习总结(八)——使用Maven构建多模块项目
    关于部分手机无法搜索到5G wifi信号的解决方法
    Spring Boot 2.x
    利用 qshell qupload 批量迁移服务器上的网站图片到七牛云
  • 原文地址:https://www.cnblogs.com/erwadba/p/8058442.html
Copyright © 2020-2023  润新知