前言:数据库没有执行drop某个表空间,手动删除dmp文件,导致无法正常启动orcl
?
解决思路,删除文件了里相关的dmp关联。
解决过程如下
- Microsoft?Windows?[版本?6.1.7600]??
- 版权所有?(c)?2009?Microsoft?Corporation。保留所有权利。??
- ??
- C:\Users\守望幸福>?set??oracle_sid=orcl??
- ??
- C:\Users\守望幸福>sqlplus??"/as?sysdba"???
- SQL*Plus:?Release?10.2.0.1.0?-?Production??on??星期三?12月?19?09:55:54?2012 ?
- Copyright?(c)?1982,?2005,?Oracle.???All??rights?reserved. ?
- ??
- 连接到:??
- Oracle??Database??10g?Enterprise?Edition?Release?10.2.0.1.0?-?Production??
- With??the?Partitioning,?OLAP??and??Data?Mining?options??
- ??
- SQL>?shutdown?immediate??
- ORA-01109:?数据库未打开 ?
- 已经卸载数据库。??
- ORACLE?例程已经关闭。??
- SQL>?startup??
- ORACLE?例程已经启动。??
- ??
- Total?System??Global??Area??612368384?bytes??
- Fixed??Size???????????????????1250428?bytes??
- Variable??Size??????????????243272580?bytes??
- Database??Buffers??????????360710144?bytes??
- Redo?Buffers????????????????7135232?bytes??