标签云
asm mount asm恢复 asm 恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币 oracle 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (93)
- 数据库 (1,498)
- DB2 (22)
- MySQL (64)
- Oracle (1,374)
- Data Guard (42)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (154)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (12)
- ORACLE 21C (3)
- Oracle ASM (63)
- Oracle Bug (7)
- Oracle RAC (44)
- Oracle 安全 (6)
- Oracle 开发 (26)
- Oracle 监听 (26)
- Oracle备份恢复 (478)
- Oracle安装升级 (76)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (71)
- PostgreSQL (13)
- PostgreSQL恢复 (3)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (32)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (15)
-
最近发表
- Oracle 启动后一会儿就挂掉故障处理—ORA-600 17182
- 断电引起的oracle数据库异常恢复
- 等保修改oracle SYS用户名要求的请注意—ORA-00600 kokasgi1
- ORA-07445 opiaba—绑定变量超过65535导致实例crash
- Buffer I/O error on dev故障数据库恢复
- 12.1.0.2最新patch—202301
- 11.2.0.4最新patch信息—202301
- 网卡异常导致数据库实例启动异常
- 最新版oracle dul工具
- 误删除asm disk导致磁盘组无法mount数据库恢复
- .eight加密数据库恢复
- win强制修改盘符导致oracle异常恢复
- 再一例asm disk被误加入vg并且扩容lv恢复
- 重建control遗漏数据文件,reseltogs报ORA-1555错误处理
- InnoDB: Database page corruption on disk or a failed file read of page恢复
- _locked加密数据库恢复
- 部分oracle数据文件被加密完美恢复
- ORA-600 kcbzpbuf_1故障恢复
- Oracle 19c 断电异常恢复
- Oracle Recovery Tools快速恢复ORA-19909
友情链接
标签归档:Buffer I/0 error on dev恢复
Buffer I/O error on dev故障数据库恢复
客户对虚拟化环境进行物理机加内存,结果发现数据库服务器无法正常启动,报Buffer I/O error on dev错误
通过对底层虚拟化磁盘进行分析,确定vg为centos,数据所在的磁盘组为root

进一步恢复其中数据

然后顺利打开数据库,数据0丢失
[oracle@xifenfei u01]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 13 23:27:42 2023 Version 19.13.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1.0100E+10 bytes Fixed Size 13625520 bytes Variable Size 6241124352 bytes Database Buffers 3825205248 bytes Redo Buffers 19927040 bytes Database mounted. Database opened. SQL> select status,count(1) from v$datafile group by status; STATUS COUNT(1) ------- ---------- SYSTEM 1 ONLINE 21