100分请教真正的牛人!

[青盟日志]

我的数据库down掉了,在重启数据库的过程中出现
SQL> Connected.
SQL> SQL> ALTER DATABASE open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 153 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed
这是什么错误,是数据文件损坏了吗?如何解决?

[CathySun118]

http://www.itpub.net/271115,1.html

[NekChan]

如果你选择了归档模式，可以直接修复一下它的数据块。

[NekChan]

If you don't have the backup, then try open the database by taking the datafile '3' offline. Since you've created the database recently, instead of recreating the entire database what you can do is drop and recreate the tablespace which holds the datafile '3'.

[青盟日志]

我现在已把undotbs01.dbf offline掉,然后打开了数据库,把数据exp了出来,但是在exp的过程中报了很多错.也不知道丢失数据没有.

[fjmingyang]

pfile 中： _corrupted_rollback_segments=true
startup mount
alter database datafile 2 offline drop
alter database open;
backup database;

[青盟日志]

我如何修复undotbs01.dbf啊，我数据库是归档模式

[lixin5678]

如果数据无关紧要，可以用
startup force