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
看着顺眼了
阅读(1363) | 评论(0) | 转发(0) |