我的数据库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
这是什么错误,是数据文件损坏了吗?如何解决?
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'.
