19c数据库,检查
两节点rac集群状态,发现几个offline的
grid@dbserver2:/home/grid $ crsctl stat res -t
-
--------------------------------------------------------------------------------
-
name target state server state details
-
--------------------------------------------------------------------------------
-
local resources
-
--------------------------------------------------------------------------------
-
ora.listener.lsnr
-
online online dbserver1 stable
-
online online dbserver2 stable
-
ora.chad
-
online online dbserver1 stable
-
online online dbserver2 stable
-
ora.net1.network
-
online online dbserver1 stable
-
online online dbserver2 stable
-
ora.ons
-
online online dbserver1 stable
-
online online dbserver2 stable
-
ora.proxy_advm
-
offline offline dbserver1 stable
-
offline offline dbserver2 stable
-
--------------------------------------------------------------------------------
-
cluster resources
-
--------------------------------------------------------------------------------
-
ora.archdg.dg(ora.asmgroup)
-
1 online online dbserver1 stable
-
2 online online dbserver2 stable
-
3 offline offline stable
-
ora.asmnet1lsnr_asm.lsnr(ora.asmgroup)
-
1 online online dbserver1 stable
-
2 online online dbserver2 stable
-
3 online offline stable
-
ora.datadg.dg(ora.asmgroup)
-
1 online online dbserver1 stable
-
2 online online dbserver2 stable
-
3 offline offline stable
-
ora.listener_scan1.lsnr
-
1 online online dbserver1 stable
-
ora.ocrdg.dg(ora.asmgroup)
-
1 online online dbserver1 stable
-
2 online online dbserver2 stable
-
3 offline offline stable <-------------- 脱机?
-
ora.asm(ora.asmgroup)
-
1 online online dbserver1 started,stable
-
2 online online dbserver2 started,stable
-
3 offline offline stable <-------------- 脱机?
-
ora.asmnet1.asmnetwork(ora.asmgroup)
-
1 online online dbserver1 stable
-
2 online online dbserver2 stable
-
3 offline offline stable <-------------- 脱机?
-
ora.cvu
-
1 online online dbserver1 stable
-
ora.orcl.db
-
1 online online dbserver1 open,home=/oracle/ap
-
p/oracle/product/19.
-
3.0/db_1,stable
-
2 online online dbserver2 open,home=/oracle/ap
-
p/oracle/product/19.
-
3.0/db_1,stable
-
ora.qosmserver
-
1 online online dbserver1 stable
-
ora.scan1.vip
-
1 online online dbserver1 stable
-
ora.dbserver1.vip
-
1 online online dbserver1 stable
-
ora.dbserver2.vip
-
1 online online dbserver2 stable
-
--------------------------------------------------------------------------------
确认是两个节点
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
看着顺眼了
阅读(1219) | 评论(0) | 转发(0) |