我的数据库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
这是什么错误,是数据文件损坏了吗?如何解决?
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
这是什么错误,是数据文件损坏了吗?如何解决?
startup mount
alter database datafile 2 offline drop
alter database open;
backup database;
startup force