ORA-01151: use media recovery to recover block

ORA-01151: use media recovery to recover block, re
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 13 21:19:27 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1241513984 bytes
Fixed Size 2020416 bytes
Variable Size 268438464 bytes
Database Buffers 956301312 bytes
Redo Buffers 14753792 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 93834 of file 3
ORA-01151: use media recovery to recover block, restore backup if needed
处理方法:
SQL> recover datafile 3;
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 1241513984 bytes
Fixed Size 2020416 bytes
Variable Size 268438464 bytes
Database Buffers 956301312 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21010314/viewspace-659832/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21010314/viewspace-659832/