八、ORA-01172 and ORA-01151

king's blog

问题描述:启动oracle服务时,报ORA-01172和ORA-01151错误

启动oracle服务时,报ORA-01172和ORA-01151错误,如下:
ORA-01172

原因分析:

主要还是oracle的介质被损坏,需要重新恢复

解决方案:

按如下步骤进行操作:
SQL>sqlplus / nolog
SQL>conn sys as sysdba
SQL>startup mount
SQL>alter database open read only;
SQL>recover database
SQL>shutdown immediate
SQL>startup

详细过程如下:
ORA-01151

Tags:
文 / 甲乙丙丁
LEAVE A REPLY

loading