Oracle Shutdown错误ORA-01033 [英] Oracle Shutdown error ORA-01033

问题描述

我已经在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 or open (exclude the last one in this case)
• What does the ALERT.LOG file show ? This from the moment the first issue is suspected to be around
• An obvious question is just : what happened ? What action were you doing 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 ABORT option may make problems bigger as they are already.
• Did you try rebooting the server ? This is particularly an issue on Windows, 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！