ORA-01172 ORA-01151

时间:2025-02-13 19:34:02

今天发现服务器的9号硬盘坏了,因做了RAID5,报障后也没理会,过了一会儿,有人反应说报表运行不出来,发现服务器所有的硬盘都不工作了,界面也没有反应,就强行关机,再开机可以进入系统,等维修人员来换了新硬盘,启动数据库的时候报错:

SQL> startup
ORACLE instance started. Total System Global Area 5.2127E+10 bytes
Fixed Size 2193296 bytes
Variable Size 9126807664 bytes
Database Buffers 4.2950E+10 bytes
Redo Buffers 48136192 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 119509 of file 75
ORA-01151: use media recovery to recover block, restore backup if needed

这个问题不难,执行恢复即可:

SQL> recover datafile 75;
Media recovery complete.
SQL> alter database open; Database altered.

备份很重要,特别是要打开归档模式。