ITPub博客

首页 > 数据库 > Oracle > 【kingsql分享】Oracle18c RAC ADVM卷OFFLINE修复一例

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

原创 Oracle 作者:kingsql 时间:2018-11-17 11:33:42 0 删除 编辑

[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



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28389881/viewspace-2220437/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
OCM

注册时间:2013-02-28

  • 博文量
    237
  • 访问量
    859440