标签归档：Buffer I/0 error on dev恢复

Buffer I/O error on dev故障数据库恢复

发表于 2023 年 3 月 13 日 由 惜分飞

客户对虚拟化环境进行物理机加内存,结果发现数据库服务器无法正常启动,报Buffer I/O error on dev错误
buffer io error

通过对底层虚拟化磁盘进行分析,确定vg为centos,数据所在的磁盘组为root
20230313213019
进一步恢复其中数据
20230313233918
然后顺利打开数据库,数据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
发表在 Oracle备份恢复 | 标签为 , | 评论关闭