12c asm 磁盘组offline

最新推荐文章于 2024-05-10 17:36:50 发布
最新推荐文章于 2024-05-10 17:36:50 发布
阅读量1.1k 收藏 2
点赞数
文章标签： 数据库
原文链接：https://yq.aliyun.com/articles/673364
版权

数据库版本 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

weixin_33946020
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
使ASM磁盘组中的离线磁盘上线
信息化民工的专栏
12-01 1051
使用grid用户登录 先查看是否有离线磁盘，使用lsdg命令结果如下： ASMCMD> lsdg State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name MOUNTED 
Oracle12c 实战ASM磁盘组管理
03-05
Oracle12c 实战ASM磁盘组管理
ASM故障组offline
喝醉酒的小白
09-07 2338
select name, failgroup, group_number from v$asm_disk order by failgroup; alter diskgroup 磁盘组 offline disks in failgroup 故障组; alter diskgroup 磁盘组 online disks in failgroup 故障组;
ASM磁盘的offline和online
u010719917的专栏
09-19 4510
SQL> select group_number,name ,failgroup from v$asm_disk order by group_number ; GROUP_NUMBER NAME FAILGROUP ------------ -------------------------------------...
ORACLE RAC ASM磁盘组OFFLINE后的处理步骤
最新发布
还不算晕的专栏
05-10 1010
对问题进行排查，可以发现问题是存储磁盘出现了IO问题后OFFLINE，从而导致磁盘组也OFFLINE。由于系统是备机，发现时已经过去了较长时间，多余NORMAL冗余（或者双活的存储配置）来说，超过REPAIR TIME的断开需要在加回ASM磁盘组时重新同步。3、检查当前的ASM磁盘情况（注意此命令是动态查看磁盘，如果磁盘现在丢失不显示，就不体现在输出，也就是看到的盘的数量，和正常运行时可能不一样，需要注意。6、查看磁盘并MOUNT磁盘组（此时可以看到全部ASM需要用的磁盘）2、尝试MOUNT磁盘组的报错。
一次存储盘异常引起的ASM磁盘OFFLINE处理
还不算晕的专栏
07-26 899
4.尝试重新MOUNT磁盘组，以及修复OCR（NORMAL冗余）磁盘组中OFFLINE后超过REPAIR时间的DROP状态磁盘。2.检查操作系统的日志（linux /var/opt/message），确定出现了存储盘的IO报错（事后分析为链路问题）登陆系统查看，数据库实例异常关闭，日志指向ASM DISKGROUP异常；1.检查集群状态、ASM实例状态，发现ASM磁盘组已经DISMOUNT；3.目前检查测试，磁盘已经恢复；2.MOUNT 磁盘组报错的解决。3.处理DROP状态的ASM磁盘。
asm中offline磁盘故障处理
cuijingzeng5954的博客
08-18 868
Asmcmd中offline盘处理： 1、Lsdg查看到有offline磁盘。 先尝试online磁盘。 如果on...
Oracle RAC ASM磁盘(diskgroup)丢失，显示OFFLINE的问题
sunny05296的博客
08-04 3178
集群状态显示OFFLINE [grid@rac1 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.ARCH.dg ora....up.type OFFLINE OFFLINE ora.DATA.dg ora....up.typ...
Oracle12c 实战ASM(12.1) 安装配置
03-05
在安装 Oracle 12c ASM（12.1）之前，需要增加共享磁盘配置。首先，打开虚拟机配置，添加磁盘。点击下一步，选择独立、永久，下一步创建新的磁盘。立即分配空间，单个文件，大小给 5G 合适。添加两块磁盘，一块 2G，...
Oracle 12c ASM实例管理学习手册
12-27
Oracle 12c ASM实例管理学习手册涵盖了 ASM 实例管理、ASM 磁盘管理、ASM 文件系统管理、ASM 用户和用户组管理、ASM 监控和诊断等方面的知识点，是 DBA 学习和掌握 Oracle 12c ASM 实例管理的必读指南。
Oracle12c ASM概念深入浅出
03-05
Oracle ASM 磁盘组是Oracle ASM作为一个单元 管理的磁盘集合。在磁盘组中，Oracle ASM公开Oracle Database文件的文件系统接口。存储在磁盘组中的文件内容均匀分布，以消除热点并在磁盘上提供统一的性能。性能可与...
【crs】不要傻傻的只会crs_stat -t看不到单个节点的状态lsnr或者instance,使用crsctl status resource -t
viviliving的专栏
04-01 819
$ crsctl status resource -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS --------...
Oralce数据库ASM存储管理-存储IO故障，disk未及时offline分析，故障分析模板
oradbm的博客
05-08 2065
背景说明： 1、Oracle12.2RAC+ASM Normal Redendancy 模式，数据库存储采用双存储冗余架构，规避单存储故障导致服务中断及数据丢失； 2、 ASM DiskGroup 设计2个 Failgroup(FG)，1个FG磁盘全部存储在1#存储；1个FG全部磁盘存储在2#存储中； 3、期望任意存储故障或断电，数据库实例不受影响，数据不丢失，故障存储上线后数据自动同步。 在实际高可用测试中，拔掉1个存储，发现如下现象： 1.CRS集群不受影响，ocr/votedisk自动
oracle 19c rac 修改私网、公网网络IP
热海鲜橙
03-05 1532
RAC 19C 修改IP
ora.proxy_advm
喝醉酒的小白
12-23 3323
acfs
掉盘超时，盘被drop
whb234174124的博客
01-29 646
默认repair_time SQL&gt; select group_number,name,value from v$asm_attribute where name like '%disk_repair_time%'; GROUP_NUMBER NAME                 VALUE ------------ -------------------- ------------...
Oracle12c ASM磁盘组管理详解
"Oracle12c的ASM(自动存储管理)磁盘组管理涉及一系列操作，包括创建、修改、删除、挂载和卸载磁盘组。此外，磁盘组有多个可配置属性，这些属性定义了磁盘组的行为和性能特征。了解并熟练掌握这些属性对于优化Oracle ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值