联系:手机/微信(+86 17813235971) QQ(107644445)
标题: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
|
- IMP-00009: abnormal end of export file
- truncate sys用户表导致数据库异常恢复
- .eight加密数据库恢复
- 再一例asm disk被误加入vg并且扩容lv恢复
- _locked加密数据库恢复
- InnoDB: Database page corruption on disk or a failed file read of page恢复
- 部分oracle数据文件被加密完美恢复
- win 11.2.0.4打patch后服务无法正常启动处理
- 一键恢复ORA-01113 ORA-01110—Oracle Recovery Tools
- ora-600 kccpb_sanity_check_2故障处理
- [[email protected]].Devos加密数据库恢复
- sqlplus 报 Segmentation Fault故障分析