【kingsql分享】Oracle18c RAC ADVM卷OFFLINE修复一例

[oracle@rac02 ~]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 - Production on Sat Nov 17 11:32:04 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle.  All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 SQL> select instance_name from gv$instance; INSTANCE_NAME ---------------- kingdb2 kingdb1 故障如下 [grid@rac02 ~]$ crsctl status res -t -------------------------------------------------------------------------------- Name           Target  State        Server                   State details        -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr                ONLINE  ONLINE       rac01                    STABLE                ONLINE  ONLINE       rac02                    STABLE ora.DATA.KINGSQL03.advm                ONLINE  ONLINE       rac01                    STABLE                OFFLINE OFFLINE      rac02                    STABLE [grid@rac01 ~]$ srvctl status volume -n rac02 Volume KINGSQL03 of diskgroup DATA for device /dev/asm/kingsql03-138 is enabled Volume Device KINGSQL03 of diskgroup DATA for device /dev/asm/kingsql03-138 is not running on node(s): rac02 ...... [grid@rac01 ~]$ srvctl start volume -volume KINGSQL03 -diskgroup DATA -n rac02 [grid@rac01 ~]$ srvctl status volume -n rac02 Volume KINGSQL03 of diskgroup DATA for device /dev/asm/kingsql03-138 is enabled Volume KINGSQL03 of diskgroup DATA for device /dev/asm/kingsql03-138 is running on nodes: rac02 ...... 转载请注明出处 hongzhuohui@qq.com