Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1560409
  • 博文数量: 351
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 3898
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(351)

文章存档

2021年(82)

2020年(115)

2019年(11)

2018年(9)

2017年(9)

2016年(17)

2015年(7)

2014年(4)

2013年(1)

2012年(11)

2011年(27)

2010年(35)

2009年(11)

2008年(11)

分类: Oracle

2021-03-18 17:28:39


19c数据库,检查两节点rac集群状态,发现几个offline的

grid@dbserver2:/home/grid $ crsctl stat res -t

  1. --------------------------------------------------------------------------------
  2. Name Target State Server State details
  3. --------------------------------------------------------------------------------
  4. Local Resources
  5. --------------------------------------------------------------------------------
  6. ora.LISTENER.lsnr
  7.                ONLINE ONLINE dbserver1 STABLE
  8.                ONLINE ONLINE dbserver2 STABLE
  9. ora.chad
  10.                ONLINE ONLINE dbserver1 STABLE
  11.                ONLINE ONLINE dbserver2 STABLE
  12. ora.net1.network
  13.                ONLINE ONLINE dbserver1 STABLE
  14.                ONLINE ONLINE dbserver2 STABLE
  15. ora.ons
  16.                ONLINE ONLINE dbserver1 STABLE
  17.                ONLINE ONLINE dbserver2 STABLE
  18. ora.proxy_advm
  19.                OFFLINE OFFLINE dbserver1 STABLE
  20.                OFFLINE OFFLINE dbserver2 STABLE
  21. --------------------------------------------------------------------------------
  22. Cluster Resources
  23. --------------------------------------------------------------------------------
  24. ora.ARCHDG.dg(ora.asmgroup)
  25.       1 ONLINE ONLINE dbserver1 STABLE
  26.       2 ONLINE ONLINE dbserver2 STABLE
  27.       3 OFFLINE OFFLINE STABLE
  28. ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
  29.       1 ONLINE ONLINE dbserver1 STABLE
  30.       2 ONLINE ONLINE dbserver2 STABLE
  31.       3 ONLINE OFFLINE STABLE
  32. ora.DATADG.dg(ora.asmgroup)
  33.       1 ONLINE ONLINE dbserver1 STABLE
  34.       2 ONLINE ONLINE dbserver2 STABLE
  35.       3 OFFLINE OFFLINE STABLE
  36. ora.LISTENER_SCAN1.lsnr
  37.       1 ONLINE ONLINE dbserver1 STABLE
  38. ora.OCRDG.dg(ora.asmgroup)
  39.       1 ONLINE ONLINE dbserver1 STABLE
  40.       2 ONLINE ONLINE dbserver2 STABLE
  41.       3 OFFLINE OFFLINE STABLE <-------------- 脱机?
  42. ora.asm(ora.asmgroup)
  43.       1 ONLINE ONLINE dbserver1 Started,STABLE
  44.       2 ONLINE ONLINE dbserver2 Started,STABLE
  45.       3 OFFLINE OFFLINE STABLE <-------------- 脱机?
  46. ora.asmnet1.asmnetwork(ora.asmgroup)
  47.       1 ONLINE ONLINE dbserver1 STABLE
  48.       2 ONLINE ONLINE dbserver2 STABLE
  49.       3 OFFLINE OFFLINE STABLE <-------------- 脱机?
  50. ora.cvu
  51.       1 ONLINE ONLINE dbserver1 STABLE
  52. ora.orcl.db
  53.       1 ONLINE ONLINE dbserver1 Open,HOME=/oracle/ap
  54.                                                              p/oracle/product/19.
  55.                                                              3.0/db_1,STABLE
  56.       2 ONLINE ONLINE dbserver2 Open,HOME=/oracle/ap
  57.                                                              p/oracle/product/19.
  58.                                                              3.0/db_1,STABLE
  59. ora.qosmserver
  60.       1 ONLINE ONLINE dbserver1 STABLE
  61. ora.scan1.vip
  62.       1 ONLINE ONLINE dbserver1 STABLE
  63. ora.dbserver1.vip
  64.       1 ONLINE ONLINE dbserver1 STABLE
  65. ora.dbserver2.vip
  66.       1 ONLINE ONLINE dbserver2 STABLE
  67. --------------------------------------------------------------------------------


确认是两个节点
grid@dbserver2:/home/grid $olsnodes
dbserver1
dbserver2

查看集群模式
grid@dbserver2:/home/grid $asmcmd showclustermode
ASM cluster : Flex mode enabled - Direct Storage Access
grid@dbserver2:/home/grid $

检查asm配置
grid@dbserver2:/home/grid $srvctl config asm
ASM home:
Password file: +OCRDG/orapwASM
Backup of Password file: +OCRDG/orapwASM_backup
ASM listener: LISTENER
ASM instance count: 3
Cluster ASM listener: ASMNET1LSNR_ASM

修改命令介绍
grid@dbserver2:/home/grid $srvctl modify asm -h

Modifies the configuration for ASM.

Usage: srvctl modify asm {[-proxy -spfile ] | [-pwfile ] [-pwfilebackup ] [-listener ] [-count {|ALL}] [-spfile ]} [-force]
    -proxy                         To modify the ADVM proxy instance configuration    
    -spfile                Server parameter file path
    -pwfile    Password file path
    -pwfilebackup Backup password file path
    -listener           Listener name
    -count                         |ALL  The number of instances or ALL to have instances on all nodes
    -force                         Force modification (ignore dependencies)
    -help                          Print usage

解决办法:
srvctl modify asm -count 2
看着顺眼了

阅读(127) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~