本文共 14983 字，大约阅读时间需要 49 分钟。
数据库版本 12.2.0.1.0
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 STABLEora.DATA.dg ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE OFFLINE OFFLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.FRA.dg ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE OFFLINE OFFLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.LISTENER.lsnr ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.MGMT.dg ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE OFFLINE OFFLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.OCR_VOTE.dg ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE OFFLINE OFFLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.chad ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.net1.network ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.ons ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.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 STABLEora.MGMTLSNR 1 ONLINE ONLINE wsjrrac1 169.254.209.46 192.1 68.100.22,STABLEora.asm 1 ONLINE ONLINE wsjrrac1 Started,STABLE 2 ONLINE ONLINE wsjrrac4 Started,STABLE 3 ONLINE ONLINE wsjrrac2 Started,STABLEora.cvu 1 ONLINE ONLINE wsjrrac2 STABLEora.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,STABLEora.mgmtdb 1 ONLINE ONLINE wsjrrac1 Open,STABLEora.qosmserver 1 ONLINE ONLINE wsjrrac2 STABLEora.scan1.vip 1 ONLINE ONLINE wsjrrac2 STABLEora.wsjrrac1.vip 1 ONLINE ONLINE wsjrrac1 STABLEora.wsjrrac2.vip 1 ONLINE ONLINE wsjrrac2 STABLEora.wsjrrac3.vip 1 ONLINE ONLINE wsjrrac3 STABLEora.wsjrrac4.vip 1 ONLINE ONLINE wsjrrac4 STABLE--------------------------------------------------------------------------------
[grid@wsjrRAC1 ~]$ asmcmdASMCMD> lsdgState Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED 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 statusCluster is running in "flex" mode[grid@wsjrRAC1 ~]$ srvctl status asm -detailASM is running on wsjrrac4,wsjrrac1,wsjrrac2ASM is enabled.ASM instance +ASM1 is running on node wsjrrac1Number of connected clients: 3Client names: -MGMTDB:_mgmtdb:dbrac-cluster dbrac1:dbrac:dbrac-cluster wsjrrac1:_OCR:dbrac-clusterASM instance +ASM4 is running on node wsjrrac4Number of connected clients: 4Client names: dbrac3:dbrac:dbrac-cluster dbrac4:dbrac:dbrac-cluster wsjrrac3:_OCR:dbrac-cluster wsjrrac4:_OCR:dbrac-clusterASM instance +ASM2 is running on node wsjrrac2Number of connected clients: 2Client names: dbrac2:dbrac:dbrac-cluster wsjrrac2:_OCR:dbrac-cluster[grid@wsjrRAC1 ~]$ srvctl config asmASM home:Password file: +OCR_VOTE/orapwASMBackup of Password file: ASM listener: LISTENERASM instance count: 3Cluster ASM listener: ASMNET1LSNR_ASMSQL> 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
[grid@wsjrRAC1 ~]$ srvctl modify asm -count 4[grid@wsjrRAC1 ~]$ srvctl config asmASM home:Password file: +OCR_VOTE/orapwASMBackup of Password file: ASM listener: LISTENERASM instance count: 4Cluster ASM listener: ASMNET1LSNR_ASM[grid@wsjrRAC1 ~]$ crsccrscdpd 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 STABLEora.DATA.dg ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.FRA.dg ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.LISTENER.lsnr ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.MGMT.dg ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.OCR_VOTE.dg ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.chad ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.net1.network ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.ons ONLINE ONLINE wsjrrac1 STABLE ONLINE ONLINE wsjrrac2 STABLE ONLINE ONLINE wsjrrac3 STABLE ONLINE ONLINE wsjrrac4 STABLEora.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 STABLEora.MGMTLSNR 1 ONLINE ONLINE wsjrrac1 169.254.209.46 192.1 68.100.22,STABLEora.asm 1 ONLINE ONLINE wsjrrac1 Started,STABLE 2 ONLINE ONLINE wsjrrac4 Started,STABLE 3 ONLINE ONLINE wsjrrac2 Started,STABLE 4 ONLINE ONLINE wsjrrac3 Started,STABLEora.cvu 1 ONLINE ONLINE wsjrrac2 STABLEora.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,STABLEora.mgmtdb 1 ONLINE ONLINE wsjrrac1 Open,STABLEora.qosmserver 1 ONLINE ONLINE wsjrrac2 STABLEora.scan1.vip 1 ONLINE ONLINE wsjrrac2 STABLEora.wsjrrac1.vip 1 ONLINE ONLINE wsjrrac1 STABLEora.wsjrrac2.vip 1 ONLINE ONLINE wsjrrac2 STABLEora.wsjrrac3.vip 1 ONLINE ONLINE wsjrrac3 STABLEora.wsjrrac4.vip 1 ONLINE ONLINE wsjrrac4 STABLE--------------------------------------------------------------------------------[grid@wsjrRAC1 ~]$
转载地址：http://loxto.baihongyu.com/