联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
采用了fix asm之后,查看集群状态的时候会有一个ora.asmgroup相关是offline状态,可以通过srvctl modify asm -count 2命令强制把asm count设置为2从而就不会有offline的资源存在
[grid@dbserver1 ~]$ crsctl status 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.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE 3 ONLINE OFFLINE STABLE ora.ASMNET2LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE 3 ONLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE 3 OFFLINE OFFLINE STABLE ora.FRA.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.SYSDG.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.asmnet2.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.dbserver1.vip 1 ONLINE ONLINE dbserver1 STABLE ora.dbserver2.vip 1 ONLINE ONLINE dbserver2 STABLE ora.xff.db 1 ONLINE ONLINE dbserver1 Open,HOME=/u01/app/o racle/product/19c/db _1,STABLE 2 ONLINE ONLINE dbserver2 Open,HOME=/u01/app/o racle/product/19c/db _1,STABLE ora.qosmserver 1 ONLINE ONLINE dbserver1 STABLE ora.scan1.vip 1 ONLINE ONLINE dbserver1 STABLE -------------------------------------------------------------------------------- [grid@dbserver1 ~]$ srvctl modify asm -count 2 [grid@dbserver1 ~]$ crsctl status 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.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE ora.ASMNET2LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE ora.FRA.dg(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE dbserver1 STABLE ora.SYSDG.dg(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE dbserver1 Started,STABLE 2 ONLINE ONLINE dbserver2 Started,STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE ora.asmnet2.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE dbserver1 STABLE 2 ONLINE ONLINE dbserver2 STABLE ora.cvu 1 ONLINE ONLINE dbserver1 STABLE ora.dbserver1.vip 1 ONLINE ONLINE dbserver1 STABLE ora.dbserver2.vip 1 ONLINE ONLINE dbserver2 STABLE ora.xff.db 1 ONLINE ONLINE dbserver1 Open,HOME=/u01/app/o racle/product/19c/db _1,STABLE 2 ONLINE ONLINE dbserver2 Open,HOME=/u01/app/o racle/product/19c/db _1,STABLE ora.qosmserver 1 ONLINE ONLINE dbserver1 STABLE ora.scan1.vip 1 ONLINE ONLINE dbserver1 STABLE -------------------------------------------------------------------------------- [grid@dbserver1 ~]$