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>
阅读(1947) | 评论(0) | 转发(0) |