crsctl 过滤offline的资源

440阅读 0评论2023-10-18 brjl
分类:Oracle

随着资源越来越多,有时需要关注哪些集群资源offline了,往往会考虑直接grep,但看不到资源名

-w 可以解决
  1. crsctl stat res |grep "TYPE=" |uniq

  2. crsctl stat res -t -w "(TARGET != ONLINE) AND (TYPE != ora.proxy_advm.type)"

  3. crsctl stat res -t -w "(TARGET != ONLINE) AND (TYPE co ora.proxy_advm)"

  4.                 co --> contains 包含
  5.                 st --> starts with 开始
  6.                 en --> ends with 截止
  7.                 nc --> does not contain 不包含
  8.                 coi --> contains, case-insensitive 包含,不分大小写
  9.                 nci --> does not contain, case-insensitive 不包含 不分大小写
  10.                 eqi --> equals, case-insensitive

  11. crsctl stat res -t -w "(TARGET != ONLINE) AND (TYPE coi ORA.proxy_advm)"

  12. crsctl stat res -t -h 看详细说明

上一篇:生成goldimage镜像
下一篇:关于达梦v$datafile的total_size=983040