Oracle-01033错误处理

今天电脑非常卡,强制重启后,发现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.

问题解决,连接可用

参考资料

上一篇:2018天猫双11各类目品牌成交额top10排行榜


下一篇:Windows 10 企业版将支持通过虚拟机运行 Edge