前言:数据库没有执行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??
 
