今天电脑非常卡,强制重启后,发现oracle 11g启动不了了,提示错误:
ERROR - ORA-01033 oracle initialization or shutdown in progress
解决步骤
首先sysdba账号登录下
很长时间没登录了,发现sys的密码忘记了,于是第一步,修改sys账号的密码:
orapwd file=%ORACLE_HOME%\database\PWDsid.ora password=zyh123
登录
conn sys/zyh123 as sysdba
关闭数据库
SQL> shutdown normal
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 2555445248 bytes
Fixed Size 2283944 bytes
Variable Size 637535832 bytes
Database Buffers 1895825408 bytes
Redo Buffers 19800064 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 680 of file 3
ORA-01151: use media recovery to recover block, restore backup if needed
ORA-01172、ORA-01151错误处理
错误原因:一般为存储异常断电,导致数据库启动报ORA-01172错,导致数据库无法open
http://dreamsanqin.blog.51cto.com/845412/1218702
SQL> recover datafile 3;
Media recovery complete.
重启数据库
SQL> alter database open;
Database altered.
问题解决,连接可用
参考资料
- Oracle-01033错误处理
- [ORA-01172、ORA-01151错误处理](http://dreamsanqin.blog.51cto.com/845412/1218702)