ORA-01172、ORA-01151错误处理

jiawang

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1124073472 bytes

Fixed Size                  1218968 bytes

Variable Size            385877608 bytes

Database Buffers          721420288 bytes

Redo Buffers              15556608 bytes

Database mounted.



打开数据库发现报错

SQL> alter database open;

ORA-01172: recovery of thread 1 stuck at block 6251 of file 6

ORA-01151: use media recovery to recover block, restore backup if needed

SQL> recover datafile 6;

Media recovery complete.

SQL> alter database open;

Database altered.