asm磁盘组无法写入问题-处理中

有个11204的rac环境,没应用补丁,5号突然报归档满,登录环境后发现奇怪,一个1T磁盘建成的DATA磁盘组使用了近800G,读写正常,一个1.5T磁盘建成的FRA磁盘组,目前还剩余729551M,无法写入归档

手动启停实例,报错如下

SQL> startup;
ORACLE instance started.

Total System Global Area 8.5516E+10 bytes
Fixed Size            2262656 bytes
Variable Size         1.8522E+10 bytes
Database Buffers     6.6840E+10 bytes
Redo Buffers          151117824 bytes
Database mounted.
ORA-16038: log 8 sequence# 10572 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 8 thread 2:
'+DATA/orcl/onlinelog/group_8.358.1128304555'

SQL>

alert日志报错

ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file "+FRA/orcl/archivelog/2024_04_04/thread_2_seq_10575.128205.1165411713", block number 67584 (block size=512)
WARNING: failed to write mirror side 1 of virtual extent 179 logical extent 0 of file 128205 in group 1 on disk 0 allocation unit 845657
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_arc0_456667.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file "+FRA/orcl/archivelog/2024_04_04/thread_2_seq_10575.128205.1165411713", block number 67584 (block size=512)
WARNING: failed to write mirror side 1 of virtual extent 164 logical extent 0 of file 128205 in group 1 on disk 0 allocation unit 845642
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_arc0_456667.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file "+FRA/orcl/archivelog/2024_04_04/thread_2_seq_10575.128205.1165411713", block number 67584 (block size=512)
WARNING: failed to write mirror side 1 of virtual extent 110 logical extent 0 of file 128205 in group 1 on disk 0 allocation unit 845588
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_arc0_456667.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file "+FRA/orcl/archivelog/2024_04_04/thread_2_seq_10575.128205.1165411713", block number 67584 (block size=512)
WARNING: failed to write mirror side 1 of virtual extent 95 logical extent 0 of file 128205 in group 1 on disk 0 allocation unit 845573
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_arc0_456667.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file "+FRA/orcl/archivelog/2024_04_04/thread_2_seq_10575.128205.1165411713", block number 67584 (block size=512)
WARNING: failed to write mirror side 1 of virtual extent 48 logical extent 0 of file 128205 in group 1 on disk 0 allocation unit 845525
ARC0: I/O error 19502 archiving log 7 to '+FRA/orcl/archivelog/2024_04_04/thread_2_seq_10575.128205.1165411713'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance orcl2 - Archival Error
ORA-16038: log 7 sequence# 10575 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
        
Thu Apr 04 12:47:37 2024
WARNING: Write Failed. group:1 disk:0 AU:831879 offset:0 size:1048576
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_arc1_318526.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
WARNING: failed to write mirror side 1 of virtual extent 166 logical extent 0 of file 129834 in group 1 on disk 0 allocation unit 831879
ARC1: Encountered disk I/O error 19502
ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '+FRA/orcl/archivelog/2024_04_04/thread_1_seq_14255.129834.1165409257' (error 19502) (orcl1)
ARC1: I/O error 19502 archiving log 3 to '+FRA/orcl/archivelog/2024_04_04/thread_1_seq_14255.129834.1165409257'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance orcl1 - Archival Error
ORA-16038: log 3 sequence# 14255 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 3 thread 1: '+DATA/orcl/onlinelog/group_3.353.1128304551'
Thu Apr 04 12:47:37 2024
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance orcl1 - Archival Error
ORA-16014: log 3 sequence# 14255 not archived, no available destinations
-----------------------------------------------------
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
WARNING: Write Failed. group:1 disk:0 AU:831879 offset:0 size:1048576
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_211812.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
WARNING: failed to write mirror side 1 of virtual extent 166 logical extent 0 of file 129834 in group 1 on disk 0 allocation unit 831879
ARCH: Encountered disk I/O error 19502
ARCH: Closing local archive destination LOG_ARCHIVE_DEST_1: '+FRA/orcl/archivelog/2024_04_04/thread_2_seq_10572.129834.1165409485' (error 19502) (orcl1)
ARCH: I/O error 19502 archiving log 8 to '+FRA/orcl/archivelog/2024_04_04/thread_2_seq_10572.129834.1165409485'
Abort recovery for domain 0
WARNING: Write Failed. group:1 disk:0 AU:844803 offset:0 size:1048576
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_arc2_212060.trc:
ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
WARNING: failed to write mirror side 1 of virtual extent 5 logical extent 0 of file 129836 in group 1 on disk 0 allocation unit 844803
ARC2: Encountered disk I/O error 19502
ARC2: Closing local archive destination LOG_ARCHIVE_DEST_1: '+FRA/orcl/archivelog/2024_04_04/thread_2_seq_10573.129836.1165409485' (error 19502) (orcl1)
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_211812.trc:
ORA-16038: log 8 sequence# 10572 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 8 thread 2: '+DATA/orcl/onlinelog/group_8.358.1128304555'
ORA-16038 signalled during: ALTER DATABASE OPEN /* db agent *//* {1:33866:2} */...


[root@oracle1 trace]#  strings /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_arc2_212060.trc |more
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_arc2_212060.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name:    Linux
Node name:    oracle1
Release:    3.10.0-957.el7.x86_64
Version:    #1 SMP Thu Nov 8 23:39:32 UTC 2018
Machine:    x86_64
Instance name: orcl1
Redo thread mounted by this instance: 1
Oracle process number: 49
Unix process pid: 212060, image: oracle@oracle1 (ARC2)
*** 2024-04-04 12:51:24.838
*** SESSION ID:(9458.19) 2024-04-04 12:51:24.838
*** CLIENT ID:() 2024-04-04 12:51:24.838
*** SERVICE NAME:() 2024-04-04 12:51:24.838
*** MODULE NAME:() 2024-04-04 12:51:24.838
*** ACTION NAME:() 2024-04-04 12:51:24.838
Initial buffer sizes: read 1024K, overflow 832K, change 805K
*** 2024-04-04 12:51:25.696
WARNING: Write Failed. group:1 disk:0 AU:844803 offset:0 size:1048576
path:/dev/asmfra1
     incarnation:0xd36c3ae2 asynchronous result:'I/O error'
     subsys:System iop:0x7fd3d9ae1178 bufp:0x7fd3d95de000 osderr:0x0 osderr1:0x0
ORA-15080: synchronous I/O operation to a disk failed
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 1048576
WARNING: failed to write mirror side 1 of virtual extent 5 logical extent 0 of file 129836 in group 1 on disk 0 allocation unit 844803
*** 2024-04-04 12:51:25.699 4329 krsh.c
ARC2: Encountered disk I/O error 19502
[root@oracle1 trace]#

因业务紧急,将部分归档拷贝到节点一的/home/grid/目录下,在rman中crosscheck archivelog all;后,业务恢复正常。

存储端反馈正常,截图如下

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:/a/539351.html

如若内容造成侵权/违法违规/事实不符,请联系我们进行投诉反馈qq邮箱809451989@qq.com,一经查实,立即删除!

相关文章

AutoCAD之DWF三维信息提取---linux编译篇

1. 权限 1.1 给文件添加执行权限 chmod x autogen.sh1.2.给当前文件下的所有文件改变为读写执行权限 chmod 777 * -R 2.环境安装 2.1安装automake 1.4.1 安装链接 安装中遇到的问题及解决 2.2安装autoconf 2.3 安装libtool 2.4 安装Cmake(CMake包含) cmake安装在cent…

STM32—DMA直接存储器访问详解

DMA——直接存储器访问 DMA:Data Memory Access, 直接存储器访问。 DMA和我们之前学过的串口、GPIO都是类似的,都是STM32中的一个外设。串口是用来发送通信数据的,而DMA则是用来把数据从一个地方搬到另一个地方,而且不占用CPU。…

windows本地运行dreamtalk踩坑总结

dreamtalk是一个语音图片转视频的一个工具,就是给一段语音加一个头像图片,然后生成一段头像跟语音对口型的视频,其实还是很有意思的,最近阿里发布了一个类似的模型,但是还没开源,从展示视频看,阿…

酷开科技OTT大屏营销:开启新时代的营销革命

随着互联网技术的不断发展和普及,大屏已经成为越来越多家庭选择的娱乐方式。在这个背景下,酷开科技凭借其强大的技术实力和敏锐的市场洞察力,成功地将大屏转化为一种新的营销渠道,为品牌和企业带来了前所未有的商业机会。 酷开科技…

WEB3.0:互联网的下一阶段

随着互联网的发展,WEB3.0时代正在逐步到来。本文将深入探讨WEB3.0的定义、特点、技术应用以及未来展望,为读者带来全新的思考。 一、什么是WEB3.0? WEB3.0可以被理解为互联网发展的下一阶段,是当前WEB2.0的升级版。相较于2.0时代…

CentOS 各个版本下载地址

https://mirror.nsc.liu.se/centos-store/7.6.1810/isos/x86_64/ CentOS-7-x86_64-DVD-1810.iso 2018-Nov-26 00:55:20 4.2G application/octet-stream 正常版 CentOS-7-x86_64-DVD-1810.torrent 2018-Dec-03 16:03:27 85.9K application/x-bittorrent CentOS-7-x86_64-Every…

用户系统加密--Java

一个基本的用户系统如下: # 定义用户类 class User:def __init__(self, name, password):self.name nameself.password password# 创建用户列表 users []# 添加新用户 def add_user(name, password):new_user User(name, password)users.append(new_user)print…

洛谷-P1596 [USACO10OCT] Lake Counting S

P1596 [USACO10OCT] Lake Counting S - 洛谷 | 计算机科学教育新生态 (luogu.com.cn) #include<bits/stdc.h> using namespace std; const int N110; int m,n; char g[N][N]; bool st[N][N]; //走/没走 int dx[] {-1,-1,-1,0,0,1,1,1}; //八联通 int dy[] {-1,0,1,1,-1,1…

LDF、DBC、BIN、HEX、S19、BLF、ARXML、slx等

文章目录 如题 如题 LDF是LIN报文格式文件&#xff0c;把这个直接拖到软件里面&#xff0c;可以发报文和接收报文 DBC是CAN报文格式文件&#xff0c;把这个直接拖到软件里面&#xff0c;可以发报文和接收报文 BIN文件烧录在BOOT里面&#xff08;stm32&#xff09;&#xff0c…

【前端】解决前端图表大数据配色难题:利用HSL动态生成颜色方案

解决前端图表大数据配色难题&#xff1a;利用HSL动态生成颜色方案 在数据可视化项目中&#xff0c;尤其是当需要绘制包含大量数据点的图表时&#xff0c;一个常见的挑战是如何为每个数据点分配一个独特而又视觉上容易区分的颜色。使用固定的颜色列表可能在数据点数量超过列表限…

CTF-SHOW SSRF

web351 存在一个flag.php页面&#xff0c;访问会返回不是本地用户的消息&#xff0c;那肯定是要让我们以本地用户去访问127.0.0.1/flag.php web352 代码中先判断是否为HTTP或https协议&#xff0c;之后判断我们传入的url中是否含有localhost和127.0.0&#xff0c;如果没有则…

课时93:流程控制_函数进阶_综合练习

1.1.3 综合练习 学习目标 这一节&#xff0c;我们从 案例解读、脚本实践、小结 三个方面来学习。 案例解读 案例需求 使用shell脚本绘制一个杨辉三角案例解读 1、每行数字左右对称&#xff0c;从1开始变大&#xff0c;然后变小为1。    2、第n行的数字个数为n个&#xf…

Golang | Leetcode Golang题解之第24题两两交换链表中的节点

题目&#xff1a; 题解&#xff1a; func swapPairs(head *ListNode) *ListNode {dummyHead : &ListNode{0, head}temp : dummyHeadfor temp.Next ! nil && temp.Next.Next ! nil {node1 : temp.Nextnode2 : temp.Next.Nexttemp.Next node2node1.Next node2.Nex…

项目实训2024.04.12日志:Self-QA生成问答对

1. Self-QA技术 1.1. 为什么要用Self-QA技术 关于为什么要搜集问答对&#xff0c;我在创新实训2024.04.07日志&#xff1a;提取QA对这篇文章中提到过&#xff1a;训练大模型需要从业务侧积累的问题、资料、文档中提取出一些指令-问答对作为输入的语料。 之前我们对于问答对的…

ChatGPT加持,需求分析再无难题

简介 在实际工作过程中&#xff0c;常常需要拿到产品的PRD文档或者原型图进行需求分析&#xff0c;为产品的功能设计和优化提供建议。 而使用ChatGPT可以很好的帮助分析和整理用户需求。 实践演练 接下来&#xff0c;需要使用ChatGPT 辅助我们完成需求分析的任务 注意&…

【编程】C++ 常用容器以及一些应用案例

介绍一些我常用的C容器和使用方法&#xff0c;以及使用案例。blog 1 概述 容器&#xff08;Container&#xff09;是一个存储其他对象集合的持有者对象。容器以类模板实现&#xff0c;对支持的元素类型有很大的灵活性。容器管理元素的存储并提供多个成员函数来访问和操作元素…

鸿蒙OS开发学习:【第三方库调用】

介绍 本篇Codelab主要向开发者展示了在Stage模型中&#xff0c;如何调用已经上架到[三方库中心]的社区库和项目内创建的本地库。效果图如下&#xff1a; 相关概念 [Navigation]&#xff1a;一般作为Page页面的根容器&#xff0c;通过属性设置来展示页面的标题、工具栏、菜单。…

OpenHarmony编译构建系统

这篇来聊聊OpenHarmony的编译构建&#xff0c;经过前面的实践&#xff0c;再来看编译构建。 编译构建概述 在官网中提到了&#xff0c;OpenHarmony编译子系统是以GN和Ninja构建为基座&#xff0c;对构建和配置粒度进行部件化抽象、对内建模块进行功能增强、对业务模块进行功能…

二叉树-数据结构

二叉树-数据结构 二叉树是属性结构的一个重要类型。 如下图二叉树形状 二叉树特征如下&#xff1a; 1.二叉树由 n(n > 0) 个节点组成 2.如果 n 为 0&#xff0c;则为空树 3.如果 n 1&#xff0c;则只有一个节点称为根节点(root) 4.每个节点最多有两个节点&#xff0c;节…

【题目】【信息安全管理与评估】2022年国赛高职组“信息安全管理与评估”赛项样题2

【题目】【信息安全管理与评估】2022年国赛高职组“信息安全管理与评估”赛项样题2 信息安全管理与评估 网络系统管理 网络搭建与应用 云计算 软件测试 移动应用开发 任务书&#xff0c;赛题&#xff0c;解析等资料&#xff0c;知识点培训服务 添加博主wx&#xff1a;liuliu548…