数据库版本 12.2.0.1.0
4个节点一个节点磁盘组显示offline
wsjrrac3 节点磁盘组显示offline?
[grid@wsjrRAC1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.DATA.dg
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
OFFLINE OFFLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.FRA.dg
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
OFFLINE OFFLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.MGMT.dg
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
OFFLINE OFFLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.OCR_VOTE.dg
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
OFFLINE OFFLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.chad
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.net1.network
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.ons
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.proxy_advm
OFFLINE OFFLINE wsjrrac1 STABLE
OFFLINE OFFLINE wsjrrac2 STABLE
OFFLINE OFFLINE wsjrrac3 STABLE
OFFLINE OFFLINE wsjrrac4 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE wsjrrac2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE wsjrrac1 169.254.209.46 192.1
68.100.22,STABLE
ora.asm
1 ONLINE ONLINE wsjrrac1 Started,STABLE
2 ONLINE ONLINE wsjrrac4 Started,STABLE
3 ONLINE ONLINE wsjrrac2 Started,STABLE
ora.cvu
1 ONLINE ONLINE wsjrrac2 STABLE
ora.dbrac.db
1 ONLINE ONLINE wsjrrac1 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
2 ONLINE ONLINE wsjrrac2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
3 ONLINE ONLINE wsjrrac3 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
4 ONLINE ONLINE wsjrrac4 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
ora.mgmtdb
1 ONLINE ONLINE wsjrrac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE wsjrrac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE wsjrrac2 STABLE
ora.wsjrrac1.vip
1 ONLINE ONLINE wsjrrac1 STABLE
ora.wsjrrac2.vip
1 ONLINE ONLINE wsjrrac2 STABLE
ora.wsjrrac3.vip
1 ONLINE ONLINE wsjrrac3 STABLE
ora.wsjrrac4.vip
1 ONLINE ONLINE wsjrrac4 STABLE
--------------------------------------------------------------------------------wsjrrac3 查看磁盘组状态为mount 状态正常？
[grid@wsjrRAC1 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 1048576 1048576 1038751 0 1038751 0 N DATA/
MOUNTED EXTERN N 512 512 4096 1048576 514048 503331 0 503331 0 N FRA/
MOUNTED EXTERN N 512 512 4096 4194304 40960 4780 0 4780 0 N MGMT/
MOUNTED EXTERN N 512 512 4096 4194304 10240 9848 0 9848 0 Y OCR_VOTE/
ASMCMD># 为什么呢？
[grid@wsjrRAC1 ~]$ crsctl get cluster mode status
Cluster is running in "flex" mode
[grid@wsjrRAC1 ~]$ srvctl status asm -detail
ASM is running on wsjrrac4,wsjrrac1,wsjrrac2
ASM is enabled.
ASM instance +ASM1 is running on node wsjrrac1
Number of connected clients: 3
Client names: -MGMTDB:_mgmtdb:dbrac-cluster dbrac1:dbrac:dbrac-cluster wsjrrac1:_OCR:dbrac-cluster
ASM instance +ASM4 is running on node wsjrrac4
Number of connected clients: 4
Client names: dbrac3:dbrac:dbrac-cluster dbrac4:dbrac:dbrac-cluster wsjrrac3:_OCR:dbrac-cluster wsjrrac4:_OCR:dbrac-cluster
ASM instance +ASM2 is running on node wsjrrac2
Number of connected clients: 2
Client names: dbrac2:dbrac:dbrac-cluster wsjrrac2:_OCR:dbrac-cluster
[grid@wsjrRAC1 ~]$ srvctl config asm
ASM home: <CRS home>
Password file: +OCR_VOTE/orapwASM
Backup of Password file:
ASM listener: LISTENER
ASM instance count: 3
Cluster ASM listener: ASMNET1LSNR_ASM
SQL> SELECT inst_id,instance_name, db_name, status FROM gv$asm_client;
INST_ID INSTANCE_NAME DB_NAME STATUS
---------- ---------------------------------------------------------------- -------- ------------
1 +ASM1 +ASM CONNECTED
1 wsjrrac1 _OCR CONNECTED
1 +ASM1 +ASM CONNECTED
1 -MGMTDB _mgmtdb CONNECTED
1 +ASM1 +ASM CONNECTED
1 dbrac1 dbrac CONNECTED
1 +ASM1 +ASM CONNECTED
1 dbrac1 dbrac CONNECTED
2 +ASM2 +ASM CONNECTED
2 wsjrrac2 _OCR CONNECTED
2 dbrac2 dbrac CONNECTED
INST_ID INSTANCE_NAME DB_NAME STATUS
---------- ---------------------------------------------------------------- -------- ------------
2 +ASM2 +ASM CONNECTED
2 dbrac2 dbrac CONNECTED
4 +ASM4 +ASM CONNECTED
4 wsjrrac3 _OCR CONNECTED
4 wsjrrac4 _OCR CONNECTED
4 dbrac3 dbrac CONNECTED
4 dbrac4 dbrac CONNECTED
4 +ASM4 +ASM CONNECTED
4 dbrac3 dbrac CONNECTED
4 dbrac4 dbrac CONNECTED修改节点书为4，查看状态
[grid@wsjrRAC1 ~]$ srvctl modify asm -count 4
[grid@wsjrRAC1 ~]$ srvctl config asm
ASM home: <CRS home>
Password file: +OCR_VOTE/orapwASM
Backup of Password file:
ASM listener: LISTENER
ASM instance count: 4
Cluster ASM listener: ASMNET1LSNR_ASM
[grid@wsjrRAC1 ~]$ crsc
crscdpd crsctl crsctl.bin
[grid@wsjrRAC1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.DATA.dg
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.FRA.dg
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.MGMT.dg
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.OCR_VOTE.dg
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.chad
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.net1.network
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.ons
ONLINE ONLINE wsjrrac1 STABLE
ONLINE ONLINE wsjrrac2 STABLE
ONLINE ONLINE wsjrrac3 STABLE
ONLINE ONLINE wsjrrac4 STABLE
ora.proxy_advm
OFFLINE OFFLINE wsjrrac1 STABLE
OFFLINE OFFLINE wsjrrac2 STABLE
OFFLINE OFFLINE wsjrrac3 STABLE
OFFLINE OFFLINE wsjrrac4 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE wsjrrac2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE wsjrrac1 169.254.209.46 192.1
68.100.22,STABLE
ora.asm
1 ONLINE ONLINE wsjrrac1 Started,STABLE
2 ONLINE ONLINE wsjrrac4 Started,STABLE
3 ONLINE ONLINE wsjrrac2 Started,STABLE
4 ONLINE ONLINE wsjrrac3 Started,STABLE
ora.cvu
1 ONLINE ONLINE wsjrrac2 STABLE
ora.dbrac.db
1 ONLINE ONLINE wsjrrac1 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
2 ONLINE ONLINE wsjrrac2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
3 ONLINE ONLINE wsjrrac3 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
4 ONLINE ONLINE wsjrrac4 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
ora.mgmtdb
1 ONLINE ONLINE wsjrrac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE wsjrrac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE wsjrrac2 STABLE
ora.wsjrrac1.vip
1 ONLINE ONLINE wsjrrac1 STABLE
ora.wsjrrac2.vip
1 ONLINE ONLINE wsjrrac2 STABLE
ora.wsjrrac3.vip
1 ONLINE ONLINE wsjrrac3 STABLE
ora.wsjrrac4.vip
1 ONLINE ONLINE wsjrrac4 STABLE
--------------------------------------------------------------------------------
[grid@wsjrRAC1 ~]$ 参考文档：
http://blog.itpub.net/20747382/viewspace-2140867/
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ostmg/manage-flex-asm.html#GUID-39D13B70-30AE-4DFE-BFF9-2CD3A33A82E0
