ORA-01172

SQL> startup;
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  1220432 bytes
Variable Size             503316656 bytes
Database Buffers         1627389952 bytes
Redo Buffers               15556608 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 1571 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed

 

解决方法：

SQL> startup mount;
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  1220432 bytes
Variable Size             503316656 bytes
Database Buffers         1627389952 bytes
Redo Buffers               15556608 bytes
Database mounted.
SQL> recover database;
Media recovery complete.
SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  1220432 bytes
Variable Size             503316656 bytes
Database Buffers         1627389952 bytes
Redo Buffers               15556608 bytes
Database mounted.
Database opened.