问题描述
我已经在Windows 07上安装了Oracle 11g，一切运行正常.但是今天，它却给我一个错误提示 ORA-01033:ORACLE初始化或关闭中.我按照不同社区中提到的步骤进行操作，但是无法解决错误.以 sqlplus sys/sys身份以sysdba 连接后.并执行以下语句，我得到以下错误.如何解决此错误?
I had installed Oracle 11g on windows 07,everything was working fine.But today it is giving me an error saaying ORA-01033: ORACLE initialization or shutdown in progress . I followed the steps mentioned in the different communities but unable to solve the error. After connecting as sqlplus sys/sys as sysdba. and executing below statement,i got following error. How to solve this error?
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 9: 'C:\APP\MKHATAL\ORADATA\ORCL\VELODBDATA.DBF'
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: 'C:\APP\MKHATAL\ORADATA\ORCL\VELODBDATA.DBF'
提前谢谢！
推荐答案
需要更多信息才能解决类似问题.这样的问题很有趣:
There's more info needed to be able to solve similar issues. Questions like these are interesting to get answered:
- 您可以将数据库启动到什么级别?无，无安装，挂载或打开(在这种情况下，不包括最后一个)
- ALERT.LOG文件显示什么?从第一刻开始怀疑是问题所在
- 一个明显的问题是:发生了什么事?你在做什么看到第一条错误消息时该怎么做?
- 可以关闭数据库吗?如果是，哪种方法:正常，立即还是仅中止?知道使用ABORT停止数据库选择可能会使问题更加严重.
- 您是否尝试过重启服务器?这是一个特别的问题Windows，您的情况就是如此.
- 根据您停止数据库的方式，是否进行冷备份?
- 取决于RMAN仍然有效:您可以备份吗?您尝试的恢复还不错，但是了解该文件在OS级别上正在发生的事情可能会很有趣.在那里吗?是，是否锁定?操作系统是否认为这是有效文件?
- To what level can you start the database ? None, nomount, mount oropen (exclude the last one in this case)
- What does the ALERT.LOG file show ? This from the moment the firstissue is suspected to be around
- An obvious question is just : what happened ? What action were youdoing when you saw the first error message ?
- Can you shutdown the database ? If yes, which methods : normal,immediate or abort only ? Know that stopping the database with ABORToption may make problems bigger as they are already.
- Did you try rebooting the server ? This is particularly an issue onWindows, which is your case.
- Depending on how you stopped the database, do you have a cold backup?
- Depending on RMAN still working : can you take a backup ? The RECOVERY you were trying is not bad, but it could be interesting to know what is happening on OS level with that file; Is it there ? If yes, is it locked or not ? Does the OS think it's a valid file ?
这篇关于Oracle Shutdown错误ORA-01033的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！